Question: NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA) Suppose we have the following returns for the market and a stock: Year Market return Stock return 1 18%
NEED EXCEL SOLUTION PLEASE: (EXCEL FORMULA)
| Suppose we have the following returns for the market and a stock: |
| Year | Market return | Stock return |
| 1 | 18% | 7% |
| 2 | 27% | 25% |
| 3 | 5% | 21% |
| 4 | 13% | 4% |
| 5 | -17% | -16% |
| 6 | 6% | 19% |
| 7 | -21% | -38% |
| 8 | 34% | 29% |
| 9 | 19% | 15% |
| 10 | 11% | 16% |
| What is the covariance and correlation of the returns between this stock and the market? |
| Covariance: | Use Covar Function |
| Correlation: | Use Correl Function |
| Beta: | Use Slope Function |
Please provide solutions for the above: Covariance, Correlation, and Beta using the listed functions (EXCEL Solution)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
