| Closing Stock Prices | | Page 353 Question 8 and 9 |
| | | Q8: Using Moving average AP = 2 and 3 for each of the five stocks (including DJIndex) |
| | | Q9: Using simple exponential smooth with alpha = 0.1 to 0.5 and find the best alpha for each of the stocks. |
| Date | IBM | INTC | CSCO | GE | DJ Industrials
Index |
| 9/3/10 | $127.58 | $18.43 | $21.04 | $15.39 | 10447.93 |
| 9/7/10 | $125.95 | $18.12 | $20.58 | $15.44 | 10340.69 |
| 9/8/10 | $126.08 | $17.90 | $20.64 | $15.70 | 10387.01 |
| 9/9/10 | $126.36 | $18.00 | $20.61 | $15.91 | 10415.24 |
| 9/10/10 | $127.99 | $17.97 | $20.62 | $15.98 | 10462.77 |
| 9/13/10 | $129.61 | $18.56 | $21.26 | $16.25 | 10544.13 |
| 9/14/10 | $128.85 | $18.74 | $21.45 | $16.16 | 10526.49 |
| 9/15/10 | $129.43 | $18.72 | $21.59 | $16.34 | 10572.73 |
| 9/16/10 | $129.67 | $18.97 | $21.93 | $16.23 | 10594.83 |
| 9/17/10 | $130.19 | $18.81 | $21.86 | $16.29 | 10607.85 |
| 9/20/10 | $131.79 | $18.93 | $21.75 | $16.55 | 10753.62 |
| 9/21/10 | $131.98 | $19.14 | $21.64 | $16.52 | 10761.03 |
| 9/22/10 | $132.57 | $19.01 | $21.67 | $16.50 | 10739.31 |
| 9/23/10 | $131.67 | $18.98 | $21.53 | $16.14 | 10662.42 |
| 9/24/10 | $134.11 | $19.42 | $22.09 | $16.66 | 10860.26 |
| 9/27/10 | $134.65 | $19.24 | $22.11 | $16.43 | 10812.04 |
| 9/28/10 | $134.89 | $19.51 | $21.86 | $16.44 | 10858.14 |
| 9/29/10 | $135.48 | $19.24 | $21.87 | $16.36 | 10835.28 |
| 9/30/10 | $134.14 | $19.20 | $21.90 | $16.25 | 10788.05 |
| 10/1/10 | $135.64 | $19.32 | $21.91 | $16.36 | 10829.68 |
Helpplease127
Forecast3assignments.xlsx
