v

The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days Complete parts a through c Click the icon to view the closing prices data a. Use Excef'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 anded) Date Forecast A 09/03/2010 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 00/14/2010 09/15/2010 09/16/2010 09/17/2010 09/20/2010 09/21/2010 00000000000 PORNEO OS Save nof Closing Prices A B C D 18.42 15.32 15.46 15.64 15.89 Date 09/03/2010 126.38 21.11 09/07/2010 126.74 18.11 20.75 09/08/2010 126.18 17.91 20.48 09/09/2010 125.69 17.92 20.48 09/10/2010 12835 17.84 20.71 15.89 09/13/2010 130.35 18.52 21.45 16.16 09/14/2010 128.66 18.64 21.61 09/15/2010 130.39 18.87 21.72 16.46 09/16/2010 130.07 18.88 21.83 16.18 09/17/2010 129.79 18.63 22.02 16.36 09/20/2010 130.92 18.91 21.89 09/21/2010 133.17 19:24 21.74 16.56 16.45 Print Done Stock Exchange 10,415.31 10,395.93 10,447.99 10,392.34 10,522.66 10,452.63 16.26 10,491.98 10,534.27 10,630.93 10,702.13 10,732.04 10,713.35 - X