homechevron_rightProfessionalchevron_rightStatistics

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.

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

Continuing the theme which was 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 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.

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

Where i - the number of the seasonal cycle (years), j - the ordinal of the season (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 changes of the time series the formula can be calculated with different methods.

I'll review the easiest method - the method of simple averages. 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.

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

arrow_upwardarrow_downwardJanuaryarrow_upwardarrow_downwardFebruaryarrow_upwardarrow_downwardMarcharrow_upwardarrow_downwardAprilarrow_upwardarrow_downwardMayarrow_upwardarrow_downwardJunearrow_upwardarrow_downwardJulyarrow_upwardarrow_downwardAugustarrow_upwardarrow_downwardSeptemberarrow_upwardarrow_downwardOctoberarrow_upwardarrow_downwardNovemberarrow_upwardarrow_downwardDecember
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
Creative Commons Attribution/Share-Alike License 3.0 (Unported) PLANETCALC, Seasonal fluctuations. Seasonal indices. Method of simple averages

Comments