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

Quantitative research, The research should be Quantitative Research: A m...

The research should be Quantitative Research: A means for testing objective theories by examining the relationship among variables. These variables can be measured and analyzed

Inventory, An audit of the accounting records of Loch Ness Ltd. for the ye...

An audit of the accounting records of Loch Ness Ltd. for the year ending 30 June 2012 discovered that the ending inventory balance was over-valued by $35,000

Obtain the p-value for the value of the test statistic, A study looked at t...

A study looked at the relationship between coronary heart disease (CHD) and coffee consumption in a group of 40-55 year old men. Among the 790 heavy coffee drinkers (at least 100 c

Describe the assumptions conducting test, Conduct a test to determine if th...

Conduct a test to determine if the proportion of males that responded true to the statement in the survey that, "Whole foods (i.e. raw vegetables and meats) contain sodium," is dif

Estimate the proportion of lake trout with lamprey scars, In a certain lake...

In a certain lake a limnologist wishes to estimate the proportion of lake trout with lamprey scars. (a) How large of a random sample should be taken if the limnologist has no pr

Tools., what do you mean by correct and remedy the equipment trouble as ins...

what do you mean by correct and remedy the equipment trouble as instructed by the expert.

Basic statistics, Since you have answered the same below question on 2012, ...

Since you have answered the same below question on 2012, can you provide it to me as free of charge this time? if yes, please send it to me on: Question" Case 1: Decision Analysis

Study guide, Can you provide me a study guide for accounting please? Can yo...

Can you provide me a study guide for accounting please? Can you give me picture examples & instructions on how to do things that are really easy to understand? I need this for doin

Cat, charlie removes the 12 face cards from a standard deck of cards then s...

charlie removes the 12 face cards from a standard deck of cards then shuffles the face cards together on their own. He selects 2 cards from the pile. The probability that the first

Time series, what is meant by time series?

what is meant by time series?

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