Skip to main content
Calcimator

Time Series Decomposition Calculator

Decompose monthly time series data into trend, seasonal, and residual components using additive or multiplicative decomposition methods.

About this calculator

This calculator fits a straight line — ordinary least-squares regression — through the twelve monthly values to extract Trend Slope and Trend Intercept (lines 14-22), then derives a Seasonal component from how far each month's actual value sits from that trend line: subtracted for Additive mode, divided for Multiplicative mode (lines 31-41), and normalized so the additive seasonal component averages to 0 or the multiplicative one averages to 1 (lines 44-54). A well-known property of ordinary least-squares regression falls straight out of this: Average Trend Value always equals the simple average of the twelve monthly inputs exactly, because a fitted regression line always passes through the mean of its x- and y-values — verified directly against the engine (a 164.17 average input produces a 164.17 Average Trend Value). December and January sit at the two extreme-leverage endpoints of the OLS slope formula — month index 12 and month index 1 are tied for the largest distance from the series' midpoint, and therefore the largest weight in the slope calculation — but December's default value (140) exceeds January's (120), and with leverage tied, whichever of the two starts from the larger number ends up moving Trend Slope more when the same percentage change is applied to both, which is why December edges out January.

Seasonal Strength is computed through a decompositionType-gated ternary whose two branches are textually identical (lines 71-73) — both evaluate maxSeasonal minus minSeasonal regardless of mode — so the difference you actually see between Additive and Multiplicative Seasonal Strength comes entirely from maxSeasonal and minSeasonal themselves differing upstream, not from anything mode-specific at that particular line. This calculator does not detect or adjust for a seasonal pattern that shifts partway through the year — it fits one trend line and one fixed seasonal index per month across the whole twelve-month window.

Inputs

Results

Trend Slope

2.48

Seasonal Strength

82.41

MethodAdditive
Trend Intercept148.03
Average Trend Value164.17
Max Seasonal Index44.59
Min Seasonal Index-37.82
How to Use This Calculator
  1. Enter time series data with dates and values.
  2. Select the decomposition model: additive or multiplicative.
  3. Enter observed values for each of the 12 months (fixed annual seasonality).
  4. Review the trend, seasonal, and residual components.
  5. Use the trend component for forecasting and the residual to identify anomalies.

How the result changes with December

DecemberTrend SlopeSeasonal Strength
70-0.21138.95
1051.14110.68
2105.1780.7
35010.56189.44

What each input means

January
Observed value for January.
February
Observed value for February.
March
Observed value for March.
April
Observed value for April.
May
Observed value for May.
June
Observed value for June.
July
Observed value for July.
August
Observed value for August.
September
Observed value for September.
October
Observed value for October.
November
Observed value for November.
December
Observed value for December.
Decomposition Type
Additive: Y = T + S + R. Multiplicative: Y = T × S × R. Use multiplicative when seasonal variation scales with the trend.

How this is calculated

Worked example, using the default values

  1. Identify Input Parameters
    4 parameters
    January = 120, February = 130, March = 145, April = 160 = 13 input(s) provided
  2. Calculate Trend Slope
    2.4825 = 2.4825
  3. Calculate Seasonal Strength
    Seasonal Strength
    82.4126 = 82.4126
  4. Calculate Method
    Additive = Additive
  5. Calculate Trend Intercept
    148.03 = 148.03

Engine last updated . Checked against 2 independently-derived tests — how we verify calculators. Built by Paul Gunder, a software engineer, not a licensed financial, medical, or legal professional.

Frequently Asked Questions

Does Average Trend Value ever differ from the plain average of my twelve monthly inputs?

No — it's mathematically guaranteed to be identical. Average Trend Value is the mean of the fitted regression line's twelve points, and an ordinary least-squares line always passes through the mean of its inputs, so Average Trend Value always equals your twelve months' simple average exactly, whatever values you enter.

Why does December have the biggest measured effect on Trend Slope?

December and January are tied for the largest OLS leverage on the slope, since they sit at the two extreme ends of the twelve-month window, the same distance from its midpoint in opposite directions (line 21). December's default value (140) exceeds January's (120), and because the same percentage change is applied to both, whichever one starts from the bigger number ends up shifting Trend Slope further — that's what shows up as the biggest measured effect, not December's calendar position mattering more on its own.

Does switching between Additive and Multiplicative decomposition change how Seasonal Strength is calculated?

The final step — subtracting the minimum seasonal index from the maximum — runs identically in both modes (lines 71-73), but the seasonal indices being subtracted are computed completely differently upstream (subtraction for Additive, division for Multiplicative), so the two modes still produce very different Seasonal Strength numbers even though that last formula never actually branches.

Which month has the least influence on Trend Slope?

June, not July, despite July sitting exactly as close to the middle of the twelve-month window. June and July are tied for the smallest OLS leverage on the slope, since both sit the same short distance from the series' center in opposite directions (line 21) — but June's default value (200) is below July's (210), and with leverage tied between them, the one starting from the smaller number shifts Trend Slope less when the same percentage change is applied — which is why June, not July, ends up with the least measured influence of the twelve.

The questions that sit next to this one — chosen by subject, including calculators filed under a different category.

More in Math & Statistics.