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 2016, 2nd Edition now with O’Reilly online learning.

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