Weighted Sorting in Excel [video]
Imagine you are looking customer data like below and want to sort them by performance. If you sort the data by any one column, you will not get full picture of performance. To understand which customers rank low on performance, you need to defined a weighed sort, the kind of sort where you assign weights to each attribute (customer age, recent purchases and rate of returns) and come up with single score to sort them all.
Sounds interesting? Watch below video to understand how to do weighted sorting in Excel.
What is the average speed of this road trip? [Solution & Discussion]
Last week, we had an interesting homework problem – What is the average speed of this road trip?
We received more than 150 answers. But to my surprise, 57 of them are wrong. So today, lets learn how to calculate the average speed correct way.
CP010: Averages are Mean – 8 Techniques for making your analysis above average
Podcast: Play in new window | Download
Subscribe: Apple Podcasts | Spotify | RSS
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