Question: Exce NSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW david The gross domestic product (GDP) of the United States from 1993 to 2003 is given in
Exce NSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW david The gross domestic product (GDP) of the United States from 1993 to 2003 is given in the table below. The numbers are in billions of U.S. dollars. Develop forecasts for the GDP of 2004 using 3 year moving average, 3 year weighted moving average (weights: .6, .3, .1-yes, these are weights with decimals), 4 year weighted moving average (weights: 5,4, 2, 1) and exponential smoothing with a smoothing constant of 0.6. Assume the forecast is 6,657.00 (SBillions) for 1993. Which of these models would you choose to use and why? Year (SBillions) 1993 6,657.00 1994 7,072.00 1995 7,398.00 1996 7,817.00 1997 8,304.00 1998 8,747.00 1999 9,268.00 2000 9,817.00 2001 10,128.00 2002 10,487.00 2003 11,004.00 Prob 1 Prob 2 Pr
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
