The following data were collected on scores (out of a possible 100) for a pretest in quantity methods. Using Excel's 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 sets?
d) Construct a histogram for each data se, using 5 as your class with 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 histograms in part d.
f) Which data set is more stable. Base your answer on standard deviation values. Compare both frequency histograms and which shows a normal distribution behavior?