Chapter 11 Times Series 4757 Click the Forecast checkbox and enter 12 in the Units ahead box.
This will forecast the next year liquor sales.
8 Verify that 0.95 is entered in the Confi dence Interval box. This will
produce a 95% confi dence region around your forecasted values.
9 Click the Output button and direct your output to a new sheet named
Forecasted Sales. Click OK.
Your dialog box should look like Figure 11-30.Figure 11-30
The Perform
Exponential
Smoothing
dialog box
10 Click OK.
Output from the command appears on the Forecasted Sales work-
sheet. To view the forecasted values, drag the vertical scroll bar
down. See Figure 11-31.