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.

Data:

Date	A	B	C	D	Stock Exchange
09/03/2010	126.42	18.29	21.06	15.42	10,460.37
09/07/2010	125.42	18.22	20.39	15.39	10,305.36
09/08/2010	125.02	17.81	20.83	15.55	10,345.72
09/09/2010	125.53	18.13	20.48	15.93	10,468.35
09/10/2010	128.88	17.85	20.65	16.11	10,498.93
09/13/2010	128.48	18.74	21.33	16.16	10,636.98
09/14/2010	128.33	18.55	21.53	16.27	10,555.33
09/15/2010	130.44	18.58	21.56	16.35	10,667.35
09/16/2010	129.91	18.98	21.73	16.37	10,601.04
09/17/2010	129.36	18.69	21.99	16.32	10,572.82
09/20/2010	132.34	18.94	21.54	16.49	10,669.03
09/21/2010	133.04	19.24	21.79	16.41	10,824.91

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

Enter your answer in the edit fields and then click Check Answer.