Description
set of questions of linear combinations and probability. must follow instructions as described and must get all answers right otherwise i will not pass the test and i will have to do the same test again with different set of numbers. please must get all answers right. please let me know if you have any questions.
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
please find attached the solved excel file. the respective answers are highlighted in yellow.Pallvee
Linear Combinations
Qustion 1
Returns on stocks X and Y are listed below:
Period
Stock X
Stock Y
1
2
3
4
3%
1%
-2%
-4%
9%
7%
6%
12%
What is the (population) covariance of returns on the two stocks?
Please round your answer to six decimal places.
Note that the correct answer will be evaluated based on the full-precision resul
Question 2
Returns on stocks X and Y are listed below:
Period
Stock X
Stock Y
Portfolio Returns
1
2
3
4
9%
-4%
5%
3%
6%
1...