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

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.

\begin{tabular}{|c|l|l|l|l|r|} \hline Date & A & \multicolumn{1}{|c|}{ B } & \multicolumn{1}{|c|}{ C } & \multicolumn{1}{c|}{ D } & \multicolumn{1}{c|}{ Stock Exchange } \\ \hline 09/03/2010 & 127.84 & 18.53 & 20.98 & 15.35 & 10346.23 \\ \hline 09/07/2010 & 125.49 & 18.04 & 20.73 & 15.34 & 10328.09 \\ \hline 09/08/2010 & 127.03 & 17.82 & 20.66 & 15.58 & 10447.99 \\ \hline 09/09/2010 & 126.98 & 17.96 & 20.49 & 15.88 & 10518.16 \\ \hline 09/10/2010 & 129.02 & 17.88 & 20.49 & 16.04 & 10469.06 \\ \hline 09/13/2010 & 130.49 & 18.65 & 21.13 & 16.21 & 10627.51 \\ \hline 09/14/2010 & 129.77 & 18.75 & 21.58 & 16.29 & 10424.34 \\ \hline 09/15/2010 & 130.61 & 18.68 & 21.62 & 16.24 & 10525.98 \\ \hline 09/16/2010 & 130.79 & 19.01 & 22.09 & 16.31 & 10626.67 \\ \hline 09/17/2010 & 129.97 & 18.69 & 22.08 & 16.39 & 10664.67 \\ \hline 09/20/2010 & 131.68 & 18.91 & 21.88 & 16.51 & 10776.07 \\ \hline 09/21/2010 & 131.78 & 19.07 & 21.48 & 16.65 & 10847.31 \\ \hline \end{tabular}