Discussion

profile9qh0o1k52
GEversusDJIBeta.xls
Home>Business & Finance homework help>Discussion

GE.csv

Date Close: GE Monthly Return: GE Close: ^DJI Monthly Return: ^DJI
10/1/07 41.16 13930.009766
11/1/07 38.29 -7.0% 13371.719727 -4.0%
12/1/07 37.07 -3.2% 13264.820313 -0.8%
1/1/08 35.36 -4.6% 12650.360352 -4.6%
2/1/08 33.14 -6.3% 12266.389648 -3.0%
3/1/08 37.01 11.7% 12262.889648 -0.0%
4/1/08 32.70 -11.6% 12820.129883 4.5%
5/1/08 30.72 -6.1% 12638.320313 -1.4%
6/1/08 26.69 -13.1% 11350.009766 -10.2%
7/1/08 28.29 6.0% 11378.019531 0.2%
8/1/08 28.10 -0.7% 11543.959961 1.5%
9/1/08 25.50 -9.3% 10850.660156 -6.0%
10/1/08 19.51 -23.5% 9325.009766 -14.1%
11/1/08 17.17 -12.0% 8829.040039 -5.3%
12/1/08 16.20 -5.6% 8776.389648 -0.6%
1/1/09 12.13 -25.1% 8000.859863 -8.8%
2/1/09 8.51 -29.8% 7062.930176 -11.7%
3/1/09 10.11 18.8% 7608.919922 7.7%
4/1/09 12.65 25.1% 8168.120117 7.3%
5/1/09 13.48 6.6% 8500.330078 4.1%
6/1/09 11.72 -13.1% 8447 -0.6%
7/1/09 13.40 14.3% 9171.610352 8.6%
8/1/09 13.90 3.7% 9496.280273 3.5%
9/1/09 16.42 18.1% 9712.280273 2.3%
10/1/09 14.26 -13.2% 9712.730469 0.0%
11/1/09 16.02 12.3% 10344.839844 6.5%
12/1/09 15.13 -5.6% 10428.049805 0.8%
1/1/10 16.08 6.3% 10067.330078 -3.5%
2/1/10 16.06 -0.1% 10325.259766 2.6%
3/1/10 18.20 13.3% 10856.629883 5.1%
4/1/10 18.86 3.6% 11008.610352 1.4%
5/1/10 16.35 -13.3% 10136.629883 -7.9%
6/1/10 14.42 -11.8% 9774.019531 -3.6%
7/1/10 16.12 11.8% 10465.94043 7.1%
8/1/10 14.48 -10.2% 10014.719727 -4.3%
9/1/10 16.25 12.2% 10788.049805 7.7%
10/1/10 16.02 -1.4% 11118.490234 3.1%
11/1/10 15.83 -1.2% 11006.019531 -1.0%
12/1/10 18.29 15.5% 11577.509766 5.2%
1/1/11 20.14 10.1% 11891.929688 2.7%
2/1/11 20.92 3.9% 12226.339844 2.8%
3/1/11 20.05 -4.2% 12319.730469 0.8%
4/1/11 20.45 2.0% 12810.540039 4.0%
5/1/11 19.64 -4.0% 12569.790039 -1.9%
6/1/11 18.86 -4.0% 12414.339844 -1.2%
7/1/11 17.91 -5.0% 12143.240234 -2.2%
8/1/11 16.31 -8.9% 11613.530273 -4.4%
9/1/11 15.22 -6.7% 10913.379883 -6.0%
10/1/11 16.71 9.8% 11955.009766 9.5%
11/1/11 15.91 -4.8% 12045.679688 0.8%
12/1/11 17.91 12.6% 12217.55957 1.4%
1/1/12 18.71 4.5% 12632.910156 3.4%
2/1/12 19.05 1.8% 12952.070313 2.5%
3/1/12 20.07 5.4% 13212.040039 2.0%
4/1/12 19.58 -2.4% 13213.629883 0.0%
5/1/12 19.09 -2.5% 12393.450195 -6.2%
6/1/12 20.84 9.2% 12880.089844 3.9%
7/1/12 20.75 -0.4% 13008.679688 1.0%
8/1/12 20.71 -0.2% 13090.839844 0.6%
9/1/12 22.71 9.7% 13437.129883 2.6%
10/1/12 21.06 -7.3% 13096.459961 -2.5%
11/1/12 21.13 0.3% 13025.580078 -0.5%
12/1/12 20.99 -0.7% 13104.139648 0.6%
1/1/13 22.28 6.1% 13860.580078 5.8%
2/1/13 23.22 4.2% 14054.490234 1.4%
3/1/13 23.12 -0.4% 14578.540039 3.7%
4/1/13 22.29 -3.6% 14839.799805 1.8%
5/1/13 23.32 4.6% 15115.570313 1.9%
6/1/13 23.19 -0.6% 14909.599609 -1.4%
7/1/13 24.37 5.1% 15499.540039 4.0%
8/1/13 23.14 -5.0% 14810.30957 -4.4%
9/1/13 23.89 3.2% 15129.669922 2.2%
10/1/13 26.14 9.4% 15545.75 2.8%
11/1/13 26.66 2.0% 16086.410156 3.5%
12/1/13 28.03 5.1% 16576.660156 3.0%
1/1/14 25.13 -10.3% 15698.849609 -5.3%
2/1/14 25.47 1.4% 16321.709961 4.0%
3/1/14 25.89 1.6% 16457.660156 0.8%
4/1/14 26.89 3.9% 16580.839844 0.7%
5/1/14 26.79 -0.4% 16717.169922 0.8%
6/1/14 26.28 -1.9% 16826.599609 0.7%
7/1/14 25.15 -4.3% 16563.300781 -1.6%
8/1/14 25.98 3.3% 17098.449219 3.2%
9/1/14 25.62 -1.4% 17042.900391 -0.3%
10/1/14 25.81 0.7% 17390.519531 2.0%
11/1/14 26.49 2.6% 17828.240234 2.5%
12/1/14 25.27 -4.6% 17823.070313 -0.0%
1/1/15 23.89 -5.5% 17164.949219 -3.7%
2/1/15 25.99 8.8% 18132.699219 5.6%
3/1/15 24.81 -4.5% 17776.119141 -2.0%
4/1/15 27.08 9.1% 17840.519531 0.4%
5/1/15 27.27 0.7% 18010.679688 1.0%
6/1/15 26.57 -2.6% 17619.509766 -2.2%
7/1/15 26.10 -1.8% 17689.859375 0.4%
8/1/15 25.01 -4.2% 16528.029297 -6.6%
9/1/15 25.22 0.8% 16284.700195 -1.5%
10/1/15 28.92 14.7% 17663.539063 8.5%
11/1/15 29.94 3.5% 17719.919922 0.3%
12/1/15 31.15 4.0% 17425.029297 -1.7%
1/1/16 29.10 -6.6% 16466.300781 -5.5%
2/1/16 29.14 0.1% 16516.5 0.3%
3/1/16 31.79 9.1% 17685.089844 7.1%
4/1/16 30.75 -3.3% 17773.640625 0.5%
5/1/16 30.23 -1.7% 17787.199219 0.1%
6/1/16 31.48 4.1% 17929.990234 0.8%
7/1/16 31.14 -1.1% 18432.240234 2.8%
8/1/16 31.24 0.3% 18400.880859 -0.2%
9/1/16 29.62 -5.2% 18308.150391 -0.5%
10/1/16 29.10 -1.8% 18142.419922 -0.9%
11/1/16 30.76 5.7% 19123.580078 5.4%
12/1/16 31.60 2.7% 19762.599609 3.3%
1/1/17 29.70 -6.0% 19864.089844 0.5%
2/1/17 29.81 0.4% 20812.240234 4.8%
3/1/17 29.80 -0.0% 20663.220703 -0.7%
4/1/17 28.99 -2.7% 20940.509766 1.3%
5/1/17 27.38 -5.6% 21008.650391 0.3%
6/1/17 27.01 -1.4% 21349.630859 1.6%
7/1/17 25.61 -5.2% 21891.119141 2.5%
8/1/17 24.55 -4.1% 21948.099609 0.3%
9/1/17 25.11 2.3% 22296.089844 1.6%
1.63 = Beta