Question: The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index (i.e., the market). Compute the average monthly return for
- The Excel file Stock Data contains monthly data for several stocks and the S&P 500 Index (i.e., the market).
- Compute the average monthly return for PFE.
- Compute the annualized return for PFE.
- Compute the annual risk (i.e., variance and standard deviation) for PFE.
| PFE | S&P 500 |
| 4.31% | 2.40% |
| 7.61% | 5.20% |
| -0.56% | 4.00% |
| -5.94% | -0.50% |
| 14.35% | 9.00% |
| 6.54% | 1.90% |
| -0.90% | -0.40% |
| -1.45% | -2.30% |
| 10.47% | 2.10% |
| -6.24% | 2.40% |
| -1.44% | -6.70% |
| -13.12% | 1.30% |
| 2.76% | 2.60% |
| -6.39% | -2.50% |
| 17.24% | 9.80% |
| -2.66% | -0.70% |
| 18.13% | -0.30% |
| -5.49% | -9.00% |
| -0.53% | -4.90% |
| 3.01% | -0.40% |
| 11.90% | 6.40% |
| 0.00% | 2.70% |
| 11.30% | 4.40% |
| 17.59% | 7.20% |
| 1.90% | 2.40% |
| 1.87% | 0.30% |
| 8.65% | 4.30% |
| -5.73% | -4.60% |
| 11.49% | 4.70% |
| 6.43% | 2.40% |
| -0.57% | -1.60% |
| 9.98% | 1.30% |
| -6.88% | -4.00% |
| 26.55% | 11.40% |
| -13.09% | -1.90% |
| 2.57% | 1.30% |
| -6.71% | -2.00% |
| 2.88% | 2.90% |
| 4.91% | 0.50% |
| -2.18% | -1.50% |
| 7.36% | 4.00% |
| -0.97% | -2.00% |
| -3.24% | 1.20% |
| 1.17% | 0.40% |
| 3.81% | 3.40% |
| -7.20% | 1.30% |
| -8.97% | 0.70% |
| -10.96% | 1.40% |
| -0.56% | 4.00% |
| -5.94% | -0.50% |
| 14.35% | 9.00% |
| -13.12% | 1.30% |
| 2.76% | 2.60% |
| -6.39% | -2.50% |
| 1.90% | 2.40% |
| 1.87% | 0.30% |
| 8.65% | 4.30% |
| -6.71% | -2.00% |
| 3.81% | 3.40% |
| 2.88% | 2.90% |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
Study Help