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,
- 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
NOTE: This is a 2 part podcast. Listen to first part before hearing this.
Go ahead and listen to the show
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
Links & Resources mentioned in this session:
Average Formula – Syntax, examples
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.
Subscribe to Chandoo.org Podcast
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.
- For iPhone or iPod or iPad: Click here to subscribe.
- Andriod Phones & Tabs: Click here to subscribe on Stitcher. (You can download Stitcher free app from that link)
- Windows Phone: For Windows phone, search your podcasts app for our show.
- Or… As always, you can get latest episodes, show notes & resources from our Podcast page.
2 Responses to “Weighted Sorting in Excel ”
Just add a column calculating the "performance" or whatever is your criteria and sort by it? No?
have no patience to waste 13min. Save your time too.
Just thought I would mention, the "weird" custom sort behavior mentioned at 5:45 where "% return" doesn't appear to be sorting is because the "August Purchases" field has the sort preference and since these are such unique values, no additional sorting is possible on the "% return" field. If there were two entries that had the same "Customer Since" year AND the same "August Purchases" amount, THEN you would see a sorting of the "% return" on these two entries.