To paste forecasted values into a Microsoft Excel worksheet:
In the Predictor Results window, set Periods to forecast to the number of time periods to paste into the worksheet.
Select from among these settings in the Paste Forecasts to Spreadsheet dialog:
Location:
At end of historical data—Pastes forecasted data after the historical data
Starting at cell—Pastes data in the specified cell and following cells; select a range to paste multiple data series
Note:
Data is pasted below or to the right of the specified cell, depending on the Orientation selection.
Options:
Include date series—Pastes date labels next to forecasted values
Paste forecasts as Crystal Ball assumptions—Creates pasted cells as Crystal Ball assumptions defined as normal distributions with a mean that is the forecasted value and a standard deviation that is based on the RMSE of the fitted data
Note:
Predictor does not create assumptions if the variation in the data is zero or approaches infinity.
Formatting:
AutoFormat—Formats data to match the numeric formatting of the data series and highlights forecasts in bold
The results paste at the specified location. They are forecasted using the currently selected BEST method shown in the Predictor Results window.
Although Predictor tried all the methods you selected in the Method Gallery, it generates the pasted values using the best method, unless you overrode the best method, which is then used instead.
Note: | Of the eight classic time-series forecasting methods, two result in flat lines: single moving average and single exponential smoothing. The forecasted values for these are all the same. This result is not an error. It is the best possible forecast for volatile or patternless data. |
When you paste regression results, the independent variable forecast values are pasted as simple value cells. The dependent variable forecasted values are created as formula cells with the regression equation as the formula. The regression equation coefficients are displayed below the pasted values.