Calculate a forecast using exponential smoothing, Basic Statistics

The Midwestern Manufacturing Company (MMC) is a large manufacturer of electrical generators.  The firm has experienced demand for their generators as shown below:

Year  Demand

2003      74

2004      79

2005      80

2006     90

2007    105

2008    142

2009    122

For the questions below, create EXCEL worksheets naming the tabs as indicated.

a. Calculate a forecast for 2010 using a 3 year moving average. Place your results in a worksheet tab named Q1.

b. Calculate a forecast for 2010 using exponential smoothing. Use .7 as your Alpha value. Place your results in worksheet tab Q1.

c. Using Mean Absolute Deviation as your criteria, determine which method performs best. Explain your decision. Place your results in worksheet tab Q1.

Posted Date: 2/28/2013 1:20:56 AM | Location : United States







Related Discussions:- Calculate a forecast using exponential smoothing, Assignment Help, Ask Question on Calculate a forecast using exponential smoothing, Get Answer, Expert's Help, Calculate a forecast using exponential smoothing Discussions

Write discussion on Calculate a forecast using exponential smoothing
Your posts are moderated
Related Questions
Nuclear force Is a short range force extending upto 10 fm. It is fifty-sixty times stronger than electromagnetic force. Nuclear force is independent of charge. Nuclear force betw

Uses of mean

Where an element of randomness is introduce by suing random numbers to pick up the unit with which to start this process of sampling is known as systematic sampling.


i have a scaled data on multiple questions from two different tests taken at different times for the same respondents, and now i want to calculate the reliability test manually but

LO.1 (Activity analysis) The Raleigh plant manager of Allentown Corp. has noticed the plant frequently changes the schedule on its production line. He has gathered the following in

If q=2,TP=450 and AP=225, what is MP. How can I figure out what my marginal product will be?

The descriptive statistics outputs for both the variables are as below: Wii Group Mean 95.8 Standard

Classification feature of Accounting Transaction. Under the classification accountant posts the entries into their respective ledgers in the Accounts Books. Every Account entry

what is the electric field at point x if q=7*10^-6 C d=6m