Data Analysis with Microsoft Excel: Updated for Office 2007

Excel Reference 577

Seasonal Adjustment

The StatPlus>Time Series>Seasonal Adjustment command creates a col-

umn of seasonally adjusted time series values that show periodicity, and

creates a plot of unadjusted and adjusted values. A plot of the seasonal

indexes is included in the output (multiplicative seasonality is assumed).

The seasonal adjustment output is not dynamic and will not update if the

source data in the input range change.

StatPlus Options

The StatPlus>StatPlus Options command allows the user to specify the de-

fault input and output options for the different StatPlus modules. One can

also specify how StatPlus should handle hidden data.