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

Assignment Help:

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.


Related Discussions:- Compute the mean absolute deviation and mean square error

Obtain the critical value for a hypothesis test, Obtain the critical value ...

Obtain the critical value (or values) for a hypothesis test for the mean if you conduct: (a) an upper tail "z" test at the 1% level of significance. (b) a two-tailed "z" test

Quantitative techniques and decision making, Let the national income model ...

Let the national income model be: Y= c+1+G C=20+0.6y I=0.2y G=20 Where y= income, C= consumption, I= investment and G=government expenditure find y, C and I from the model. By quan

Definition of management accounting, Definition of Management Accounting ...

Definition of Management Accounting According to the Chartered Institution of Control Agency (CIMA), Control Sales is "the procedure of recognition, statistic, build up, researc

Reference number 20110907, I am not able to log in again to retrieve my ass...

I am not able to log in again to retrieve my assignment that I paid for

Probability statistics, Probability 3DP, a Luxembourg-based company pla...

Probability 3DP, a Luxembourg-based company plans to develop and sell highly specialized 3D printers. The cost of product development is estimated at EUR 50,000.-, irrespective

Help, How many different license plate of 5 digits can be made if the most ...

How many different license plate of 5 digits can be made if the most let digit is 4 and the second digit from left is an odd number

Science, #question how to make an electron dot diagram

#question how to make an electron dot diagram

Governmental Accounting, The fund statements for gorvernmental funds should...

The fund statements for gorvernmental funds should include a? A. Balance sheet for governmental funds. B. Statement of revenues,expenses, and changes in fund net assets. C.Statemen

Working capital, prepare an estimate of working capital requirements from t...

prepare an estimate of working capital requirements from the following information 1. project annual sales 1,00000/- 2. selling price Rs. 8/unit 3.percentage of net profit on sale

Histogram, difference between histogram and historigram

difference between histogram and historigram

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd