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

Holding period return, Holding period return: Holding period return is the ...

Holding period return: Holding period return is the return earned by the virtue of holding an asset over a given period. The return is equal to the income and other gains earned fr

Homework, I will need to upload the question sheets.

I will need to upload the question sheets.

Intervals, At a tennis tournament a statistician keeps track of every serve...

At a tennis tournament a statistician keeps track of every serve. The statistician reported that the mean serve speed of a particular player was 102 miles per hour (mph) and the st

Calculate a confidence interval for the population, A Shoe manufacturing co...

A Shoe manufacturing company designs a new shoe (Brand A) and it wanted to compare its fit with that of the leading brands in the market Nike and Reebok. 27 Customers were asked to

Illustrative statistics with statistics, Company statistics is the technolo...

Company statistics is the technology of good selection in the face of concern and is used in many professions such as financial statistics, econometrics, auditing, generation and f

Calculate the marginals for the rows and columns, (1) Public health schol...

(1) Public health scholars have noted a relationship between nancial well-being follow-ing catastrophe and rates of depression. Weber, Kenny, and Bratton (2010) examine this rela

Construct a cumulative relative frequency plot, Examine the distributions o...

Examine the distributions of weight and height. Are there any outliers? If so deal with them appropriately. Create a new variable that divides weight into groups. Produce a tabl

Schedules, what are the characteristics of schedules

what are the characteristics of schedules

Compute the mean absolute deviation and mean square error, Toyota Motors in...

Toyota Motors introduced a hybrid car Hybrid G in the U.S. market in 2006. In the first three years, the sales of Hybrid G were strong due to the buzz surrounding the hybrid car co

Oecd database exercise , For this second assignment you will have to use th...

For this second assignment you will have to use the OECD database to investigate possible changes in the policy preferences of Western welfare states. You have to develop (i) an in

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