Question

Respond to the following in a minimum of 175 words: The most frequently used measures of central tendency for quantitative data are the mean and the median. The following table shows civil service examination scores from 24 applicants to law enforcement jobs: 83 74 85 79 82 67 78 70 18 93 64 27 93 98 82 78 68 82 83 99 96 62 93 58 Using Excel, find the mean, standard deviation, and 5-number summary of this sample. Construct and paste a box plot depicting the 5-number summary. Does the dataset have outliers? If so, which one(s)? Would you prefer to use the mean or the medianas this dataset’s measure of central tendency? Why?

Answer 1

Sample mean using excel function AVERAGE(), x̅ = 75.5

Sample standard deviation using excel function STDEV.S, s = 19.9913

5 point summary:

Minimum = 18

First quartile, Q1 = 0.25(n+1)th value = 6.25th value of sorted data = 67.25

Median = 0.5(n+1)th value = 12.5th value of sorted data = 80.5

Third quartile, Q3 = 0.75(n+1)th value = 18.75th value of sorted data = 91

Maximum = 99

Yes, the data set have outliers.

Outliers: 18, 27

We would prefer median for this data set.as if is not affected by the presences of outliers.