Seasonal Adjustment Calculator Formula
Understand the math behind the seasonal adjustment calculator. Each variable explained with a worked example.
Formulas Used
Seasonally Adjusted Value
adjusted = observed / seasonal_indexSeasonal Effect
seasonal_effect = observed - (observed / seasonal_index)Seasonal Effect (%)
pct_seasonal = (seasonal_index - 1) * 100Variables
| Variable | Description | Default |
|---|---|---|
observed | Observed Value | 150 |
seasonal_index | Seasonal Index | 1.25 |
How It Works
How to Seasonally Adjust Data
Formula
Adjusted Value = Observed Value / Seasonal Index
Seasonal adjustment removes predictable seasonal patterns from data, revealing the underlying trend. A seasonal index above 1 means the season inflates the value; below 1 means it deflates it. Dividing by the index normalizes the value as if there were no seasonal effect.
Worked Example
December sales are $150 with a seasonal index of 1.25 (holiday boost).
observed = 150seasonal_index = 1.25
- 01Adjusted = 150 / 1.25 = 120
- 02Seasonal effect = 150 - 120 = 30
- 03The seasonal boost accounts for $30 (25%) of the observed value
- 04The underlying (de-seasonalized) value is $120
Ready to run the numbers?
Open Seasonal Adjustment Calculator