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, B, C, D, & Stock exchange

(Type integers or decimals rounded to two decimal places as needed.)

- X Closing Prices Date A 09/03/2010 127.66 09/07/2010 126.31 09/08/2010 124.98 09/09/2010 127.58 09/10/2010 127.11 09/13/2010 129.41 09/14/2010 128.45 09/15/2010 129.51 09/16/2010 129.66 09/17/2010 130.97 09/20/2010 132.67 09/21/2010 130.67 B 18.49 18.05 17.98 18.12 17.99 18.48 18.68 18.55 18.91 18.96 18.89 19.18 21.11 20.65 20.65 20.77 20.68 21.44 21.59 21.46 22.02 21.73 21.86 21.66 D 15.45 15.45 15.65 15.93 16.07 16.13 16.21 16.31 16.33 16.19 16.54 16.48 Stock Exchange 10,355.96 10,393.57 10,323.98 10,465.54 10,499.01 10,516.11 10,524.31 10,628.38 10,663.65 10,637.73 10,829.67 10,708.72 C Print Done Click the icon to view the 09/07/2010 09/08/2010 09/09/2010 09/10/2010 09/13/2010 09/14/2010 09/15/2010 09/16/2010 09/17/2010 09/20/2010 09/21/2010