Response 2.

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?

**Due Day 7**

Reply to at least 2 of your classmates or your faculty member. Be constructive and professional.

RESPONSE 1.

Happy to make it to week two with you in this course and in discussion about calculating or construct, rather, a box plot depicting the 5-number summary. Using excel, the mean for all 24 law enforcement applicants is 80.5. What I did was sorted all 24 scores from smallest to largest in column A. I used =MEAN(A1;A24) formula and checked my work from adding A12 and A13 and dividing by two to get 80.5. It was the same result I got when I did the formula in excel. For Standard deviation, I used excel =STANDEV(A1:A24) formula to calculate the standard deviation of 19.993. When I tried to insert the chart, the box plot did not populate. If anyone has any recommendations, I am open to hearing them. For the discussion question, I think it would be to find the median to understand where the the group scored numerically, and then identify the tops scorers of the group and the bottom scores of the group above and below 80.5 score. Calculations can help decision makers rank applicants from top performers and down and fill limited positions based on final results from all tests initiated. Hope this makes sense and I look forward to receiving feedback.

Tasi –

Mean | 18 |

1ST QUART | 67.75 |

MEDIAN | 80.5 |

3RD QUART | 87 |

MAX | 99 |

RESPONSE 2.

For this set of data, the outliers appear to be 18 and 2 on the low end. 99 is on the highest end, but is by no means truly an outlier like 18 and 27 are. Because of the outliers, the median would be best used in this case to measure the central tendency. The mean would take the outliers in more consideration than the median does. The mean takes the sum of all the data points, and divides by the number of data points, thus taking into account 18 and 27. The median on the other hand is the actual middle number of the data set. When using Excel it is much easier to see the median, outliers, data range, etc. Excel is able to calculate all the points and key information of a data set. I also find it very helpful that you can then graph the data points in Excel. This allows for the information to be visualized clearly so that it is easier to interrupt for those, like myself, that need the visualization.