Use the information to

calculate Variance and Standard Deviation ( apply n-1 as the denominator ([Note] Do not use excel function for this) for RIO & BHP and Portfolio 1. Monthly Returns, Variance and Standard Deviation.

-Calculations Calculate Covariance between these two stocks over the sample period

Calculate Correlation between these two stocks over the sample period using the formula taught in class using monthly (not annual) figures.

Calculate the Optimal Weights of these two stocks using the formula taught in class, and subsequently the Minimum Variance Portfolio 1s (MVP 1) Return and Risk (standard deviation) based on the optimal weights using monthly (not annual) figures.

Calculate the Coefficient of Variations of RIO & BHP, Portfolio 1 and MVP 1 using monthly (not annual) figures.

If you can, please show your working and formula, many thanks!

BHP Year Month Portrolio Return Return jual-Weighted Retu 2010 1 -9.929 -9.418| -9.679 2010 2 2 7. 10% 5. 719 6. 419 2010 3 14. 91% 9. 53% 12. 2292 2010 4 1-14.06% -8.36% -11.219 2010 5 -9. 36% -10.92% -10. 149 2010 6 -5. 42% -4.40% -4.919 2010 7 19.08% 16.52% 17. 804 2010 8 -2. 87% -7.93% -5. 409 2010 9 17. 43% 14. 77% 16. 109 2010 10 10. 88% 9. 60% 10. 249 2010 11 -1.52% -0.21% -0. 8698 2010 12 11. 749 12. 779 12. 2592 BHP Year Month Portrolio Return Return jual-Weighted Retu 2010 1 -9.929 -9.418| -9.679 2010 2 2 7. 10% 5. 719 6. 419 2010 3 14. 91% 9. 53% 12. 2292 2010 4 1-14.06% -8.36% -11.219 2010 5 -9. 36% -10.92% -10. 149 2010 6 -5. 42% -4.40% -4.919 2010 7 19.08% 16.52% 17. 804 2010 8 -2. 87% -7.93% -5. 409 2010 9 17. 43% 14. 77% 16. 109 2010 10 10. 88% 9. 60% 10. 249 2010 11 -1.52% -0.21% -0. 8698 2010 12 11. 749 12. 779 12. 2592