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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!