The seasonal time series are regular variations thereof, which is lower year cycle . Semesters may be submitted, quarters, months, weeks or days. In the classic analysis of time series, the seasonal component , along with the trend, the medium-term cycles and irregular component are the elements in the series can be decomposed,
This might be expressed through indices, coefficients or percentages of seasonal variation, which provide relevant information to solve many problems of practical interest, eg
- situation analysis of activities subject to seasonality.
- Together with other components to make predictions about future values \u200b\u200bof the series.
- seasonally adjusted series for comparisons between two successive periods and better analyze the other components, free from seasonal influences.
- forecast for the proper management of other variables correlated with the series analyzed. For example, if sales of a product have a strong seasonal variation, it must take account of other departments such as the purchasing or production.
There are several methods to find seasonality. In this case it is used by Excel, the average percentage method, which consists of:
- Get the monthly average number for each year.
- Calculate the percentage for each month for the average indicated.
- Get the seasonal index as the average in each month of the percentages indicated.
0 comments:
Post a Comment