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