Excel Magic Trick #11: How Good Is Your Average?

Excel! Learn 3 types of Variation measures including Standard Deviation. See how to determine whether your average fairly represents its data points and how spread out the data points are! See how to use the functions: STDEV, VAR and AVEDEV. Also, see how to name multiple ranges with just one keyboard shortcut!

Category:

Science & Technology

Tags:

• Excel
• AVERAGE
• STDEV
• standard
• deviation
• variation
• spread
• VAR
• AVEDEV
• relative
• cell
• mike
• gel
• Girvin
• highline
• community
• coll

[55YuanYuan]

Thanks a lot for these great videos. You are amazing. How did you insert the scatter graph with all the data and average in this video? I tried but failed.

[ExcelIsFun]

@55YuanYuan , this vid shows how:

Excel 2010 Statistics #30: Standard Deviation: How fairly does the mean represent its data points?

[Zabarilo]

Now I get it. You are doing the excel version of dr brown the photoshop guy. I must say your video are far better. Probably cause Dr brown works for adobe and will rave about anything even the fantastic smoothness of photoshop crashing. Way to go buddy. Thanks a lot for these.

[ExcelIsFun]

You are welcome!!

[pbelero]

You sir are insane and utterly great. Thank you enormously. I shall complete my studies at your feet.

[ExcelIsFun]

If you like Excel and Statistics, search and watch this video title to see how to find the 150 Statitics videos that I have posted:

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

[carrentalsg]

thanks for the video.

[ExcelIsFun]

watch this video title:

Excel & Statistics 39: Variability Chart - Visual Approach (Dispersion or Spread)

[violetacomillas]

how did you make the chart?

[ExcelIsFun]

Thanks harsh010!

You see, when you learn so many cool and rad Excel Tricks, you can save so much time with all your daily tasks that you can then try and show others some of the cool and rad Excel Tricks!

--ExcelIsFun