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

Strategy nash equilibrium, Consider a population of consumers uniformly dis...

Consider a population of consumers uniformly distributed along the interval from left-hand (x = 0) to right-hand (x=1). The mass of consumers is 1. There are two firms (F1 and F2)

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

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

Discrete random varible, A probability distribution is partially given in t...

A probability distribution is partially given in the following table with the additional information that the even values of X are equally likely. Determine the missing entries in

Card custodian, Card custodian An person who is assigned responsibility of...

Card custodian An person who is assigned responsibility of purchase card security & issuance of cards to authorized users,

Describe the statistical results, Q1. A software developer is interested in...

Q1. A software developer is interested in finding what the best color theme should be for an engine diagnostic program for the flight line. He is considering three different color

Determine the simple linear regression model, You have collected data from ...

You have collected data from the factory on a critical to quality attribute. The attached Excel spreadsheet lists the response, Y and four potential predictors. You would like to m

Business tax accounting , #questLester rents his vacation home for 6 months...

#questLester rents his vacation home for 6 months and lives in the home during the other 6 months of 2010. The gross rental income from the home is $4,500. For the entire year, rea

Homework, 9. From 11 positive integer scores on a 10-point quiz, the mean i...

9. From 11 positive integer scores on a 10-point quiz, the mean is 8, the median is 8, and the mode is 7. Find the maximum number of perfect scores possible on this test.

Transition towards ifrs, Transition towards IFRS Over the last few year...

Transition towards IFRS Over the last few years, there has been a tremendous change in the world's capital markets. There has thus been a shift away from the local financial 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