Weighted Averages: SUMPRODUCT ÷ SUM, Weighted Unit Costs, Weighted Scores & the 100 % Check
This lesson is part of the course
In this lesson
You cost six deliveries of one product, compute the true weighted average unit cost with SUMPRODUCT ÷ SUM, score a training course with percentage weights and again with weights given as points.
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