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

Chandoo.org Podcast - Become Awesome in Data Analysis, Charting, Dashboards & VBA using Excel

Content provided by Chandoo - Microsoft Excel MVP, Training & Data Analysis Specialist, Chandoo - Microsoft Excel MVP, and Data Analysis Specialist. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Chandoo - Microsoft Excel MVP, Training & Data Analysis Specialist, Chandoo - Microsoft Excel MVP, and Data Analysis Specialist or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://player.fm/legal.

10y ago 44:20

MP3•Episode home

Archived series ("Inactive feed" status)

When? This feed was archived on June 15, 2023 14:07 (10M ago). Last successful fetch was on August 02, 2022 07:14 (1+ y ago)

Why? Inactive feed status. Our servers were unable to retrieve a valid podcast feed for a sustained period.

What now? You might be able to find a more up-to-date version using the search function. This series will no longer be checked for updates. If you believe this to be in error, please check if the publisher's feed link below is valid and contact support to request the feed be restored or if you have any other concerns about this.

In the 10th session of Chandoo.org podcast, lets make your analysis above AVERAGE.

CP010: Averages are Mean - 8 Techniques for making your analysis above average - Chandoo.org Podcast

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

Links & Resources mentioned in this session:

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.

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.

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.

57 episodes

#Business #Lets Get #Data Analysis Specialist #Chandoo - Microsoft Excel MVP