Reference no: EM132817867
The accompanying dataset provides the closing prices for four stocks and the stock exchange over 12 days. Complete parts a through c.
Date A B C D Stock Exchange
09/03/2010 128.41 18.44 21.01 15.46 10,348.41
09/07/2010 126.43 18.21 20.65 15.32 10,387.99
09/08/2010 125.74 18.03 20.65 15.65 10,458.24
09/09/2010 126.48 17.83 20.65 15.98 10,432.73
09/10/2010 127.09 17.89 20.72 15.83 10,478.29
09/13/2010 130.19 18.71 21.43 16.25 10,623.48
09/14/2010 130.09 18.88 21.57 16.05 10,444.89
09/15/2010 128.74 18.64 21.71 16.18 10,567.38
09/16/2010 129.25 18.93 22.13 16.26 10,609.54
09/17/2010 130.57 18.99 21.95 16.23 10,599.16
09/20/2010 132.72 18.78 21.72 16.68 10,783.53
09/21/2010 131.99 19.25 21.47 16.43 10,784.47
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.)