Question

In: Operations Management

Of the three quantitative forecasting techniques (moving average, weighted moving average, and exponential smoothing), which do...

Of the three quantitative forecasting techniques (moving average, weighted moving average, and exponential smoothing), which do you think provides the most accurate forecast and why?

Solutions

Expert Solution

Traders can use the different kinds of moving average calculations to know and measure the momentum of markets and stock prices, to determine trends, and to make more accurate forecasts. The 3 methods viz. moving average, weighted moving average, and exponential smoothing (or exponential moving average) differ in the formulas used for creating the average and in their accuracy of finding providing the forecast.

Simple Moving Average

Simple moving averages were in use even before the computers came into being and hence are quite easy to calculate. In this method, the average closing prices of a stock, and the specified periods, are used to determine the moving averages. In most cases, the daily closing prices of a stock are used, but one can also use the other time frames. The sum of the different data points over the specified or given period is divided by the total number of periods to calculate the moving average of stock prices.

This method can eliminate the major fluctuations in price, but there is a drawback as well. Here the data points lying near the beginning of any given data set are treated in the same way (equally) as the data points obtained from the older data are.

Weighted Moving Average

The weighted moving averages method helps to overcome the deficit of the moving averages method by providing a heavier weight to the current data points, and in proportion to the newness. This is done because new data is more relevant when compared to its predecessor. Also, the sum of weights will add up to 100 percent or 1.

Exponential Smoothing/Exponential Moving Average

While the concept of weighting is present in the exponential smoothing/exponential moving averages method as well, the rate of decrease between two subsequent prices is not consistent throughout the table. The technique may be more successful in providing accurate forecasts as it can determine the trends better. Here the difference in the decrease will also be exponential, which is closer to reality and the real world stock price behavior. In exponential smoothing, the most recent price will have the highest weight, and hence will be the most accurate for forecasting. While the weighted moving average method will also have greater accuracy when compared to the simple moving average method, it will fall behind the exponential smoothing method in terms of accuracy of forecasting due to fixed weights.

Therefore, after considering all the characteristics of the different formulas and moving averages method, it can be said that exponential smoothing or the exponential moving average method is a better indicator of the trends and hence can provide for more accurate forecasts.


Related Solutions

Forecasting methods studied in this class are quantitative techniques including moving average, weighted moving average, exponential...
Forecasting methods studied in this class are quantitative techniques including moving average, weighted moving average, exponential smoothing, linear regression, and exponential smoothing with trend component. You are given a set of past demand data and asked to forecast demand for the future. What would you FIRST do to decide which demand forecasting method to use and why? Please choose one of the forecasting methods listed above.
I want to cover Quantitative Forecasting Methods linear regression the moving averages smoothing techniques How are...
I want to cover Quantitative Forecasting Methods linear regression the moving averages smoothing techniques How are these used and do they prediction the future
Please run Moving Average with 2 and 3 periods; Exponential Smoothing with a smoothing factor, or...
Please run Moving Average with 2 and 3 periods; Exponential Smoothing with a smoothing factor, or alpha, of 0.1 , 0.5 and 0.9; and Classical Decomposition for the data listed below. Which model is best? Please explain how you were able to run each model using Microsoft Excel. Year Quarter Sales Advertising 1 1 144 41 2 151 51 3 134 32 4 151 45 2 1 145 48 2 145 34 3 141 29 4 166 43 3 1...
Please run Moving Average with 2 and 3 periods; Exponential Smoothing with a smoothing factor, or...
Please run Moving Average with 2 and 3 periods; Exponential Smoothing with a smoothing factor, or alpha, of 0.1 , 0.5 and 0.9; and Classical Decomposition for the data listed below. Which model is best? Please explain how you were able to run each model using Microsoft Excel. Year Quarter Sales Advertising 1 1 144 41 2 151 51 3 134 32 4 151 45 2 1 145 48 2 145 34 3 141 29 4 166 43 3 1...
This passge below require critical analysis and breakdown Moving averages, weighted moving averages, and exponential smoothing...
This passge below require critical analysis and breakdown Moving averages, weighted moving averages, and exponential smoothing methods are forecasting methods that are used for a time series with a horizontal pattern. These methods provide a high level of accuracy for short-range forecasts, such as a forecast for the next time period and are used to smooth out random fluctuations in the time series and have a high level of accuracy for short-range forecast. The moving Average method uses the average...
This passge below require critical analysis and breakdown Moving averages, weighted moving averages, and exponential smoothing...
This passge below require critical analysis and breakdown Moving averages, weighted moving averages, and exponential smoothing methods are three forecasting methods that are appropriate for a time series with a horizontal pattern. These methods are easy to use and generally provide a high level of accuracy for short-range forecasts, such as a forecast for the next time period. “The moving averages method uses the average of the most recent k data values in the time series as the forecast for...
Identify situations in which tools such as linear regression and the moving averages and smoothing techniques...
Identify situations in which tools such as linear regression and the moving averages and smoothing techniques used for a business in predicting future revenues. Which tool is best for long-range projections? Which is the simplest for a small business? Why?  
Use 5 months moving average and exponential smoothing method (using alpha=0.3) on the following sale of...
Use 5 months moving average and exponential smoothing method (using alpha=0.3) on the following sale of Maggi. You are supposed to forecast the sale of Maggi in the 13th Month. Compare whether there is any difference in forecast based on two methods and Comment. Period (Month) Actual Sale of Maggi 1 1100 2 800 3 1000 4 1050 5 1500 6 750 7 700 8 650 9 1400 10 1200 11 900 12 1000 13
a. Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.
Month137244335450534630750829936103511411245a.  Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.b. Compare the MFE, MSE, and MAPE on the modelsc.  Make a conclusion on which model to use.d. Find the alpha (smoothing constant) that minimizes the MSE.
How does a forecast based on a weighted moving average differ from that based on exponential...
How does a forecast based on a weighted moving average differ from that based on exponential smoothing?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT