Question: please fill in red question marks with excel formulas, please keep cell number/letter as is. WN 4 5 B C D 1 04: The Return

please fill in red question marks with excel formulas, please keep cell number/letter as is.

please fill in red question marks with excel formulas, please keep cell

WN 4 5 B C D 1 04: The Return and Risk for Portfolios 2 Date Stcok A Stock B 3 1/1/2015 -3.10% 14.24% 4 2/1/2015 5.49% 7.23% 3/1/2015 -1.74% -2.12% 6 4/1/2015 0.85% 13.35% 7 5/1/2015 1.05% 1.77% 8 6/1/2015 -2.10% 1.13% 9 7/1/2015 1.97% 23.51% 10 8/1/2015 -6.26% -4.34% 11 9/1/2015 -2.64% -0.19% 12 10/1/2015 8.30% 22.27% 13 11/1/2015 0.05% 6.22% 14 12/1/2015 -1.75% 1.67% 15 16 mean return ? ? 17 variance ? ? 18 std ? ? 19 correlation: ? 20 Weight of s 45% ? 21 22 The expected return of the portfolio is: 23 24 average return oft

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!