In: Statistics and Probability
Returns on stocks X and Y are listed below:
| Period | 1 | 2 | 3 | 4 | 5 | 6 | 7 |
|---|---|---|---|---|---|---|---|
| Stock X | 5% | 6% | -2% | -4% | 6% | 10% | 7% |
| Stock Y | 1% | -3% | 6% | 3% | 12% | 7% | -5% |
Consider a portfolio of 40% stock X and 60% stock Y.
What is the (population) variance of portfolio returns?
Please round your answer to six decimal places.
Note that the correct answer will be evaluated based on the full-precision result you would obtain using Excel.
Answer:-
Given That:-
Returns on stocks X and Y are listed below:
Consider a portfolio of 40% stock X and 60% stock Y.
The data given in the question statement is as below. Computing additional columns:
| Period |
Stock X x |
Stock Y y |
![]() |
![]() |
xy | ![]() |
![]() |
| 1 | 0.05 | 0.01 | 0.0001 | 0.0004 | 0.0005 | 0.0025 | 0.0001 |
| 2 | 0.06 | -0.03 | 0.0004 | 0.0036 | -0.0018 | 0.0036 | 0.0009 |
| 3 | -0.02 | 0.06 | 0.0036 | 0.0009 | -0.0012 | 0.0004 | 0.0036 |
| 4 | -0.04 | 0.03 | 0.0064 | 0.0000 | -0.0012 | 0.0016 | 0.0009 |
| 5 | 0.06 | 0.12 | 0.0004 | 0.0081 | 0.0072 | 0.0036 | 0.0144 |
| 6 | 0.10 | 0.07 | 0.0036 | 0.0016 | 0.007 | 0.0100 | 0.0049 |
| 7 | 0.07 | -0.05 | 0.0009 | 0.0064 | -0.0035 | 0.0049 | 0.0025 |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |

= 0.04

= 0.03

= 0.0022

= 0.0030
Correlation Coefficient:


r = -0.0778
Weight of stock X = Wx = 0.40
Weight of stock Y = Wy = 0.60
What is the (population) variance of portfolio returns?
Variance of the portfolio:



Variance of the portfolio: 
Plz like it....