In the 10th session of Chandoo.org podcast, lets make your analysis above AVERAGE.
What is in this session?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,
NOTE: This is a 2 part podcast. Listen to first part before hearing this.
Average Formula – Syntax, examples
Moving Average in Excel
Weighted Average in Excel
Special cases:
Statistics & Probability for analyst – a guide
Transcript of this session:Download this podcast transcript [PDF].
How do you raise above average?For many of my reports I start with AVERAGE and then improve the metrics to show insights. I try weighted average, median, mode, visualizations and conditional averages.
What about you? What analytical techniques & formulas do you use apart from AVERAGE()? Please share your thoughts using comments.
Do you know that you can subscribe and receive latest episodes of our podcast right to your ears? Use one of the below links to get started.
The post CP010: Averages are Mean – 8 Techniques for making your analysis above average appeared first on Chandoo.org - Learn Excel, Power BI & Charting Online.