Click the icon to view the closing prices data ocks and the stock exchange over 12...

Transcribed Image Text:

Click the icon to view the closing prices data ocks and the stock exchange over 12 days. Complete parts a through c a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3 Complete the exponential smoothing forecast model for stock A (Type integers or decimals rounded to two decimal places as needed.) Date Forecast A Closing Prices - 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 09/14/2010 09/15/2010 09/16/2010 2014710040 Stock Date 09/03/2010 A B C D Exchange 127.07 18.54 20.84 15.44 10,536.56 09/07/2010 124.84 18.21 20.45 15.55 10,245.77 09/08/2010 125.67 17.77 20.83 15.72 10,320 11 09/09/2010 126.46 17.95 20.56 15.92 10,490.35 09/10/2010 126.88 18.01 20.73 16.01 10,384 72 09/13/2010 128.77 18.66 09/14/2010 129.34 18.71 09/15/2010 128.41 18.74 21.43 09/16/2010 129.12 18.84 21.89 21.13 16.13 10.558.58 21.46 16.21 10.609.24 16.33 10,485.36 16.37 10,508.38 Click the icon to view the closing prices data ocks and the stock exchange over 12 days. Complete parts a through c a. Use Excel's Data Analysis Exponential Smoothing tool to forecast each of the stock prices using simple exponential smoothing with a smoothing constant of 0.3 Complete the exponential smoothing forecast model for stock A (Type integers or decimals rounded to two decimal places as needed.) Date Forecast A Closing Prices - 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 09/14/2010 09/15/2010 09/16/2010 2014710040 Stock Date 09/03/2010 A B C D Exchange 127.07 18.54 20.84 15.44 10,536.56 09/07/2010 124.84 18.21 20.45 15.55 10,245.77 09/08/2010 125.67 17.77 20.83 15.72 10,320 11 09/09/2010 126.46 17.95 20.56 15.92 10,490.35 09/10/2010 126.88 18.01 20.73 16.01 10,384 72 09/13/2010 128.77 18.66 09/14/2010 129.34 18.71 09/15/2010 128.41 18.74 21.43 09/16/2010 129.12 18.84 21.89 21.13 16.13 10.558.58 21.46 16.21 10.609.24 16.33 10,485.36 16.37 10,508.38