Excel Magic Trick #243: MEAN MEDIAN MODE STDEV Histogram

See how to calculate and interpret Mean Median Mode Standard Deviation in Excel. Create a Frequency Distribution and then a Histogram. Basic Statistics.
Mean Median Mode, and Standard Deviation
Mean Median and Mode are all Averages
The reason we have averages is because we need "ONE" value that will represent all the values so we can talk about the "typical score". All the data is so spread out that is hard to talk about 'all" the data unless we calculate a typical value. Here are three ways to calculate a typical value: Mean, Median Mode.
MEAN is the arithmetic mean (add all the scores and divide by the count). In Excel we use the AVERAGE function
MEDIAN is the one in the middle (position) after we have sorted (this is good when we have extreme values like in real estate (most of the houses are around $200,000, but a few are $1,000,000)). In Excel we use the MEDIAN function
MODE is the one that occurs most often. This is good when we have "word" categories such as preference for "cola". In Excel we use the MODE function (It will not tell you when there are more than 1 mode).
The Standard Deviation tells you: 1) how spread out the data is; 2) what the mean deviation is; 3) does the average represent its data points fairly. In Excel we use the STDEV function for a sample and the STDEVP function for a population (population is all possible values; sample is some of the values but not all).

Histogram. SUMPRODUCT COUNTIF function formula. Column Chart Ampersand Concatenate
all these functions ignore blanks or dashes. If you really want to include them you must put a zero instead of a dash or blank.

Category:

Science & Technology

Tags:

• Excel
• basic
• statistics
• Average
• median
• mode
• standard
• deviation
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[conman24life]

u are a true gangsta...love ur vid ive been skipping all my data classes but i manage to do my summatives with this vid..LOL

[ExcelIsFun]

No gangsta, just a guy having fun with Excel... LOL  I am glad that the videos help!

[charlysnoox21]

thank you for all of your work. Very appreciated. You have been helping me in my class.

[ExcelIsFun]

You are welcome! What class are you in and at what university are you attending?

[tina5514]

Thank you for your work. It helps me a lot!!!

[ExcelIsFun]

You are welcome!

[Fauvist123]

This video was very easy to follow thank you. I have a table frequency distribution I am working on but can't figure out which of your videos would be fit my data values...help :D thanks!

[sotacal]

Simple and to the point, thank you! Very educational.

[mspaulalisa]

THANKS!



[skzerk]

excell is fun....

[oceileen]

OK I figured out how to down load. This is a wonderful gift you given me! Thank you!

[oceileen]

How do i download the workbook? How do I find your youtue channel?

[Mriluvcunt1]

very useful