Time-Series Basics: MoM, YoY and CAGR
All lessons
- Time-Series Basics: MoM, YoY and CAGRFree
- Moving Averages, Weighted Averages & Exponential Smoothing Pro
- Seasonality: a Seasonal Index for Every Month Pro
- Deseasonalising & Reseasonalising Pro
- Linear Trend: TREND, FORECAST.LINEAR, SLOPE & INTERCEPT Pro
- Trend × Seasonality: the 12-Month Forecast Pro
- Forecast Accuracy: MAE, MAPE, Bias & Tracking Signal Pro
- Driver-Based Scenarios vs the Statistical Forecast Pro
You are not signed in — the lab works, but your progress is not saved. Start free
Read first
See the pattern first
- Plot the series as a line chart before you calculate anything. Trend, season, outliers and level shifts are obvious in a picture.
- Put each year as its own line (months on the axis) and seasonality jumps out: every year peaks in December and dips in February.
- YoY needs 12 months of history, so the first year has no YoY value. Leave those cells empty rather than 0.
- Growth of a rate (margin from 40% to 43%) is said in percentage points: +3 pp, which is +7.5% in relative terms.
Loading the spreadsheet…