Continuing the theme which was started in this article Analytical performance indicators.
Here we will talk about average seasonal index - analytical indicators of time series characterizing the seasonal fluctuations
The seasonal fluctuations are annual, constantly repeating change of the studied phenomena. During the analysis of the annual dynamics, you obtain the quantitative characteristics, reflecting the nature of the changes of indicators by months of the annual cycle.
Seasonal fluctuations are described by seasonal indices which are calculated as a ratio of the actual value of the indicator to some theoretical (predicted) level.
Where i - the ordinal number of the seasonal cycle (years), j - the ordinal number of the intraseasonal period (months).
The obtained values are subject to random deviations that's why these values are averaged out by years so you get the average seasonal indices for each period of the annual cycle (months)
Depending on the nature of the changes of the time series the formula can be calculated with different methods.
I'll review the easiest method - the constant mean method. The method can be used for the time series where are no downward/upward tendencies or they are negligible. In other words, the observed value fluctuates around a certain constant value.
, average for each intraseasonal period j (months) for all n seasons
, an average for all seasons (n) and interseasonal periods (m)
Calculator is below
Save the calculation to reuse next time or share with friends.