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
compute three protected t tests to compare all possible pairs of means.  Also, for α = .05, what is the value of LSD ? Which pairs are significantly different from one another,

Research Question: Percentage of students who drank a can, bottle, or glass of soda or pop (not including diet soda or diet pop) at least 1 time per day during the seven days

How to solve problems of index number fixed based method

Variation Coefficient The standard deviation discussed above is an absolute measure of dispersion. The corresponding relative measure is known as the coefficient of variation. Thi



1. This question has multiple parts. For a distribution of scores with = 82 and standard deviation = 2.5, find the following: (Don't forget to sketch the normal curve to help

Define the barter system with examples where payment is made in kind instead of cash. A barter system whereby the payment for purchases is made in kind instead of, in cash. i.e.

how to find mode graphically when the biggest rectangle is at the end

A company determines that the profit (P) in Pula and the advertising expenditure (e) in Pula have a linear relationship. a) Find an equation of linear relationship