Data Case Essay

2111 Words9 Pages
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 |