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

Statistic, any of your writer able to use the database given to generate th...

any of your writer able to use the database given to generate the null, alternative..etc.. into a power point presentation

Find the distribution function, The probability density function (pdf) of X...

The probability density function (pdf) of X is given by f(x) =   (1-x/2  if          0 ≤ x           (0                    otherwise a. Verify that that f(x) is a legitim

Statistical quality control, If in a hall there are 18 persons then how man...

If in a hall there are 18 persons then how many handshakes are possible?

DATA EDITING, THE SIGNIFICANCE OF DATA EDITING

THE SIGNIFICANCE OF DATA EDITING

What is a purchase allowance, What is a purchase allowance? A buy permi...

What is a purchase allowance? A buy permitting is a reduction in the customer's cost of products that it had purchased. The buy permitting is granted by the provider because of

Probabilities, What is the probability of selecting exactly one red and one...

What is the probability of selecting exactly one red and one blue fish (Total red is .479 and total blue is .521 and total of both is 1.000) I cannot figure out the formula or how

Joint probability, Two construction contracts are to be randomly assigned t...

Two construction contracts are to be randomly assigned to one or more of three firms. Numbering the firms I, II, and III, let X1 be the number of contracts assigned to firm I, and

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

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

Minitab run a multiple linear regression, Have Minitab run a multiple linea...

Have Minitab run a multiple linear regression to predict the margin of victory using the four predictors (home team record, away team record, stat1diff, stat2diff). Store the resi

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