Model Forecasting


To perform a forecast using NumXL, select the cell of the model's table (e.g. AirLine).

Selecting the cell that defines the model, such as AIRLINE as the forecasting input data.

Click on the "Forecast" icon in the toolbar.

Forecast icon in the NumXL toolbar.

The forecast wizard will pop up. Select the realized observations (i.e. tail points of your sample data), and the forecast horizon in units of steps.

Forecasting dialog box.


In the illustration above, the last 23 observations in the sample data were chosen, then the forecast horizon was set to 30 steps (or units).

Forecasting output table.

Plot the forecast and its' confidence intervals.

Forecasting output graph.

Tutorial Video


Article is closed for comments.

Was this article helpful?
1 out of 2 found this helpful