Data Analysis with Microsoft Excel: Updated for Office 2007

456 Statistical Methods

Figure 11-15

The Perform

Exponential

Smoothing

dialog box

6 Click OK.

Excel displays the worksheet shown in Figure 11-16.

Figure 11-16
Smoothed
temperatures

mean annual

temperatures

forecasted

values

descriptive

statistics