Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Month Asset A returns Asset B returns Asset C returns 1 -4.0% 11.0% 15.5% 2 1.5% 6.0% 14.5% 3 -1.5% -7.0% -9.5% 4 7.0% 7.5%

Month Asset A returns Asset B returns Asset C returns
1 -4.0% 11.0% 15.5%
2 1.5% 6.0% 14.5%
3 -1.5% -7.0% -9.5%
4 7.0% 7.5% 12.5%
5 2.0% -3.5% 22.5%
6 6.5% -6.5% -11.0%
7 -2.5% 13.5% 19.0%
8 3.5% 9.0% 20.0%
9 4.5% 9.0% -24.0%
10 1.5% 11.5% 13.0%
11 -4.5% -4.5% 17.0%
12 5.0% -2.5% -15.5%

1) In Excel, calculate the standard deviation of each asset using the approach. ( DO NOT Use of the Excel stdev or related function )

2) In Excel, calculate the average return of each asset using the approach. ( DO NOT Use of the Excel avg or related function )

3) In Excel, calculate the covariance between the A and B assets. ( DO NOT Use of the Excel covar or related function)

4) In Excel, calculate the covariance between the A and C assets. ( DO NOT Use of the Excel covar or related function )

5) In Excel, calculate the covariance between the B and C assets. ( DO NOT Use of the Excel covar or related function)

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

Finance And The Behavioral Prospect

Authors: James Ming Chen

1st Edition

331981351X, 978-3319813516

More Books

Students also viewed these Finance questions

Question

Whether they act ethically

Answered: 1 week ago