You can use extracted data as input for spreadsheet analysis or you can copy it into other applications. For an example of how to use the Results and Methods tables, see Working with Data in Interactive Tables. These are Microsoft Excel PivotTables, described in Microsoft documentation and help.
Even though Predictor tried all the methods you selected in the Method Gallery, it generates the Results table using the best method, unless you overrode the best method, in which case, the program generates the result values using the overriding method.
The Methods table reports all the parameters and statistics for the methods you selected in the Methods panel. The method used to generate the forecasted values, either the best method or the overriding method, is highlighted in bold text. The method is likely to be different for each forecasted series.
To compare the quality of the results of different time-series forecasting methods, select the errors: RMSE, MAD, and MAPE. For all of these, the smaller the better. If you compare the RMSE of one method to the RMSE of another method, the smaller one should be ranked better. However, you cannot compare the RMSE of one method to the MAD or MAPE of another method.
To compare the quality of a regression, look for the following values:
Table 2. Evaluating Regression Quality
Statistic | Range | Ideal Value | Ideal Value Interpretation |
---|---|---|---|
R2 or Adjusted R2 | 0 to 1 | Close to 1 | The linear regression accounts for almost all the variability in the dependent data. |
F probability | 0 to 1 | Less than 0.05 | The quality of the overall regression (dependency of the dependent variable on the independent variables) is good. |
t probability | 0 to 1 | Less than 0.05 | The quality of the coefficient of the regression equation is good. |
Durbin-Watson | 0 to 4 | 2 | No autocorrelation (at lag 1) exists. |
Theil’s U | Greater than 0 | Less than 1 | The quality of the results is better than guessing. |
See the Predictor sections of Oracle Crystal Ball Reference and Examples Guide.