Calculate a forecast using exponential smoothing, Basic Statistics

Assignment Help:

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.


Related Discussions:- Calculate a forecast using exponential smoothing

Characteristics of Statistics, 1. Mention the characteristics of Statistics...

1. Mention the characteristics of Statistics. Explain any two applications of Statistics.

Find the p-value of the test hypothesis , It is known that the average heig...

It is known that the average height of a man residing in the Canada is 174 cm and the standard deviation is 8 cm. Assume the heights are normally distributed. To test the hypothesi

Assignment, An experiment succeeds twice as often as it fails. Find the cha...

An experiment succeeds twice as often as it fails. Find the chance that in the next six trials there will be at least four successes

Surveys through schedules, Under this methods the enumerators are appointed...

Under this methods the enumerators are appointed and given training. They are provided with schedules containing relevant questions. These enumerators go to respondents with the

Determine the probability - baye theorem, In a suburban community, 30% of t...

In a suburban community, 30% of the households use Brand A toothpaste, 27% use Brand B, 25% use Brand C, and 18% use Brand D. In the four groups of households, the proportions of r

Cost of accounting, what are different method of classifying overhead? indi...

what are different method of classifying overhead? indicate the advantag

What is the margin of error, The National Quality Research Center at the Un...

The National Quality Research Center at the University of Michigan provides a quarterly measure of consumer opinions about products and services (The Wall Street Journal, February

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