Question

Use Excel to find the requested measures of center and spread for the following sample data set. You should be able to select the table and copy it directly to Excel. 63.7 69.5 73 76.8 81.1 85.4 92 96.6 79.6 88.3 61.4 77.6 85.7 83.1 74.3 84.7 88.6 68.8 84 75.6 70.2 79.6 89 76.5 84.4 73.3 78.8 63.6 86.7 72 71.7 82.2 89.4 80.8 92.4 78.2 77.8 76.3 72.4 66.8 70.6 74.9 82.2 75.6 71 74.9 68.2 86.2 88 71.4 80 89 81.6 89.8 67.6 87.6 68.2 74.6 77.6 86.7 89.8 66 76.7 75.1 73.5 93.2 78.2 78.4 82.4 65 What is the mean of this data set? mean = Report answer to 2 decimal places. What is the median of this data set? median = Report answer to 2 decimal places. What is the maximum of this data set? max = What is the minimum of this data set? min = What is the mid-range of this data set? mid-range = What is the range of this data set? range = Report the standard deviation using the rounding rules suggested in class (two more decimal places than the data reports). standard deviation = Report answer to 3 decimal places.

15.

Answer 1

In excel, you can find the descriptive statistics,

First go to data analysis tab --> descriptive statistics --> select the columns and output ---> summary statistics then you will get following output.

Column1
Mean	78.51286
Standard Error	0.979832
Median	78
Mode	79.6
Standard Deviation	8.19786
Sample Variance	67.2049
Kurtosis	-0.73079
Skewness	0.033055
Range	35.2
Minimum	61.4
Maximum	96.6
Sum	5495.9
Count	70

Mean = 78.51

Median = 78

Maximum = 96.6

Minimum = 61.4

Mid-range is the value of the arithmetic mean of the largest and the smallest values in given sample.

Mid-range = (96.6+61.4)/2 = 79

Range = 35.2

Standard deviation = 8.198