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

Explain the term “trial balance” and its needs, Explain the term “Trial Bal...

Explain the term “Trial Balance” and its needs for an organization. Ans. A Trial Balance is a statement of summarization of the all the involved ledgers accounts at the end of th

Factorial anova , Assessment Two tests your ability to conduct a factorial ...

Assessment Two tests your ability to conduct a factorial ANOVA and make appropriate decisions regarding any follow up comparisons. The following data set is adapted from Jaccard an

Magnetic susceptibility experiment, . Good day, Using 4-inch pole caps and ...

. 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

Index number, How to solve problems of index number fixed based method

How to solve problems of index number fixed based method

Basic accounting, Give certain creative assignment for freshers of accounti...

Give certain creative assignment for freshers of accounting

Cash accounting, Accounting system is one prevalent among agencies in volun...

Accounting system is one prevalent among agencies in voluntary sector. Transactions are registered in journals only when cash is in fact paid out or taken in. The primary virtue of

Pie diagram, A survey was conducted among the residents of Pune City, its s...

A survey was conducted among the residents of Pune City, its suburbs and the Pune Cantonment area. The following three pie diagrams show their respective preferences for living in

Stratified sampling, Stratified Sampling: If the population from which a sa...

Stratified Sampling: If the population from which a sample is to be drawn does not constitute a homogenous group, then stratified sampling technique is applied so as to obtain a re

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