Seasonal fluctuations. Seasonal indices. Method of simple averages

The study of periodic (seasonal) fluctuations. Calculation of average seasonal indices by the method of simple averages.

This page exists due to the efforts of the following people:

Timur

Timur

Maxim Tolstov

Created: 2015-08-04 21:45:40, Last updated: 2021-02-28 15:59:59

Note that this calculator calculates seasonal indices for monthly data. For quarterly data please use Seasonal Indices for Quarterly Data.

This is the continuation of a theme started in the article Analytical performance indicators.

Here we will talk about average seasonal indices - analytical indicators of time series characterizing the seasonal fluctuations

The seasonal fluctuations are annual, constantly repeating changes of the studied phenomena. During the analysis of the annual dynamics, you obtain the quantitative characteristics, reflecting the nature of the indicators' changes by months of the annual cycle.

Seasonal fluctuations are described by seasonal indices, which are calculated as a ratio of the indicator's actual value to some theoretical (predicted) level.

I_{ij}=\frac{Y_{ij}}{Y_t_{ij}}

Where i - the number of the seasonal cycle (years), j - the season's ordinal (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)

I_{sj}=\frac{\sum_{i=1}^n I_{ij}}{n}

Depending on the nature of the time series changes, you can calculate the formula with different methods.

I'll review the easiest method - the method of simple averages. The method can be used for the time series with no or negligible downward/upward tendencies. In other words, the observed value fluctuates around a certain constant value.

I_{sj}=\frac{Y_{sj}}{Y_{s0}},

where

Y_{sj}=\frac{\sum_{i=1}^n Y_{ij}}{n}, average for each season j (months) for all n periods

Y_{s0}=\frac{\sum_{i=1, j=1}^{i=n, j=m} Y_{ij}}{nm}, an average for all periods (n) and seasons (m)

PLANETCALC, Calculation of average seasonal indices by method of simple averages

Calculation of average seasonal indices by method of simple averages

Indicators

JanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovemberDecember
Items per page:

Digits after the decimal point: 1
Seasonal indices
The file is very large. Browser slowdown may occur during loading and creation.

URL copied to clipboard
PLANETCALC, Seasonal fluctuations. Seasonal indices. Method of simple averages

Comments