EXCEL HOMEWORK DUE IN 36 HOURS

 DUE IN 36 HOURS

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?