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

Homework, 9. From 11 positive integer scores on a 10-point quiz, the mean i...

9. From 11 positive integer scores on a 10-point quiz, the mean is 8, the median is 8, and the mode is 7. Find the maximum number of perfect scores possible on this test.

Calculate the mean absolute percentage error, Littlefield Laboratories is a...

Littlefield Laboratories is a state-of-the-art highly automated blood samples testing lab. The demand of blood sample testing for the previous 20 days (day 1 to day 20) are given i

Financial accounting about Collison (1998:7), if "profit" maximisation is b...

if "profit" maximisation is biased towards maximising the interest of only one stakeholder group, would you expect that over time there will be less emphasis on profit and more emp

Accounting for partnerships and limited liability companies, Tim Snyder and...

Tim Snyder and Jay Wise have decided to form a partnership. They have agreed that Snyder is to invest 30000 and Wise is to invest 40000. Snyder is to devote full time to the busi

What is Art collection , What is Art collection A personal perform of art...

What is Art collection A personal perform of art or number of products of unique graphics such as artwork, statues, craftwork or other elements generally determined as a perform

Short-term credit decision, Short-Term Credit Decision In no more than...

Short-Term Credit Decision In no more than one typed page, provide a statement of your decision to lend or not lend to this company based on your interpretation of the company

Accounting standards in europe, Accounting Standards in  Europe  countr...

Accounting Standards in  Europe  countries:   Europe has seen the maximum progress in having developed its accounting standards. In 2000, a document was published by the Europe

What does a bookkeeper do?, What does a bookkeeper do? An accountant is ...

What does a bookkeeper do? An accountant is responsible for handling the documents for a business's dealings. Ultimately the dealings will be registered in records within the bu

T, #how will understand question..moving average method problems for 4year...

#how will understand question..moving average method problems for 4yearly&5yearly also

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