Skip to content
Omnikalc

Seasonal index calculator: how strong is the seasonality in your data?

Enter three years of quarterly data to get the seasonal index of each quarter and split next year's forecast across the quarters.

Updated on
Your inputs

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Value out of range

Results

Seasonal index, quarter 1

0.734

A strongly low season
Seasonal index, quarter 2
1.092
An above-average season
Seasonal index, quarter 3
0.904
A below-average season
Seasonal index, quarter 4
1.271
A strongly high season
Forecast for quarter 1 next year
139.5
Forecast for quarter 2 next year
207.4
Forecast for quarter 3 next year
171.7
Forecast for quarter 4 next year
241.4

Many businesses see the same highs and lows every year. The seasonal index calculator takes four quarters over three years, computes the seasonal index of each quarter and then uses a forecast of next year’s total to give a forecast for each quarter. The indexes show which quarters are above and below average and by how much.

How the calculation works

  • Enter the values of four quarters for three years, in the same units, such as sales or visitors.
  • The calculator averages each quarter over the three years, then divides each average by the overall quarterly average. This gives the seasonal index.
  • An index of 1.20 means the quarter is typically 20 % above the average, and 0.80 means 20 % below. The four indexes always average 1.
  • Enter a forecast of next year’s total to split it into quarterly forecasts: total ÷ 4 × seasonal index.

Example

The quarterly averages of the default data are 130, 193.3, 160 and 225, and the overall average is 177.08. The seasonal indexes are 0.734, 1.092, 0.904 and 1.271. The fourth quarter is the peak at 27 % above average. A forecast of 760 for next year (190 per quarter on average) is split into 139.5, 207.4, 171.7 and 241.4.

Why it matters

Seasonality hides trends and makes a good or bad quarter hard to judge. An index lets you compare a quarter against what is normal for that time of year, plan stock and staff for the peak and avoid reading a seasonal dip as a decline.

Good to know

The simple average method assumes there is no strong trend and equal weights for all years. It does not remove outliers, holidays that move from year to year or one-off events. For a trending series, de-trend the data first or use a ratio-to-moving-average method.

The demand forecast calculator projects the level, the percent error calculator checks how far a forecast is from the actual value, and the exponential moving average calculator smooths a series.

Frequently asked questions

What is a seasonal index?

A seasonal index measures how a period of the year compares with the average period. An index of 1.25 means the period is typically 25 % higher than average, and 0.75 means 25 % lower. Retailers, hotels and utilities use them to plan staff, stock and budgets.

How is the seasonal index calculated here?

This calculator uses the simple average method. It averages each quarter across the years and divides by the average of all quarters. It works well when there is no strong trend. With a clear trend, a ratio-to-moving-average method is more accurate.

Can I use it for months or weeks?

Yes, the method is the same, but this calculator is limited to quarters. For months, you would have twelve seasons, and with only three years of data each month's average rests on three observations, which is noisy.

How many years of data do I need?

At least two or three years are needed to separate seasonality from random variation, and more is better. A single year cannot tell you whether a peak is seasonal or a one-off event such as a promotion or a weather event.

Was this calculator helpful?

Thanks for your feedback!

Results are estimates provided for information purposes. They do not replace professional advice.