Decomposition · Free
Decompose + seasonal naive
Pull off a seasonal pattern, then naive the remainder.
What it assumes
Additive seasonal indices around a slowly moving remainder.
When to use
Teaching decomposition; stable seasonal shape.
When to avoid
Evolving seasonality or multiplicative scale.
Knobs
Seasonal means (centred) + last deseasonalized level.
How it works
Classical seasonal means (centred) estimate a repeating shape. Subtract that shape, take the last deseasonalized level, then add the seasonal indices back for future periods. It is a teaching decomposition more than a state-of-the-art engine. Evolving or multiplicative seasonality will look wrong — Holt–Winters or SARIMA may fit better, and the backtest decides.
Sample forecast question
Classroom series: subtract a quarterly seasonal pattern, hold the leftover level, then put the pattern back. What are the next four quarterly forecasts?
Step-by-step on these numbers
| Period | Actual | Fitted |
|---|---|---|
| Y1 Q1 | 12 | 12 |
| Y1 Q2 | 18 | 18 |
| Y1 Q3 | 16 | 16 |
| Y1 Q4 | 9 | 9 |
| Y2 Q1 | 13 | 12 |
| Y2 Q2 | 19 | 18 |
| Y2 Q3 | 17 | 16 |
| Y2 Q4 | 10 | 9 |
| Y3 Q1 | 14 | 13 |
| Y3 Q2 | 20 | 19 |
| Y3 Q3 | 18 | 17 |
| Y3 Q4 | 11 | 10 |
| Period | Forecast | 95% interval |
|---|---|---|
| Y4 Q1 | 14 | 13.03 – 14.97 |
| Y4 Q2 | 20 | 18.64 – 21.36 |
| Y4 Q3 | 18 | 16.33 – 19.67 |
| Y4 Q4 | 11 | 9.07 – 12.93 |
Parameters the engine found
m= 4lastDeseas= 15.750s0= -1.750s1= 4.250s2= 2.250s3= -4.750
The question
Classroom series: subtract a quarterly seasonal pattern, hold the leftover level, then put the pattern back. What are the next four quarterly forecasts? Sample quarters: Y1 Q1=12, Y1 Q2=18, Y1 Q3=16, Y1 Q4=9, Y2 Q1=13, Y2 Q2=19, Y2 Q3=17, Y2 Q4=10, Y3 Q1=14, Y3 Q2=20, Y3 Q3=18, Y3 Q4=11 (°C).
Seasonal means
Overall mean μ = 14.750. For each season, average (y − μ), then centre the indices so they sum to ~0. Indices: [-1.750, 4.250, 2.250, -4.750].
Deseasonalize
y*_t = y_t − s_{t mod m}. The last deseasonalized level is 15.75. The forecast adds the matching seasonal index back onto that level (seasonal naive on the remainder).
Forecast
Y4 Q1 = 15.75 + -1.750 = 14; Y4 Q2 = 15.75 + 4.250 = 20; Y4 Q3 = 15.75 + 2.250 = 18; Y4 Q4 = 15.75 + -4.750 = 11.
Interval
Residual σ = 0.492. For h = 1 the 95% band is [13.03, 14.97] around 14. The engine labels this a residual-Gaussian heuristic (σ√h), not a simulation interval.
Graph of this sample
The chart plots the canned table on this page (actuals, in-sample fitted, forecast, 95% interval). Not your Excel series. Free analysis never uploads raw data.
Educational only. Not investment, weather, or operational advice. In the add-in, rank is rolling-origin MASE — “best supported among candidates on this series.”