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

Accounting is an art of recording, Accounting is an art of recording Yes...

Accounting is an art of recording Yes, we recognize upon that declaration because if we evaluate the primary features of the accounting program we will find that primary three p

Determine the local luminance, 1. Consider a room 3 m x 3m x 3m with one fa...

1. Consider a room 3 m x 3m x 3m with one façade made of glazing with diffuse transmittance 0.6 and reflectance 0.2. The interior surfaces have a reflectance of 0.5. Consider incid

Linearity, The weight in Kg for each person was matched to their intake of ...

The weight in Kg for each person was matched to their intake of fat per day in Grams.  9 people were selected with the following results. Weight (Xi)         Fat (Yi) 45

Cost accounting, what are the objective and importance of cost accounting a...

what are the objective and importance of cost accounting and managerial decision making.

Statistical inference is that branch of statistics, Statistical inference i...

Statistical inference is that branch of statistics Statistical inference is that branch of statistics which is concerned with using probability concept to deal with uncertainty

How i can find accounting tutor for my homework due in today, How i can fin...

How i can find accounting tutor for my homework due by today? I need urgent help in my homework, please let us know when i can get homework help

MANOVA, 5. Perform a factorial MANOVA on the data. Before interpreting the ...

5. Perform a factorial MANOVA on the data. Before interpreting the multivariate results of the MANOVA, check outcomes that test other assumptions for this statistic: equality of co

Accounts receivable solutions, Volumes due from personal individuals or com...

Volumes due from personal individuals or companies for products, and/or solutions equipped by the condition. Records Receivable does not involve amounts due from other companies, r

Calorimetry, How do I calculate the temperature change of a sample?

How do I calculate the temperature change of a sample?

Impact of government regulation on managerial decision, Impact of governme...

Impact of government regulation on managerial Decision making Impact of government regulation on managerial Decision making how methods of control can influence market prices.

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