Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Monetary Policy And Public Finance

Authors: G. C. Hockley

1st Edition

1138704792, 978-1138704794

More Books

Students also viewed these Finance questions