Explain drawing Histogram using Analysis Tools of Excel and detecting the outliers.
Produce histograms for both frequencies showing values on top of the bars and the correct annotation on both axes. Especially be sure that the x-axis is properly labelled.
Estimate your histograms for any outliers in your data. Based on your calculation of outliers you may trim no more than 1% of the data contained in the data set. This should be done symmetrically (that is trimming no more than 0.5% off the top and 0.5% off the bottom).
Replicate the histograms with the data points that remain after you have completed your trimming. Compute the mean and median and standard deviation of the trimmed data. What alteration did the trimming make in these measures?
All the rest of your computations for this portion of the project should be done with this trimmed data.