The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through

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.30.3.

Complete the exponential smoothing forecast model for stock A.

b. Compute the MAD, MSE, and MAPE for each of the models.

c. Does a smoothing constant of 0.10.1 or 0.50.5 yield better results?

Date A 09/03/2010 126.82 09/07/2010 126.17 09/08/2010 126.69 09/09/2010 125.56 09/10/2010 127.99 09/13/2010 129.67 09/14/2010 128.74 09/15/2010 129.11 09/16/2010 128.48 09/17/2010 128.93 09/20/2010 131.26 09/21/2010 131.81 B C D 18.43 21.17 15.25 18.11 20.66 15.33 17.75 20.52 15.76 17.85 20.52 16.04 17.88 20.68 15.99 18.45 21.07 16.19 18.83 21.28 16.21 18.61 21.45 16.27 18.91 22.05 16.09 18.8921.76 16.29 18.91 21.71 16.49 19.02 21.58 16.37 Stock Exchange 10,490.82 10,306.32 10,487.66 10,411.69 10,565.98 10,491.49 10,426.69 10,630.85 10,500.47 10.572.74 10,783.82 10,798.51 Date A 09/03/2010 126.82 09/07/2010 126.17 09/08/2010 126.69 09/09/2010 125.56 09/10/2010 127.99 09/13/2010 129.67 09/14/2010 128.74 09/15/2010 129.11 09/16/2010 128.48 09/17/2010 128.93 09/20/2010 131.26 09/21/2010 131.81 B C D 18.43 21.17 15.25 18.11 20.66 15.33 17.75 20.52 15.76 17.85 20.52 16.04 17.88 20.68 15.99 18.45 21.07 16.19 18.83 21.28 16.21 18.61 21.45 16.27 18.91 22.05 16.09 18.8921.76 16.29 18.91 21.71 16.49 19.02 21.58 16.37 Stock Exchange 10,490.82 10,306.32 10,487.66 10,411.69 10,565.98 10,491.49 10,426.69 10,630.85 10,500.47 10.572.74 10,783.82 10,798.51