Weighted Averages: Averaging Percentages Correctly
This lesson is part of the course
In this lesson
You calculate a revenue-weighted margin with SUMPRODUCT and an overall conversion rate from totals, and see how far a plain AVERAGE is off.
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
- Percent of Total: Shares, the % Format & Absolute References Locked
- Percent Change & Growth: the Zero-Base and Negative-Base Traps Locked
- Increase or Decrease by a %, and Reverse a Percentage Locked
- Markup vs Margin: Calculate, Convert and Price to a Target Locked
- Percentage Points vs Percent (and Basis Points) Locked
- Weighted Averages: Averaging Percentages Correctly Locked
- CAGR & Annualised Rates: POWER, RRI and Compounding Locked
- % of Target, Percent Rank & a Progress Table with Conditional Formatting Locked