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

Calculate s.d, Less than 5 yrs 22 5-10 18 10-20 5 20-30 4 More than 30 1

Less than 5 yrs 22 5-10 18 10-20 5 20-30 4 More than 30 1

Compute three protected tests , compute three protected t tests to compar...

compute three protected t tests to compare all possible pairs of means.  Also, for α = .05, what is the value of LSD ? Which pairs are significantly different from one another,

How to calculate midrange in statistics?, Midrange The midrange is the ...

Midrange The midrange is the measure of the center that is the value midway between the highest and the lowest values in the original data set. It is found by adding the highes

IFRS 9, The company acquired 50000 8% preferencd shares (with a par value o...

The company acquired 50000 8% preferencd shares (with a par value of R4 each) in cross limited on 30 june 2006 for R180000.

Basis of accounting, Basis of accounting This represents the technique and...

Basis of accounting This represents the technique and time of when income and costs or costs are acknowledged in the records and revealed in the fiscal reports. Talk about ACCRUAL

Difference in the mean leadership score for employees - spss, The manager o...

The manager of a large industrial plant is interested in investigating whether age has an effect on the leadership ability of employees. 66 employees were randomly selected, divide

Probability, a survey of grocery revealed 40 percent had a pharmacy, 50 per...

a survey of grocery revealed 40 percent had a pharmacy, 50 percent had a floral shop, and70 percent had a deli. suppose 10 percent of the stores have all three departments, 30 perc

Budgetary control, Budgetary control The manage or management of a governm...

Budgetary control The manage or management of a governmental component in agreement with an approved budget for the purpose of keeping expenditures within the limits of available

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