Compute the mean absolute deviation and mean square error, Basic Statistics

Toyota Motors introduced a hybrid car Hybrid G in the U.S. market in 2006. In the first three years, the sales of Hybrid G were strong due to the buzz surrounding the hybrid car concept and also lack of competition. Sales of Toyota's Hybrid G started declining in 2009 following the introduction of a new hybrid model by Honda. Toyota is in critical need of a better forecasting method. They need your help to evaluate alternative forecasting methods and provide suggestions. The following table contains the past 12 months' sales data (Note: Month 1 refers to sales made 12 months ago, month 12 refers to sales made last month.)

a. Use a 3-month simple moving average to forecast sales for months 4 to 13. Compute the Mean Absolute Deviation (MAD) and the Mean Square Error (MSE) of the forecasts for months 4 to 12.

b. Using a 3-month weighted average method with weights of 0.5, 0.3 and 0.2 (most recent, next most recent, and third most recent month, respectively) for months 4 to 13. Again, compute the MAD and MSE of the forecasts for months 4 to 12 with the weighted moving average method.

c. Using exponential smoothing method, compute two sets of forecasts for the sales of Hybrid G for months 2 to 13, corresponding to α values of 0.2 and 0.5. Assume that the forecast for month 1 is 1376.

d. Continue part c. Compute the MAD and Mean Absolute Percentage Error (MAPE) using the forecast errors from months 2-12 for each of these two sets of forecasts. Which α value produces a more accurate forecast?

e. Use the trend-adjusted exponential smoothing method to forecast sales for months 2 to 13, assuming S1=1376 and T1=-25 and set α=0.8 and β=0.2.

f. Develop a simple linear regression model using month as the independent variable to forecast the sales of Hybrid G for month 13.

Posted Date: 3/6/2013 4:38:53 AM | Location : United States







Related Discussions:- Compute the mean absolute deviation and mean square error, Assignment Help, Ask Question on Compute the mean absolute deviation and mean square error, Get Answer, Expert's Help, Compute the mean absolute deviation and mean square error Discussions

Write discussion on Compute the mean absolute deviation and mean square error
Your posts are moderated
Related Questions
A methodical selection of the adequate, qualified evidential issue needed to verify the equity of management''s claims in the fiscal reports or to assess whether management has wis

A group of identical synchronous motors is connected through a transformer to a 4.16-kV bus at a remote location from the generating plants of a power system. The motors are rated

Data was gathered on a group of ninth grade students. Some students have been diagnosed with a learning disability.  All students were measured on conduct, attention, hyperactivity

Prior to the last payroll period of the calendar year, the cumulative earnings of Employer A were $105000. The earnings for the last payroll period of the year which will be paid o

any of your writer able to use the database given to generate the null, alternative..etc.. into a power point presentation

The game of "Bunco" is played with three standard dice. "Bunco" occurs when all three dice show the same number of spots. What is the probability of tossing a "Bunco" on the first


Check numbers for No Neighboring States with Video Gaming, 2% inflation, 4 Average Bets Numbers for 2018 Average Return -0.082 Net Income -$2,052,859 End of Year Cash $5,0

Lifts usually have signs indicating their maximum capacity. Consider a sign in a lift that reads “maximum capacity 1400kg or 20 persons”. Suppose that the weights of lift-users are

The following data shows marks obtained by 40 students in a Statistics test. 75 99 72 54 25 40 65 32 69 10 85 48 52 80  63 64 35 62 51 71 67 57 95 74 56 69 61  49 45 63 39