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.