O'Reilly logo

Business Analysis with Microsoft® Excel, Second Edition by Conrad Carlberg

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Moving Average Forecasts

Moving averages are easy to use, but sometimes they are too simple to provide a useful forecast. Using this approach, the forecast at any period is just the average of several observations in the time series. For example, if you choose a three-month moving average, the forecast for May would be the average of the observations for February, March, and April. If you choose to take a four-month moving average, then the forecast for May would be the average of January, February, March, and April.

This method is easy to compute, and it responds well to recent changes in the time series. Many time series respond more strongly to recent events than they do to long established patterns. Suppose, for example, that you are forecasting ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required