Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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