The accompanying data set provides the closing prices for fourstocks and the stock exchange over 12 days:
| Date | A | B | C | D | Stock Exchange |
| 9/3/10 | 127.37 | 18.34 | 21.03 | 15.51 | 10432.45 |
| 9/7/10 | 127.15 | 18.18 | 20.44 | 15.51 | 10334.67 |
| 9/8/10 | 124.92 | 17.88 | 20.57 | 15.82 | 10468.41 |
| 9/9/10 | 127.35 | 17.95 | 20.52 | 16.02 | 10498.61 |
| 9/10/10 | 128.37 | 17.82 | 20.42 | 15.98 | 10563.84 |
| 9/13/10 | 128.36 | 18.64 | 21.16 | 16.21 | 10616.07 |
| 9/14/10 | 128.61 | 18.83 | 21.29 | 16.22 | 10565.83 |
| 9/15/10 | 130.17 | 18.79 | 21.69 | 16.25 | 10627.97 |
| 9/16/10 | 130.34 | 19.16 | 21.76 | 16.36 | 10595.39 |
| 9/17/10 | 129.37 | 18.82 | 21.69 | 16.26 | 10517.99 |
| 9/20/10 | 130.97 | 19.12 | 21.75 | 16.41 | 10661.11 |
| 9/21/10 | 131.16 | 19.02 | 21.55 | 16.57 | 10687.95 |
Using Excel's Data Analysis Exponential Smoothing tool, forecasteach of the stock prices using simple exponential smoothing with asmoothing constant of 0.3.
For example, help me to understand how to complete theexponential smoothing forecast model for StockA.
Date Forecast A
9/3/2010 ____
9/7/2010 ____
9/8/2010 ____
9/9/2010 ____
9/10/2010 ____
9/13/2010 ____
9/14/2010 ____
9/15/2010 ____
9/16/2010 ____
9/17/2010 ____
9/20/2010 ____
9/21/2010 ____
