Seasonality

Seasonality

Seasonality is a time series feature in which data shows regular and predictable patterns that recur every year. For example, retail sales tend to peak for the Christmas season and then decline after the holidays.

A seasonal lag is the value of a time series one period before the current period, incorporated as an additional term in an autoregressive model. For example, if quarterly data are used, the seasonal lag is 4; if monthly data are used, the seasonal lag is 12; and so on. Seasonality is detected by autocorrelation of error terms when it differs significantly from 0. Using seasonal lags eliminates autocorrelation in the error terms.

Consider quarterly sales data. The 4th autocorrelation will not be statistically different from zero if there is quarterly seasonality.

Seasonality can be corrected by incorporating an additional lagged term. For quarterly data, we add a prior year quarterly seasonal lag as follows:

$$\text{x}_{\text{t}}=\text{b}_{0}+\text{b}_{1}\text{x}_{\text{t}-1}+\text{b}_{2}\text{x}_{\text{t}-4}+\epsilon_{\text{t}}$$

In the above expression, the seasonal lag is \(\text{b}_{2}\text{x}_{\text{t}-4}\). We then run a regression analysis on the time series data to test whether the seasonal lag will eliminate statistically significant autocorrelation of error terms.

Example: Testing and Correcting Seasonality

Consider an AR(1) model used to forecast quarterly retail sales of a certain company based on 100 observations.

$$\text{x}_{\text{t}}=\text{b}_{0}+\text{b}_{1}+\epsilon_{\text{t}}$$

The residual autocorrelations relating to a certain year are as presented in the following table:

$$\small{\begin{array}{c|c} \textbf{Lag} & \textbf{Autocorrelation}\\ \hline1 & -0.0584 \\ \hline2 & -0.0492 \\ \hline3 & 0.0625 \\ \hline4 & 0.6580 \\  \end{array}}$$

Test for seasonality in the time series and suggest how to correct it.

Solution

The first step is to calculate the t-statistic for each autocorrelation using the formula:

$$\text{t}_{\text{Statistic}}=\frac{\text{Residual autocorrelation}}{\frac{1}{\sqrt{\text{T}}}}$$

The t-statistic for lag one is calculated as:

$$\text{t}_{\text{Statistic}}=\frac{-0.0584}{\sqrt{100}}=-0.584$$

$$\small{\begin{array}{c|c|c} \textbf{Lag} & \textbf{Autocorrelation} & \textbf{t-statistic} \\\hline1 & -0.0584 & -0.584 \\\hline2 & -0.0492 & -0.492 \\\hline3 & 0.0625 & 0.625 \\\hline4 & 0.658 & 6.580\\  \end{array}}$$

There are 100 observations and two parameters, \(\text{b}_{0}\) and \(\text{b}_{1}\) to be estimated. Thus 98 (100-2) degrees of freedom. The critical t-value at the 5% significance level with 98 degrees of freedom is 1.98. The table above shows that the 4th lag autocorrelation and the t-statistic are the highest.

The t-statistics of the first three lagged autocorrelations are less than the critical value at the 5% significance level. We can therefore conclude that none of the first three lagged autocorrelations is significantly different from zero.

However, notice that the t-statistic for the 4th lag autocorrelation is greater than the critical value. We thus reject the null hypothesis that the 4th lag autocorrelation is zero. The conclusion is that there is seasonality in the time series. This implies that the model is misspecified and not appropriate for use.

Correcting Seasonality

Seasonality can be corrected by incorporating an additional lag of the dependent variable that corresponds to the same period in the previous year to the original AR(1) model as another independent variable to make the model more correctly specified.

In the previous example, we have seen that there is seasonality in the quarterly time series. This implies that retail sales in each quarter are related to both the previous quarter and the corresponding quarter in the previous year.

We can incorporate a seasonality lag to the original AR(1) model as follows:

$$\text{x}_{\text{t}}=\text{b}_{0}+\text{b}_{1}\text{x}_{\text{t}-1}+\text{b}_{2}\text{x}_{\text{t}-4}+\epsilon_{\text{t}}$$

We have added the seasonal lag \(\text{b}_{2}\text{x}_{\text{t}-4}\) to eliminate the regular quarterly pattern and seasonal non-stationarity if they exist.

Forecasting with Seasonal Lags

Assume that the regression coefficients after incorporating the seasonal lag are estimated as:

\(\text{b}_{0}=0.0080, \text{b}_{1}=-0.0650\) and \(\text{b}_2=0.8068\).

The estimated equation is:

$$\text{x}_{\text{t}}=0.0080-0.0650\text{x}_{\text{t}-1}+0.8068\text{x}_{\text{t}-4}+\epsilon_{\text{t}}$$

