Data Case

2107 words 9 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…
| 7.26 | -3.84 | -0.78 | 4.55 | 0.62 | 1.59 | Mar-06 | 12.23 | 7.99 | 7.08 | 6.85 | 5.80 | 11.05 | 2.13 | -6.82 | 1.58 | -7.69 | -4.69 | 1.61 | 3.09 | Apr-06 | -15.09 | 14.65 | 0.10 | -1.29 | -3.68 | -2.49 | 7.16 | -1.23 | -6.81 | -3.85 | 7.98 | -3.63 | -0.68 | May-06 | -4.18 | -0.69 | -1.62 | -2.13 | 2.10 | -1.98 | -3.22 | -4.22 | 2.49 | 5.56 | -0.57 | 4.46 | -0.33 | Jun-06 | 18.67 | 6.57 | -5.48 | 0.12 | -4.44 | -13.09 | -0.18 | 12.97 | 1.65 | -11.58 | -7.63 | -17.76 | -1.68 | Jul-06 | -0.16 | -6.19 | -2.88 | 3.20 | -6.37 | 7.63 | -1.35 | 2.71 | 10.14 | -2.86 | 0.88 | 6.23 | 0.92 | Aug-06 | 13.46 | -7.98 | 5.28 | 0.63 | -0.83 | 7.94 | -0.94 | 7.16 | 0.14 | -3.92 | 10.29 | -12.31 | 1.58 | Sep-06 | 5.33 | 1.61 | 1.28 | 0.99 | -7.33 | 1.47 | -1.03 | -7.76 | 2.78 | -2.30 | -0.09 | 4.19 | -0.07 | Oct-06 | 13.05 | -8.57 | 11.25 | -0.16 | 2.18 | 12.75 | 0.64 | -3.85 | -0.95 | 11.23 | -6.46 | 2.54 | 2.80 | Nov-06 | -7.44 | -8.95 | 0.35 | 12.31 | -1.14 | -0.51 | -5.99 | -7.06 | 2.37 | -16.90 | 0.55 | -5.44 | -3.15 | Dec-06 | 1.05 | 0.13 | 0.80 | -1.01 | 5.00 | 5.48 | 2.48 | -3.44 | 1.41 | 4.24 | 3.26 | 10.85 | 2.52 | Jan-07 | -1.31 | 7.68 | -2.19 | -7.72 | 0.56 | 7.98 | 4.18 | -6.71 | -2.13 | -1.08 | 1.30 | 9.01 | 0.80 | Feb-07 | 9.81 | 6.86 | 1.90 | 1.91 | 4.03 | 0.74 | 3.31 | -4.33 | -0.51 | -12.33 | -2.36 | 1.39 | 0.87 | Mar-07 | 7.42 | 5.45 | 4.61 | 4.44 | 8.82 | 0.70 | 0.56 | -1.94 | 2.51 | -7.50 | 2.08 | -10.39 | 1.40 | Apr-07 | 21.43 | -9.17 |

Related

  • Determining Databases and Data Communications
    1377 words | 6 pages
  • QNT561 Sampling and Data Collection Pla
    962 words | 4 pages
  • Data Encryption
    3747 words | 15 pages
  • Data Analysis Assignment
    2401 words | 10 pages
  • 7000 Data Management
    1080 words | 5 pages
  • Data Basing 101
    1942 words | 8 pages
  • Demographics and Data Collection Methodology
    1227 words | 5 pages
  • Riordan Proposal Network and Data Upgrade
    4606 words | 19 pages
  • Northern Aero Data (Clv) Case Analysis
    942 words | 4 pages
  • Sampling and Data Collection in Research Paper
    1134 words | 5 pages