Moving & Weighted Moving Averages: 3- and 5-Week Windows, Linear Weights & the Lag
This lesson is part of the course
In this lesson
You smooth twelve weeks of orders with a 3-week and a 5-week moving average, build a linearly weighted 3-week average with SUMPRODUCT and measure how far a long window lags behind a rising trend.
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