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

How would you go about choosing a random sample, Q. Suppose a study is bein...

Q. Suppose a study is being done and the population is the American public. How would you go about choosing a random sample population to phone for a survey? Solution: One w

The value of its common stock, The Washington Corp stock has a β of 1.15 an...

The Washington Corp stock has a β of 1.15 and it will pay a dividend of $2.50 next year. The expected rate of return of the market is 17% and the current riskless rate is 9%. The e

To find first quartile, how to find 1st quartile from the graph of more tha...

how to find 1st quartile from the graph of more than ogive type, please reply me with an example

Cash flow analysis, Cash flow analysis In financial sales, an income rep...

Cash flow analysis In financial sales, an income report, also known as report of money runs or funds circulation report is a financial report that shows how changes in stability

Application of statistics, Mention the characteristics of Statistics. Expla...

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

Computing observed probability values , For an alignment shown below derive...

For an alignment shown below derive log-odds score for the column 1 only by a)  Computing observed probability values b)  Expected probability values TAGCTT AAGCTC T

Inventory, An audit of the accounting records of Loch Ness Ltd. for the ye...

An audit of the accounting records of Loch Ness Ltd. for the year ending 30 June 2012 discovered that the ending inventory balance was over-valued by $35,000

Full and restricted models - testing research hypotheses, 1. Suppose you ar...

1. Suppose you are given a dataset that consists of a random sample of tasters, on which the following variables were obtained: (y) Zpref = taste preference for green beans stor

Define brand loyalty and perception, Definition of brand loyalty is termed ...

Definition of brand loyalty is termed as the commitment towards a particular brand. Brand loyalty is the perception of a brand in consumer’s mind which is used as leads him/her to

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