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 ...
Get Business Analysis with Microsoft® Excel, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.