SARIMA Modeling

The SARIMA model is an extension of the ARIMA model, typically used in cases where we suspect a seasonal pattern in our data. The NumXL SARIMA Model Wizard automates the model construction steps: guessing initial parameters, parameters validation, the goodness of fit testing, and residuals diagnosis.

Process

To use this functionality, select an empty cell where you wish the output model table displayed and locate the corresponding icon on the toolbar (or the menu item):

The SARIMA Model Wizard is now displayed. The output range is set to the currently active cell in your worksheet. Now, reference the data sample on your worksheet and enter the different model orders.

In the "Options" section of the wizard, you may instruct the wizard to initialize the parameters' values with a quick guess or with calibrated optimal values.

Finally, in the "Output" section, you may decide whether the wizard should generate the goodness-of-fit or the residuals diagnosis tables. By default, both options are checked. Now, click "OK".

Output

Upon completion, the SARIMA Model Wizard displays the selected model's parameters and different statistical tests and/or calculations in the designated location of your worksheet.

Tutorial Video