4 Forecasting a Time Series: Smoothing

Chapter 3, “Forecasting with Moving Averages,” shows you how the number of values that are included in a moving average controls the relative amount of smoothing and tracking that occurs. The more values in the moving average, the greater the amount of smoothing, and therefore the longer it takes the moving average to react to a change in the level of the series.

On the other hand, the fewer values in the moving average, the greater amount of tracking, and therefore the more quickly the moving average reacts to ...

Get Predictive Analytics: Microsoft Excel, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.