Classof1.com , classofone, class of 1, class of one, classofone.com
Toll free: 1- 877- 252 - 7763 | Fax: 1- 425- 458- 9358
 
View Cart Your Cart | 0  Item(s)
Original Price: $5.99 Now at: $2.99 Reads (231)

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. In particular, be sure that the x-axis is properly labeled.

Evaluate your histograms for any outliers in your data. Based on your evaluation of outliers, you may trim no more than 1% of the data contained in the data set. This must be done symmetrically (i.e., trimming no more than 0.5% off the top and 0.5% off the bottom).

Reproduce the histograms with the data points that remain after you have completed your trimming. Calculate the mean, median, and standard deviation of the trimmed data. What change did the trimming make in these measures?

All the rest of your calculations for this portion of the project should be done with this trimmed data.


Click here to download the question
Attached file(s)
Solution Attachment
Solution documents are in Excel and Word formats

Original Price: $5.99 Now at: $2.99

Comments

No comments found
Drawing Histogram using Analysis Tools of Excel and detecting the outliers | Solution Library Search