Predictive Analytics: Microsoft Excel, 2nd Edition

4 Forecasting a Time Series: Smoothing

IN THIS CHAPTER

Exponential Smoothing: The Basic Idea

Why “Exponential” Smoothing?

Using Excel’s Exponential Smoothing Tool

Choosing the Smoothing Constant

Handling Linear Baselines with Trend

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 ...