Averaging Percentages & Ratios: Pooled Rates vs the AVERAGE of Rates
This lesson is part of the course
In this lesson
You compute the conversion rate of six stores, the pooled rate of the whole campaign and the misleading AVERAGE of the store rates, then find the overall gross margin of four product lines from totals.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Weighted Averages: SUMPRODUCT ÷ SUM, Weighted Unit Costs, Weighted Scores & the 100 % Check Locked
- Averaging Percentages & Ratios: Pooled Rates vs the AVERAGE of Rates Locked
- The Average-of-Averages Trap: Group Sizes, the True Overall Mean & Group Means from Raw Rows Locked
- Rates & the Harmonic Mean: Average Speed, Weighted Rates & Equal-Spend Buying Locked
- Growth & the Geometric Mean: Growth Rates, Average Annual Growth & Why AVERAGE Overstates It Locked
- Time-Weighted Averages: Days at Each Balance, the Average Balance & Interest on It Locked
- Moving & Weighted Moving Averages: 3- and 5-Week Windows, Linear Weights & the Lag Locked
- Weighted Median & the Averages Dashboard: Cumulative Weights, Mean vs Median & a Chart Locked