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
Examine the distributions of weight and height. Are there any outliers? If so deal with them appropriately. Create a new variable that divides weight into groups. Produce a tabl

The owner of Big Fish supermarket was reviewing some data from a research report on the type of advertisements in the local paper that are most effective.  Three types of ads (big

1) Working in your groups analyse the organisation of information that the Facebook social networking site potentially uses. 2) Suggest the organisation of information and data


I am in need of your help again. First and foremost, I thought I had created an account, but none could be found. In any event here is my assignment. Should you decide that you

A study done at the University of Maryland (cited in Weiss, Introductory Statistics, 7th ed, 2005) measured the body temperatures of 93 healthy humans. On the frequency- histogram

Oprah Winfrey endorsed Barack Obama in the Democratic presidential primary. Does Oprah's endorsement make a difference? If so, we would expect support for Obama to be higher among

what are the objective and importance of cost accounting and managerial decision making.

how to draw the mind map

I have a midterm coming up the teacher is allowing us to have a front & back cheats on anything we want on it. Is there a way you guys can make me one?