The following data were collected on scores (out of a possible 100) for a pretest in quantitative methods. Using Excels statistical functions complete the following questions.
Arrivals
Data Set 1 Data Set 2
95 75 68 45 25 18
102 67 65 62 17 15
99 87 94 49 37 54
88 120 81 48 70 31
100 71 104 50 21 54
a. What are the means for the two data sets?
b. What are the medians for the two data sets? Is there a difference or similarity between the mean and the median? Explain the similarity or difference?
c. What are the standard deviations for each of the data set?
d. Construct a histogram for each data set, using 5 as your class width and starting with 60 as your lowest class for data set 1 and 10 for data set 2.
e. Relate the standard deviation you calculated in part c to your.