Excel Statistics 34: MEAN, MEDIAN, MODE (Averages)

Learn about MEAN, MEDIAN, MODE. These measures give us a typical value, a measure of central tendency one value that can represent all the data points. See:
1) SUM, COUNT, AVERAGE functions for Mean
2) MEDIAN function and sorting to find median
3) MODE function (has problems) and a Frequency Table with a Pivot Table to find Mode.

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
• MEAN
• MEDIAN
• MODE
• Averages
• Typical
• Values
• Mike
• Gel
• excelisfun
• Girvin
• Highline
• Community
• College

[LondonLove94]

thankyou this was really helpful!

[ExcelIsFun]

You are welcome!

[jredrocker]

Why does it only show 1 mode when you use the mode function when it is bimodal? I noticed it shows the largest value of the modes.

[ExcelIsFun]

MODE can only show one. For more, see this video:

Excel Magic Trick 536: List All Modes in Multimodal Data Set MODE.MULT Excel 2010 Function

[rakbat]

where can i download it

[ExcelIsFun]

Seacrh for and watch this video title:

excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks

[Nyxtia]

@midend So's apartment :P

[midend]

lol average is spelt wrongly ;o

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

I am glad that you like it.