Question

A math teacher asked each of her students how far he or she lived from campus. The data collected are given below. Use Excel to calculate all requested statistics.

Miles from campus 2 5 2 7 1 3

A. What is being measured in the data given above?

B. Using Excel, obtain the three measures of central tendency.

C. Using Excel, obtain the two measures of dispersion.

D. Provide an interpretation for the sample standard deviation obtained in part C.

E. Obtain the z-scores from the original scores.

F. What percentage of original scores are expected to be in the range 2 to 5?

G. What percentage of z-scores are expected to be in the range 0 to +1.70?

H. What percentage of z-scores are expected to be in the range -.50 to +1.70?

Answer 1

(A) We are measuring the distance (in miles) between a student's home and the campus. The sample here contains the data of 6 students.

(B) Mean = 3.33, Median = 2.5, Mode = 2.

(C) Variance = 5.067, SD = 2.25

(D) On an average, the value of the distances are 2.25 miles away from the mean value of 3.33 miles.

(E) Z-scores = -0.592, 0.740, -0.592, 1.629, -1.037, -0.148

(F) Percentage = 4/6 * 100 = 66.67%

(G) Percentage = 2/6 * 100 = 33.33%

(H) Percentage = 3/6 * 100 = 50%