All articles with 'standard deviation' Tag

CP010: Averages are Mean – 8 Techniques for making your analysis above average

Published on May 30, 2014 in Chandoo.org Podcast Sessions, Learn Excel
CP010: Averages are Mean – 8 Techniques for making your analysis above average

This is a continuation of Session 9 – Averages are mean

In the earlier episode, we talked about AVERAGE and why it should be avoided. In this session, learn about 8 power analysis techniques that will lift your work above averages.

In this podcast, you will learn,

  • Re-cap – Why avoid averages
  • 8 Techniques for better analysis
  • #1: Start with AVERAGE
  • #2: Moving Averages
  • #3: Weighted Averages
  • #4: Visualize the data
  • Conclusions
Continue »

CP009: Averages are Mean – Know these things before you make any more AVERAGE()s

Published on May 22, 2014 in Chandoo.org Podcast Sessions
CP009: Averages are Mean – Know these things before you make any more AVERAGE()s

In the 9th session of Chandoo.org podcast, lets raise above AVERAGEs.

AVERAGEs are a very popular and universal way to summarize data. But do you know they are mean? Mean as in, AVERAGEs do not reveal much about your data or business. In episode 9 of Chandoo.org podcast, we tackle this problem and present solutions.

In this podcast, you will learn,

  • What is AVERAGE?
  • Pitfalls of averages
  • 5 statistic concepts you must understand
    • Standard Deviation
    • Median
    • Quartiles
    • Outliers
    • Distribution of data
  • What next?
Continue »