Chapter 3 -Problem 8
The following data were collected on scores (out of a possible 100) for a pretest in quantitative 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 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 histograms in part d.