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

Variability, the purpose of measures of variability

the purpose of measures of variability

compare the quality of the different estimations, To illustrate the import...

To illustrate the importance of model selection. We will use only the first four observations to estimate the function f such that ini t. h = f(h. d) for two different models.

Psuedocode, If today is a weekday and it’s not a holiday, then you go to wo...

If today is a weekday and it’s not a holiday, then you go to work. However, if it’s a weekday and a holiday, then what you do depends on the weather: If it’s raining, you play vide

Linear regression, Linear  regression is  a regression methods  that models...

Linear  regression is  a regression methods  that models  the  relationship  between  a dependent variable   independent variables ? X1 i = 1 .........p and a random term . the mod

Hitorigrams, difference between historigrams and histogram

difference between historigrams and histogram

Financial accounting about Collison (1998:7), if "profit" maximisation is b...

if "profit" maximisation is biased towards maximising the interest of only one stakeholder group, would you expect that over time there will be less emphasis on profit and more emp

Profit and loss accounting, what does it mean by sales less of goods sold a...

what does it mean by sales less of goods sold and cost less of goods sold

Hypotheses testing, Celia is a nurse in a geriatric ward.  She noticed that...

Celia is a nurse in a geriatric ward.  She noticed that older persons in her care are having problems sleeping at night.  She decided to introduce non-pharmocologic ways of relaxat

Example on cluster sampling, "A company of accountants has branches in fiv...

"A company of accountants has branches in five regions, Port Louis (PL), Curepipe (CPE), Beau Bassin (BB), Rose Hill (RH) and Quatre Bornes (QB). It employs the following number

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