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

Generally accepted accounting principles-gaap, Generally Accepted Accountin...

Generally Accepted Accounting Principles-GAAP:  GAAP is an Americanized term for the accounting standards and procedures that need to be followed by companies while compiling their

Co-relation, Co-relation: Co-relation in this case studies the behavior how...

Co-relation: Co-relation in this case studies the behavior how each of the investment opportunity would react to any event vis – a vis each other. The same is measured in terms of

Define Nuclear force, Nuclear force Is a short range force extending upto...

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

Calculate index number, TIME SERIES ANALYSIS: 1) Discuss the various m...

TIME SERIES ANALYSIS: 1) Discuss the various models of Time series. 2) What are the various methods of trend analysis? What are their implications in the business world?

Calculate stress in the string, question.. A prevent of huge m1 and bodywe...

question.. A prevent of huge m1 and bodyweight w1 = m1g goes on a stage frictionless exterior. It is attached by a gentle versatile string moving past over a little frictionless l

Statement, prof. ya-lu-chan definitions statistices

prof. ya-lu-chan definitions statistices

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