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
09/03/2010
09/07/2010	nothing
09/08/2010	nothing
09/09/2010	nothing
09/10/2010	nothing
09/13/2010	nothing
09/14/2010	nothing
09/15/2010	nothing
09/16/2010	nothing
09/17/2010	nothing
09/20/2010	nothing
09/21/2010	nothing

Date	A	B	C	D	Stock Exchange
09/03/2010	127.11	18.44	20.85	15.31	10446.15
09/07/2010	125.75	18.23	20.75	15.52	10429.45
09/08/2010	125.56	17.94	20.53	15.68	10406.78
09/09/2010	125.86	17.92	20.43	15.91	10311.23
09/10/2010	128.31	18.06	20.68	15.84	10531.22
09/13/2010	129.53	18.41	21.23	16.21	10532.51
09/14/2010	128.36	18.56	21.55	16.28	10462.54
09/15/2010	129.04	18.59	21.53	16.24	10578.29
09/16/2010	129.47	18.97	22.11	16.25	10551.37
09/17/2010	130.43	18.89	21.85	16.23	10619.11
09/20/2010	132.94	18.86	21.85	16.39	10807.11
09/21/2010	133.28	19.19	21.77	16.45	10824.02