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

Determine the coefficient of determination, 1. A researcher was interested ...

1. A researcher was interested lowering the high school dropout level in his county. He measured the reading level of students entering middle school (based on a standard test) and

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

Probability, A survey was done where a random sample of people 18 and over ...

A survey was done where a random sample of people 18 and over were asked if they preferred comedies, dramas, or neither. The information gathered was broken down by age group and t

Current development project and presentation , review the financial disclos...

review the financial disclosures for two publicly traded companies. Identify recently promulgated (or proposed) accounting pronouncements that have an impact on the companies. In a

Explain what is signal reliability ration, A. If CD players are able to use...

A. If CD players are able to use the LDD strategy better than pure chance then explain what happens to the signal reliability ration as a CD player detects more cautiously B. As

Statistical analysis of hedge funds returns, In this problem set we are goi...

In this problem set we are going to analyze returns of indices for three hedge funds strategies (market neutral, risky arbitrage, long/short). The indices are constructed by CSFB/T

Difference, difference b/w historigrams & histogram?

difference b/w historigrams & histogram?

What is Art collection , What is Art collection A personal perform of art...

What is Art collection A personal perform of art or number of products of unique graphics such as artwork, statues, craftwork or other elements generally determined as a perform

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