3 EXERCISES STATISTICS PROBABLITY

The following data were collected on scores (out of possible 100) for the pretest in quantitative methods. Using excel’s statistical functions, complete the following questions:

a. What are the means for the two data set?

Data set 1 = 87.73333

Data set 2 = 39.73333

b. What are the medians for the two data sets? Is there any different or similarity between the mean and the median? Explain the similarity or difference.

Data set 1 = 88

Data set 2 = 45

There is difference. The difference is as result of mean being average of the totals divided by number of appearance while median is middle entry for the data set.

c. What are the standard deviations for each of the data set?

Data set 1 =16.26331

Data set 2 = 17.64518

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. Related the standard deviation you calculated in part c to your histogram in part d.

Data set 1 = 0.18537

Data set 2 = 0.44409

DATA SET 1

Frequency

60-65 65-70 70-75 75-80 80-85 85-90 90-95 95-100 100-105 105-110 110-115 > 115 1 2 2 0 1 2 2 2 2 0 0 1

CLASS INTERVALS

Frequency

DATA SET 2

Frequency

10-15 15-20 20-25 25-30 30-35 35-40 40-45 45-50 50-55 55-60 > 60 1 2 2 0 1 1 1 3 2 0 2

CLASS INTERVALS

Frequency