Seasonal adjustment is a statistical method for removing the seasonal component of a time series when analyzing non-seasonal trends. It is normal to report seasonally adjusted data for unemployment rates to reveal the underlying trends in labor markets.

Many economic phenomena have seasonal cycles, such as agricultural production and consumer consumption (e.g., greater consumption leading up to Christmas). It is necessary to adjust for this component to understand what underlying trends are in the economy; thus, official statistics are often adjusted to remove seasonal components.

NumXL supports the X-13ARIMA-SEATS method. X-13ARIMA-SEATS is the software produced, distributed, and maintained by the United States Census Bureau.

Using the X-13ARIMA-SEATS functionality in NumXL, you can reference the input data in the spreadsheet, specify the different X-13ARIMA-SEATS options (e.g., prior adjustment, outlier treatment, etc.) through an intuitive wizard, and display the seasonal-adjusted time series or forecast in Excel.

Behind the scenes, NumXL translates the user’s options into native X-13ARIMA-SEATS scripts, runs the program, and avails the outputs (e.g., seasonally adjusted trend, seasonal factor, irregulars, forecast) through a set of worksheet functions. Nevertheless, the user can view/access the generated input and output files using the NumXL wizard.

regARIMA Model

The X-12-ARIMA software has extensive time series modeling and model selection capabilities for linear regression models with ARIMA errors (regARIMA models).

The ARIMA models, as discussed by Box and Jenkins (1976), are frequently used for seasonal time series. A general multiplicative seasonal ARIMA model for a time series $z_t$ can be written:

$$\phi(L)\Phi(L^s)(1-L)^d (1-L^s)^D\times z_t = \theta(L)\Theta(L^s)a_t$$


  • $L$ is the Lag or the Backshift operator.
  • $s$ is the seasonal period.
  • $(\phi(L)=\phi_o+\phi_1 L+\phi_2 L^2 +\cdots +\phi_p L^p)$ is the nonseasonal autoregressive (AR) model component.
  • $(\Phi(L)=\Phi_o+\Phi_1 L+\Phi_2 L^2 +\cdots +\Phi_P L^P)$ is the seasonal autoregressive (AR) model component.
  • $(\theta(L)=\theta_o+\theta_1 L+\theta_2 L^2 +\cdots +\theta_q L^q)$ is the nonseasonal moving average (MA) model component.
  • $(\Theta(L)=\Theta_o+\Theta_1 L+\Theta_2 L^2 +\cdots +\Theta_Q L^Q)$ is the seasonal moving average (MA) model component.
  • $(1-L)^d$ is the non-seasonal differencing operator of order d.
  • $(1-L^s)^D$ is the seasonal differencing operator of order D and seasonal period(s).
  • $\{a_t\}\sim \textrm{i.i.d}\sim N(0,\sigma^2)$.


  1. It is common to replace $z_t$ by deviations from the mean: $$z_t-\mu$$ Where $\mu=E[z_t]$.
  2. $(1-L)^d(1-L^s)^D$ operator yields a stationary time series.
  3. A natural extension for the ARIMA model results from using a time-varying mean function modeled via linear regression effects.

    $$y_t=\sum_{i=1}^N{\beta_i x_{i,t}}+z_t$$


    • $y_t$ is the (dependent) time series.
    • $x_{i,t}$ are regression variables observed concurrently with $y_t$.
    • $\beta_i$ are the regression parameters.
  4. The time series of regression errors is assumed to follow the earlier ARIMA model: $$z_t= y_t-\sum_{i=1}^N{\beta_i x_{i,t}}$$
  5. As a result, the general regARIMA model supported by the X-12-ARIMA program is:

    $$\phi(L)\Phi(L^s)(1-L)^d (1-L^s)^D\times (y_t-\sum_{i=1}^N{\beta_i x_{i,t}}) = \theta(L)\Theta(L^s)a_t$$

Related Links



Please sign in to leave a comment.

Was this article helpful?
0 out of 0 found this helpful