assignment_stock_prices_2.xlsx
Sheet1
| | INDUSTRY A | | | INDUSTRY B |
| | Company A1 | Company A2 | Company A3 | Company B1 | Company B2 | Company B3 |
| 12/1/10 | 30.67 | 56.08 | 49.71 | 31.3 | 50.61 | 19.25 |
| 11/1/10 | 32.84 | 54.95 | 50.2 | 27.05 | 46.93 | 17.86 |
| 10/1/10 | 28.19 | 51.31 | 46.17 | 29.38 | 51.73 | 18.15 |
| 9/1/10 | 29.25 | 48.76 | 44.16 | 26.85 | 49.31 | 17.26 |
| 8/2/10 | 27.31 | 45.27 | 42.79 | 21.85 | 43.54 | 14.42 |
| 7/1/10 | 29.18 | 44.32 | 41.35 | 23.64 | 45.87 | 13.82 |
| 6/1/10 | 27.55 | 41.63 | 37.69 | 21.46 | 44.3 | 16.04 |
| 5/3/10 | 30.23 | 62.59 | 40.74 | 22.57 | 42.43 | 18.96 |
| 4/1/10 | 28.57 | 60.72 | 39.56 | 25.87 | 47.45 | 18.56 |
| 3/1/10 | 25.25 | 59.22 | 36.61 | 25.71 | 48.17 | 21.66 |
| 2/1/10 | 23.89 | 55.74 | 32.99 | 24.65 | 44.58 | 18.81 |
| 1/4/10 | 23.49 | 49.52 | 30.88 | 23.06 | 45.32 | 19.43 |
| 12/1/09 | 22.43 | 48.3 | 27.83 | 24.53 | 46.81 | 23.01 |
| 11/2/09 | 23 | 48.97 | 30.51 | 22.08 | 47.87 | 18.55 |
| 10/1/09 | | 45.13 | 28.3 | 21.1 | 45.27 | 17.8 |
| 9/1/09 | | 48.68 | 26.4 | 20.84 | 48.87 | 22.03 |
| 8/3/09 | | 49.94 | 30.28 | 21.88 | 48.76 | 18.66 |
| 7/1/09 | | 46.12 | 31.42 | 22.13 | 47.25 | 20 |
| 6/1/09 | | 42.1 | 28.3 | 21.42 | 40.19 | 16.49 |
| 5/1/09 | | 44.77 | 30.27 | 19.59 | 43.35 | 15 |
| 4/1/09 | | 42.34 | 33.19 | 19.34 | 38.09 |
| 3/2/09 | | 44.55 | 33.37 | 18.07 | 35.29 |
| 2/2/09 | | 38.82 | 27.44 | 15.54 | 32.14 |
| 1/2/09 | | 42.71 | 27.77 | 16.83 | 35.38 |
| 12/1/08 | | 41.69 | 26.07 | 17.73 | 36.22 |
| 11/3/08 | | 42.29 | 27.78 | 16.09 | 34.14 |
| 10/1/08 | | 38.02 | 26.91 | 18.29 | 35.33 |
| 9/2/08 | | 36.36 | 23.7 | 20.31 | 53.43 |
| 8/1/08 | | 38.36 | 24.92 | 21.93 | 56.08 |
| 7/1/08 | | 37.5 | 23.3 | 21.53 | 57.81 |
| 6/2/08 | | 32.69 | 19.94 | 21 | 52.11 |
| 5/1/08 | | 36.9 | 21.4 | 22.84 | 54.6 |
| 4/1/08 | | 31.6 | 21.4 | 20.85 | 50.23 |
| 3/3/08 | | 27.59 | 19.5 | 19.56 | 49.57 |
| 2/1/08 | | 26.83 | 19.15 | 18.8 | 47.41 |
| 1/2/08 | | 28.01 | 21.04 | 20.55 | 47.71 |
| 12/3/07 | | 25.92 | 19.23 | 22.58 | 51.05 |
| 11/1/07 | | 28.66 | 23.55 | 20.18 | 51.22 |
| 10/1/07 | | 38.3 | 25.35 | 22.17 | 54.28 |
| 9/4/07 | | 40.54 | 26.56 | 21.65 | 58.67 |
| 8/1/07 | | 43.45 | 29.28 | 20.28 | 54.07 |
| 7/2/07 | | 38.26 | 29.62 | 19.12 | 53.92 |
| 6/1/07 | | 43.55 | 34.32 | 19.71 | 51.07 |
| 5/1/07 | | 42.31 | 33.65 | 19.38 | 47.74 |
| 4/2/07 | | 39.32 | 31.84 | 18.8 | 48 |
| 3/1/07 | | 38.24 | 29.62 | 18.13 | 44.65 |
| 2/1/07 | | 34.11 | 28.96 | 16.43 | 46.02 |
| 1/3/07 | | 31.45 | 32.4 | 17.16 | 46.34 |
| 12/1/06 | | 30.1 | 29.33 | 17.14 | 53.1 |
| 11/1/06 | | 30.01 | 27.89 | 19.05 | 52.22 |
| 10/2/06 | | 31.09 | 29.45 | 18.47 | 49.64 |
| 9/1/06 | | 30.96 | 29.24 | 17.74 | 49.5 |
| 8/1/06 | | 28.78 | 25.57 | 15.66 | 47.74 |
| 7/3/06 | | 26.6 | 22.72 | 14.97 | 45.63 |
| 6/1/06 | | 26.5 | 24.43 | 14.49 | 52.52 |
| 5/1/06 | | 26.43 | 24.98 | 14.22 | 52.63 |
| 4/3/06 | | 26.07 | 25 | 14.59 | 54.63 |
| 3/1/06 | | 27.67 | 26.6 | 13.69 | 54.32 |
| 2/1/06 | | 27.42 | 25.72 | 12.42 | 51.1 |
| 1/3/06 | | 24.8 | 23.95 | 12.57 | 51.37 |
| 12/1/05 | | 23.94 | 24.79 | 12.21 | 45.07 |
| 11/1/05 | | 22.96 | 22.51 | 12.6 | 45.15 |
| 10/3/05 | | 21.57 | 22.14 | 12.68 | 42.94 |
| 9/1/05 | | 21.65 | 19.87 | 12.4 | 43.33 |
| 8/1/05 | | 22.77 | 19.88 | 12.99 | 42.67 |
| 7/1/05 | | 24.99 | 25.8 | 13.57 | 42.82 |
| 6/1/05 | | 24 | 26.1 | 13.2 | 43.3 |
| 5/2/05 | | 24.8 | 25.67 | 12.8 | 41.25 |
| 4/1/05 | | 24.48 | 26.98 | 11.56 | 39.43 |
| 3/1/05 | | 28.73 | 30.36 | 12.48 | 40.08 |
| 2/1/05 | | 26.95 | 32.92 | 12.95 | 40.55 |
| 1/3/05 | | 27.23 | 33.45 | 13.77 | 38.72 |
| 12/1/04 | | 28.77 | 31.23 | 13.72 | 44.21 |
| 11/1/04 | | 27.83 | 29.3 | 12.74 | 44.5 |
| 10/1/04 | | 28.9 | 29.55 | 12.66 | 42.65 |
| 9/1/04 | | 26.95 | 27.1 | 11.28 | 38.95 |
| 8/2/04 | | 23.51 | 26.45 | 9.97 | 36.46 |
| 7/1/04 | | 26.91 | 27.86 | 10.51 | 40.01 |
| 6/1/04 | | 27.43 | 30.42 | 11.93 | 41.81 |
| 5/3/04 | | 27.9 | 31.36 | 11.4 | 40.4 |
| 4/1/04 | | 26.98 | 32.14 | 11.25 | 37.28 |
| 3/1/04 | | 30.86 | 35.95 | 12 | 39.31 |
| 2/2/04 | | 30.9 | 38.04 | 12.87 | 39.6 |
| 1/2/04 | | 31.91 | 34.64 | 13.86 | 41.46 |
| 12/1/03 | | 30.07 | 35.88 | 13.23 | 41.56 |
| 11/3/03 | | 31.72 | 38.58 | 12.02 | 38.55 |
| 10/1/03 | | 38.29 | 43.61 | 11.97 | 36.54 |
| 9/2/03 | | 33.55 | 39.89 | 11.25 | 30.41 |
| 8/1/03 | | 39.22 | 40.12 | 12.83 | 29.94 |
| 7/1/03 | | 36.73 | 37.51 | 11.99 | 29.35 |
| 6/2/03 | | 31.77 | 38.15 | 12.01 | 29.22 |
| 5/1/03 | | 29 | 36.45 | 13.01 | 28.48 |
| 4/1/03 | | 25.44 | 34.19 | 11.88 | 25.51 |
| 3/3/03 | | 19.9 | 30.88 | 10.84 | 18.96 |
| 2/3/03 | | 20.65 | 28.22 | 11.96 | 20.9 |
| 1/2/03 | | 21.96 | 30.12 | 12.03 | 23.5 |