After running my Sales Model Using Expert Modeller in SPSS 17.0, I got the following warnig: The forecast table is not created because no forecasts could be calculated. Could you please show me how to fixed this issue. Thanks!
------------------------------------
PREDICT THRU END.
* Time Series Modeler.
TSMODEL
/MODELSUMMARY PRINT=[MODELFIT RESIDACF RESIDPACF]
/MODELSTATISTICS DISPLAY=YES MODELFIT=[ SRSQUARE RSQUARE RMSE MAPE MAE MAXAPE MAXAE NORMBIC]
/MODELDETAILS PRINT=[ PARAMETERS RESIDACF RESIDPACF FORECASTS]
/SERIESPLOT OBSERVED FORECAST
/OUTPUTFILTER DISPLAY=ALLMODELS
/AUXILIARY CILEVEL=95 MAXACFLAGS=24
/MISSING USERMISSING=EXCLUDE
/MODEL DEPENDENT=Sales
PREFIX='Model'
/EXPERTMODELER TYPE=[ARIMA EXSMOOTH] TRYSEASONAL=YES
/AUTOOUTLIER DETECT=OFF.
Model Fit
Fit Statistic | Mean | SE | Minimum | Maximum | Percentile | ||||||
5 | 10 | 25 | 50 | 75 | 90 | 95 | |||||
Stationary R-squared | .499 | . | .499 | .499 | .499 | .499 | .499 | .499 | .499 | .499 | .499 |
R-squared | .873 | . | .873 | .873 | .873 | .873 | .873 | .873 | .873 | .873 | .873 |
RMSE | 152718.618 | . | 152718.618 | 152718.618 | 152718.618 | 152718.618 | 152718.618 | 152718.618 | 152718.618 | 152718.618 | 152718.618 |
MAPE | 8.301 | . | 8.301 | 8.301 | 8.301 | 8.301 | 8.301 | 8.301 | 8.301 | 8.301 | 8.301 |
MaxAPE | 107.801 | . | 107.801 | 107.801 | 107.801 | 107.801 | 107.801 | 107.801 | 107.801 | 107.801 | 107.801 |
MAE | 94374.140 | . | 94374.140 | 94374.140 | 94374.140 | 94374.140 | 94374.140 | 94374.140 | 94374.140 | 94374.140 | 94374.140 |
MaxAE | 854134.210 | . | 854134.210 | 854134.210 | 854134.210 | 854134.210 | 854134.210 | 854134.210 | 854134.210 | 854134.210 | 854134.210 |
Normalized BIC | 23.974 | . | 23.974 | 23.974 | 23.974 | 23.974 | 23.974 | 23.974 | 23.974 | 23.974 | 23.974 |
Model Statistics | ||||||
Model | Number of Predictors | Model Fit statistics | Ljung-Box Q(18) | Number of Outliers | ||
Stationary R-squared | Statistics | DF | Sig. | |||
Sales-Model_1 | 0 | .499 | 28.909 | 16 | .025 | 0 |