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

Sampling distribution, The heights of a large population of adult females w...

The heights of a large population of adult females who play basketball are normally distributed with a mean of 175cm and a standard deviation of 7.5cm. (a) what proportion of this

Measures of dispersion, if a series of three observations has a mean andd m...

if a series of three observations has a mean andd median of 4 and mean absolute deviation of 4/3. what is the series

Increasing the magnetic field inside a coil, Someone tries to increase the ...

Someone tries to increase the magnetic field inside a coil by adding more turns to the coil. Where should he add more turns: to the end of the coil (i.e., to make it longer) or to

Derive the pure strategy nash equilibrium, There are two firms competing in...

There are two firms competing in quantity. Firm 1 and 2 set their quantities supplied, q1 and q2, respectively. The production costs are zero. The market price is given by

Simulate a worm propagation considering no delay, You are required to simul...

You are required to simulate simple worm propagation in a medium-scale network by using discrete-time simulation technique. Assume that in an isolated network with IP address

Iasb and fasb, Significant factors of financial accounting In financial...

Significant factors of financial accounting In financial accounting, The IASB and FASB considered that reconsidering all the ideas would not be a practical use of their underst

Why is interest expense a no operating expense, Why is interest expense a n...

Why is interest expense a no operating expense? Attention cost is a no operating cost when it is not part of a business's primary functions. For example, a store's primary func

Quartile deviation, find quartile deviation from the student test marks of ...

find quartile deviation from the student test marks of your own

Assingment, who we complete accounting cycile

who we complete accounting cycile

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