getanswer

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. Accordingly, the most frequent measures of variability are standard deviation and interquartile range. The attached Excel data file shows a sample of Civil Service examination scores from 24 applicants to law enforcement jobs:A. Use Excel to calculate the means, sample standard deviation, and the five-number summary of this data. Examples of the calculations are in the data file. The five-number summary includes Min, Quartile 1, Median, Quartile 3, and Max.B. Select the data in the Scores column. Then, use Insert > Insert Statistic Chart > Box and Whisker. Finish the chart with an x- and y-axis label. Paste the chart. This chart depicts the five-number summary and outliers. (Refer to LO 4-8). C. Review the box and whisker plot. Does it indicate outliers? If so, which one(s)? Are any considered extreme outliers?D. Would you choose to use the mean or the median as the dataset’s central tendency measure? What makes that determination? Explain. (Refer to LO 4-2).Using the means to describe data that is extremely skewed would be deceptive and ethically incorrect.