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

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

Study guide, Answers & examples of accounting for the follow on the file be...

Answers & examples of accounting for the follow on the file being sent to you.

Cost of preference sharea, A company wishes to issue new preference shares;...

A company wishes to issue new preference shares; the company will incur flotation cost of 2% per share. the market value of this shares is $90 per share & a nominal value of $100 p

How this works, So I can send you a word problem & you van send the answers...

So I can send you a word problem & you van send the answers back in excel for me?

Accounting equation, A.Austria invested cash $1,000 and a type writer $2,50...

A.Austria invested cash $1,000 and a type writer $2,500

Calculate its stationary probabilities, A small specialized workshop is use...

A small specialized workshop is used to perform periodic check-up on some high-tech devices. The check up is made in three stages whose durations are independent random variables w

Data for ogive graph, Data for ogive graph in sectors of indian economy

Data for ogive graph in sectors of indian economy

Employer''s fica tax rate for 2012, Employer's FICA tax rate for 2012 Th...

Employer's FICA tax rate for 2012 The employer's FICA tax amount for 2012 involves 1) the Public Protection tax amount of 6.2% of each individual's first $110,100 of income, inc

Homophone disambiguation-unigram-bigram model , The BBC hosts a homophone q...

The BBC hosts a homophone quiz on its website; your task for this lab is to develop an automatic method for completing the quiz, with the aim being to get as high a score as possib

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