You can extract results and methods data from the current Predictor forecasting run.
To extract Predictor results:
Run a Predictor forecast and display the Predictor Results window.
If it is not visible, click Predictor Results in the Windows task bar. (It may be located in the Microsoft Office Excel group.)
Confirm that the following settings are complete and correct:
Periods to forecast—Determines the number of forecasted values that are displayed
Confidence interval—Indicates which confidence interval to calculate and plot
Series—Selects the data series to display
Method—Selects the forecasting method used to calculate forecasted values
See Viewing Charts.
In the Predictor Results menu bar, select Analyze, and then Extract Data.
In the Extract Data Preferences dialog, select the Predictor Data tab, if it is not already visible, and select Results Table, Methods Table, or both:
Results Table shows fit and residual values for historical data, forecast and confidence interval values for the forecasted values (where residuals are the difference between the fit value and the historical data value), and events data (if selected).
Note:
If Include events is selected in the Data Attributes panel of the Predictor wizard, and at least one event is defined, an additional Event column in the table of extracted data shows the event numbers defined for each series. Rows with events are also color coded. If the data has seasonality, seasonal differences are indicated with lighter colored rows. Screened data rows can also be highlighted. To change highlighting of these special types of data, select the Results Window and then select Preferences and any of the Highlight commands.
Methods Table shows error measures, parameters, ranking, and statistics for each selected fit method.
In the Results Table Details group, select the data types to include.
Leave the defaults selected to extract all available data.
Click Options and confirm that the wanted location and formatting settings are selected.
For details, select Help.
Depending on the Options settings, two tabs are displayed in the existing workbook or a new workbook. The tabs are Results Table and Methods Table. Each tab contains an interactive Microsoft Excel PivotTable with the selected data. See “Analyzing and Using Extracted Results” on page 39.