support@chatgptassignment.com

83 99 96 62 93 58 Using Excel, find the mean, standard deviation, and 5-number

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. (1) What is the difference between a normal distribution (symmetrical data) and a skewed distribution (asymmetrical data?) (2) In order for data to be asymmetrical does it need to contain outliers? Why or why not? Explain your answer. (3) What is an outlier and when do we decide to use it as part of the viable outcome? Explain your answer.