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

Limitation of the financial accounting, Limitation of the Financial Account...

Limitation of the Financial Accounting. There much limitation can be considered in case of the Financial Accounting but here we are discussing the main two limitations  It re

Atomistic fallacy, Atomistic fallacy The fallacy which arises because of...

Atomistic fallacy The fallacy which arises because of the association amongst the two variables at the individual level might differ from the association between the similar two

The data analysis process and statistical techniques, I need to conduct an...

I need to conduct an analysis' on an alcohol and substance abuse study. the data set is too large to upload . The data set is the SPSS version that I need to work from. Here is the

Joy, Ask questio How many women must be randomly selected to estimate the m...

Ask questio How many women must be randomly selected to estimate the mean weight of women in one age group? We want 90% confidence that the sample mean is within 3.7 lbs of the po

Frequency, midpoint of class containing highest frequency

midpoint of class containing highest frequency

Process costing, discuss the steps in preparing product cost allocation.

discuss the steps in preparing product cost allocation.

Standard deviation, the first four moments of a distribution about the mean...

the first four moments of a distribution about the mean are 0,16,-64 and 162.what is the standard deviation ?

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