Calculate a forecast using exponential smoothing, Basic Statistics

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.

Posted Date: 2/28/2013 1:20:56 AM | Location : United States







Related Discussions:- Calculate a forecast using exponential smoothing, Assignment Help, Ask Question on Calculate a forecast using exponential smoothing, Get Answer, Expert's Help, Calculate a forecast using exponential smoothing Discussions

Write discussion on Calculate a forecast using exponential smoothing
Your posts are moderated
Related Questions
what is the importance of time series

A simple random sample of n = 300 full-time workers is selected from a company list containing the names of all n = 5000 full-time workers in order to evaluate job satisfaction. Gi

Continuous probability distributions: Procurement and working capital analysis – Normally distributed random variables and their transformation Procedures The data is measure

This assignment is designed to compare performance between Matlab and Excel for performing nonlinear regression analysis of a set of data. There are two data sets in the accompanyi

Modern hotels and certain establishments make use of an electronic door lock system. To open a door an electronic card is inserted into a slot. A green light indicates that the doo

. Good day, Using 4-inch pole caps and a Mettler M5 balance, I got all the values required in order to calculate the magnetic susceptibility of several inorganic compounds such as

A researcher working for a drug company is interested in investigating the effect of storage on the potency of one of the company's drugs. 10 freshly produced bottles of the drug a

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

Methods of measuring secular trend

ANOVA 1 and 2 way, t and f-tests 1,2 or more means... standard deviations known/unknown. I have a project where I must use these tests, but I''m not clear on the when and how.