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

Category:

Education

Tags:

• Excel
• 2007
• Statistics
• BOX
• PLOT
• OUTLIERS
• ABS
• function
• Stacked
• Bar
• Chart
• Mike
• Gel
• excelisfun
• Girvin
• Highline
• Community
• College

[oldcoder9000]

Excellent video. You are an excellent teacher.

[ExcelIsFun]

@oldcoder9000 , Thanks! I am glad that you liked the video!

[a3aan88]

Great video, it is very helpfull to me! I only have one question, can you explain why the z-score is 3? Is this always 3 or just in this case?

[ExcelIsFun]

@a3aan88 , z is just the number of standard devaitions and 3 is just one possibility; however, 3 standard devaitions should be a rare event and so it is sometimes used as the hurdle to determine outliers. Here is a video about z:

Excel & Statistics 45: Z-Score (# Standard Deviations From Mean)

or

Excel 2010 Statistics #31: z-Scores, Chebyshev's Theorem and Empirical Rule

[basicphase]

this helped me so much when trying to remove outliers! while some were very minor, others made a big enough difference to be valid. and i did catch some statistical errors i made as well.

thank you!

[ExcelIsFun]

You are welcome!

[RakonKido]

why do people write 7 like that? >=O

[adriferr11235]

I've been using Excel for decades and I never knew about using F4 to refer to a specific cell. Extremely useful, thanks!

[The4lbanian]

you sounds like ross from friends

[ExcelIsFun]

Created formulas in cells for as many as you want, created first chart, then go to Select Data Source dialog box and add extra series (extra box plot data).