preview

Data Case Essay

Satisfactory Essays

Group Project Berk DeMarzo Data Case chapter 10 1. Collect price information for each stock from Yahoo! Finance Professor has provided it for us. The specific data of question 2-4 is in the appendix. We only include the functions and simple answers below every question. 2. Return=(P2-P1)/P1 3. mean monthly returns, standard deviations for the monthly returns and annual statistics Ticker | AAPL | ADM | BA | C | CAT | DE | HSY | MOT | PG | SIRI | WMT | YHOO | Mean | 8.39% | 3.70% | 2.68% | -0.26% | 2.87% | 3.40% | 0.43% | 0.48% | 1.25% | 3.34% | 0.69% | 2.22% | SD | 0.1584 | 0.1050 | 0.0697 | 0.0709 | 0.0742 | 0.0867 | 0.0491 | 0.0934 | 0.0455 | 0.1963 | 0.0477 | 0.1299 | Annual Mean | 1.0068 | 0.4444 …show more content…

3.60 | Dec-04 | 19.41 | 8.46 | -2.28 | 1.81 | -8.22 | -6.67 | 5.30 | -8.50 | -2.92 | -13.12 | -0.78 | -6.56 | -1.17 | Jan-05 | 16.67 | -0.09 | 9.15 | -1.85 | 6.66 | 2.40 | 8.10 | -0.47 | -0.27 | -15.86 | -1.51 | -8.35 | 1.22 | Feb-05 | -7.11 | 2.01 | 6.35 | -5.82 | -3.79 | -5.16 | -4.03 | -4.19 | -0.17 | 0.90 | -2.62 | 5.05 | -1.55 | Mar-05 | -13.46 | -26.80 | 1.82 | 5.49 | -3.27 | -6.84 | 5.69 | 2.47 | 2.70 | -15.30 | -5.93 | 1.77 | -4.31 | Apr-05 | 10.26 | 10.81 | 7.80 | 0.30 | 6.89 | 5.77 | 0.81 | 13.29 | 1.85 | 26.26 | 0.50 | 7.83 | 7.70 | May-05 | -7.42 | 7.71 | 3.28 | -1.85 | 1.28 | -0.53 | -3.28 | 5.35 | -4.36 | 7.82 | 2.05 | -6.85 | 0.27 | Jun-05 | 15.87 | 7.31 | 0.02 | -4.98 | 13.64 | 12.29 | 2.84 | 15.98 | 6.01 | 5.25 | 2.39 | -3.78 | 6.07 | Jul-05 | 9.94 | -1.49 | 1.91 | 0.62 | 2.93 | -11.09 | -7.10 | 3.28 | -0.26 | 0.88 | -8.62 | -0.06 | -0.76 | Aug-05 | 14.33 | 9.56 | 1.39 | 4.01 | 5.88 | -5.92 | -4.72 | 0.87 | 7.16 | -4.94 | -2.53 | 1.56 | 2.22 | Sep-05 | 7.42 | -1.17 | -4.87 | 0.56 | -10.09 | -0.85 | 0.94 | 0.57 | -5.36 | -4.74 | 7.96 | 9.25 | -0.03 | Oct-05 | 17.76 | -2.93 | 5.88 | 7.09 | 9.87 | 14.30 | -4.16 | 8.74 | 2.14 | 14.77 | 2.65 | 8.82 | 7.08 | Nov-05 | 6.00 | 4.59 | 3.02 | -0.05 | -0.02 | -1.25 | 1.89 | -6.07 | 1.21 | -6.29 | -3.34 | -2.61 | -0.24 | Dec-05 | 5.04 | 27.73 | -2.76 | -4.01 | 18.01 | 5.37 | -7.33 | 0.51 | 2.82 | -15.37 | -1.46 | -12.25 | 1.36 | Jan-06 | -9.30 | 1.05 | 6.86 | 0.62 | 7.63 | 6.30 | 0.37 |

Get Access