Data Analysis with Microsoft Excel: Updated for Office 2007

(Tuis.) #1
576

Exponential Smoothing


The StatPlus>Time Series>Exponential Smoothing command calculates one-,
two-, or three-parameter exponential smoothing models for a single column
of time series data. You can forecast future values of the time series on the
basis of the smoothing model for a specifi ed number of units and include a
confi dence interval of size specifi ed by the user. The output includes a ta-
ble of observed and forecasted values, future forecasted values, and a table
of descriptive statistics including the mean square error and fi nal values of
the smoothing factors. A plot of the seasonal indexes (for three-parameter ex-
ponential smoothing) is included. The exponential smoothing output is not
dynamic and will not update if the source data in the input range change.

Runs Test


The StatPlus>Time Series>Runs Test command performs a Runs test on
time series data. The test displays the number of runs, the expected num-
ber of runs, and the statistical signifi cance. The cut point can either be the
sample mean or be specifi ed by the user.
Free download pdf