Where \(\text{x}_{\text{t}}\) is the retail sales for the ith quarter.

Given the following quarterly retail sales:

$$\small{\begin{array}{c|c|c|c|c} \textbf{Quarter} & 2020.1 & 2020.2 & 2020.3 & 2020.4 \\\hline\textbf{Retail sales (USD Millions)} & 100 & 300 & 150 & 200\\  \end{array}}$$

We can forecast the retail sales for the first quarter of 2021 as follows:

$$\begin{align*}\text{y}_{2021.1}&=0.0080-0.0650(\text{y}_{2020.4})+0.8068(\text{y}_{2020.1})\\&=0.0080-0.0650(200)+0.8068(100)\\&=67.69\end{align*}$$

The forecasted value of the retail sales for the first quarter of 2021 is 67.69 million.

Question

Consider the following monthly AR model with an additional lag incorporated to eliminate seasonality.

$$\text{x}_{\text{t}}=\text{b}_{0}+\text{b}_{1}\text{x}_{\text{t}-1}+\beta_{2}\text{x}_{\text{t}-12}+\epsilon_{\text{t}}$$

Given the following information:

$$\small{\begin{array}{l|c} {}& \text{Coefficients} \\ \hline\text{Intercept} & 0.0005 \\ \hline\text{lag 1} & –0.12 \\ \hline\text{lag 12} & 0.87\\  \end{array}}$$

$$\small{\begin{array}{c|c|c} 2019 & \text{Jan} & 2.8 \\\hline2019 & \text{Feb} & 3.0 \\\hline2019 & \text{Mar} & 3.5 \\\hline2019 & \text{Apr} & 4.0 \\\hline2019 & \text{May} & 4.6 \\\hline2019 & \text{Jun} & 5.0 \\\hline2019 & \text{Jul} & 5.4 \\\hline2019 & \text{Aug} & 6.0 \\\hline2019 & \text{Sep} & 7.0 \\\hline2019 & \text{Oct} & 5.4 \\\hline2019 & \text{Nov} & 6.0 \\\hline2019 & \text{Dec} & 7.0\\  \end{array}}$$

The forecasted value for January 2020 is closest to:

  1. 1.6.
  2. 3.3.
  3. 5.8.

Solution

The correct answer is A.

$$\text{x}_{\text{t}}=\text{b}_{0}+\text{b}_{1}\text{x}_{\text{t}-1}+\text{b}_{2}\text{x}_{\text{t}-12}+\epsilon_{\text{t}}$$

$$\begin{align*}\text{x}_{2020.1}&=0.0005-0.12(\text{x}_{2019.12})+0.87(\text{x}_{2019.1})\\&=0.0005-0.12\times7+0.87\times2.8\\&=1.6\end{align*}$$

Reading 5: Time Series Analysis

LOS 5 (l) Explain how to test and correct for seasonality in a time-series model and calculate and interpret a forecasted value using an AR model with a seasonal lag.

Shop CFA® Exam Prep

Offered by AnalystPrep

Featured Shop FRM® Exam Prep Learn with Us

    Subscribe to our newsletter and keep up with the latest and greatest tips for success
    Shop Actuarial Exams Prep Shop Graduate Admission Exam Prep


    Daniel Glyn
    Daniel Glyn
    2021-03-24
    I have finished my FRM1 thanks to AnalystPrep. And now using AnalystPrep for my FRM2 preparation. Professor Forjan is brilliant. He gives such good explanations and analogies. And more than anything makes learning fun. A big thank you to Analystprep and Professor Forjan. 5 stars all the way!
    michael walshe
    michael walshe
    2021-03-18
    Professor James' videos are excellent for understanding the underlying theories behind financial engineering / financial analysis. The AnalystPrep videos were better than any of the others that I searched through on YouTube for providing a clear explanation of some concepts, such as Portfolio theory, CAPM, and Arbitrage Pricing theory. Watching these cleared up many of the unclarities I had in my head. Highly recommended.
    Nyka Smith
    Nyka Smith
    2021-02-18
    Every concept is very well explained by Nilay Arun. kudos to you man!
    Badr Moubile
    Badr Moubile
    2021-02-13
    Very helpfull!
    Agustin Olcese
    Agustin Olcese
    2021-01-27
    Excellent explantions, very clear!
    Jaak Jay
    Jaak Jay
    2021-01-14
    Awesome content, kudos to Prof.James Frojan
    sindhushree reddy
    sindhushree reddy
    2021-01-07
    Crisp and short ppt of Frm chapters and great explanation with examples.