Excel Forum

Excel & Statistics 49: Outliers & Box Plot with Median and Mean

See how to find Outliers with the +/- 3 Z-score rule and the ABS function. See how to do a Box Plot by hand and in Excel. For the Excel Box Plot see how to record MIN, QUARTILE 1, MEDAIN, QUARTILE 3, MAX, AVERAGE on a Stacked Bar Chart with the mean added as an X Y Scatter. Also see the CHAR 10 function to create label for BOX PLOT.

Chapter 03 Busn 210 Business and Economic Statistics and Excel Class. Descriptive Statistics Numerical Measures

This is a beginning to end video series for the Business & Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin

Got a Question? Ask it Here in the Forum.