Data Analysis with Microsoft Excel: Updated for Office 2007

431

Chapter 11

TIME SERIES

Objectives

In this chapter you will learn to:

Plot a time series

Compare a time series to lagged values of the series

Use the autocorrelation function to determine the relationship

between past and current values

Use moving averages to smooth out variability

Use simple exponential smoothing and two-parameter exponential

smoothing

Recognize seasonality and adjust data for seasonal effects

Use three-parameter exponential smoothing to forecast future values

of a time series

Optimize the simple exponential smoothing constant

▶ ▶ ▶ ▶ ▶ ▶ ▶ ▶