Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Add a column in your spreadsheet with the monthly return to an equally weighted portfolio of 12 stocks. Compute the mean and standard deviation of
Add a column in your spreadsheet with the monthly return to an equally weighted portfolio of 12 stocks. Compute the mean and standard deviation of the monthly returns of this p
Date | Adjusted Closing Prices for the 12 stocks | |||||||||||
AXP | AAPL | BA | GS | IBM | JNJ | MCD | MSFT | VZ | V | WMT | DIS | |
1/1/2012 | 43.49178 | 13.9979 | 60.69836 | 96.05989 | 136.3321 | 65.91 | 75.42535 | 23.99138 | 24.31175 | 23.499 | 48.91045 | 34.82887 |
2/1/2012 | 46.04844 | 16.63385 | 61.3284 | 99.22254 | 139.2555 | 65.08 | 75.60049 | 25.78688 | 24.92225 | 27.17189 | 47.09305 | 37.59549 |
3/1/2012 | 50.37555 | 18.38512 | 61.21199 | 107.5002 | 148.2682 | 65.96 | 75.22663 | 26.38189 | 25.00073 | 27.60519 | 48.78292 | 39.19815 |
4/1/2012 | 52.42157 | 17.90767 | 63.21205 | 99.53088 | 147.1526 | 65.1 | 74.7282 | 26.18562 | 26.40672 | 28.77022 | 47.27185 | 38.59827 |
5/1/2012 | 48.77631 | 17.71602 | 57.29417 | 82.71909 | 137.0761 | 62.43 | 68.50913 | 23.87128 | 27.59005 | 26.95015 | 52.81673 | 40.92616 |
6/1/2012 | 50.85561 | 17.90829 | 61.51334 | 83.25344 | 139.5628 | 67.56 | 68.4195 | 25.18033 | 29.44528 | 28.97696 | 56.3259 | 43.42417 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started