Moving Average and Smoothing Techniques

Inherent in the collection of data taken over time is some form of random variation. There exist methods for reducing of canceling the effect due to random variation. An often-used technique in industry is “smoothing”. This technique, when properly applied, reveals more clearly the underlying trend, seasonal and cyclic components.

There are two distinct groups of smoothing methods

  • Averaging Methods
  • Exponential Smoothing Methods

We will first investigate some averaging methods, such as the “simple” average of all past data.

A manager of a warehouse wants to know how much a typical supplier delivers in 1000 dollar units. He/she takes a sample of 12 suppliers, at random, obtaining the following results:

The computed mean or average of the data = 10. The manager decides to use this as the estimate for expenditure of a typical supplier.
Is this a good or bad estimate?

We shall compute the “mean squared error”:

  • The “error” = true amount spent minus the estimated amount.
  • The “error squared” is the error above, squared.
  • The “SSE” is the sum of the squared errors.
  • The “MSE” is the mean of the squared errors.

The results are:

The SSE = 36 and the MSE = 36/12 = 3.

So how good was the estimator for the amount spent for each supplier? Let us compare the estimate (10) with the following estimates: 7, 9, and 12. That is, we estimate that each supplier will spend $7, or $9 or $12.

Performing the same calculations we arrive at:

The estimator with the smallest MSE is the best. It can be shown mathematically that the estimator that minimizes the MSE for a set of random data is the mean.

Next we will examine the mean to see how well it predicts net income over time. The next table gives the income before taxes of a PC manufacturer between 1985 and 1994.

The MSE = 1.8129.

The question arises: can we use the mean to forecast income if we suspect a trend? A look at the graph below shows clearly that we should not do this.

In summary, we state that

  • The “simple” average or mean of all past observations is only a useful estimate for forecasting when there are no trends. If there are trends, use different estimates that take the trend into account.
  • The average “weighs” all past observations equally. For example, the average of the values 3, 4, 5 is 4. We know, of course, that an average is computed by adding all the values and dividing the sum by the number of values. Another way of computing the average is by adding each value divided by the number of values, or

3/3 + 4/3 + 5/3 = 1 + 1.3333 + 1.6667 = 4.

The multiplier 1/3 is called the weight. In general: