Monday 29 June 2009

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

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


Video:


Description: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 XY 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 and Economics Statistics/Excel class, Busn 210 at Highline Community College taught by Michael Gel Excelisfun Girvin

Published:
30/Jun/2009

No comments:

Post a Comment