PLEASE SOLVE USING EXCEL AND SHOW YOUR FORMULAS! WILL UPVOTE FOR DETAILED, CLEAR ANSWERS!

10. Hyacinth Macaw invests 55% of her funds in stock I and the rest in stock J. The standard deviation of returns on lis 16%, and on J it is 23%. a) Calculate the variance of portfolio returns, assuming the correlation between the returns is 1 b) Calculate the variance of portfolio returns, assuming the correlation is 0.6 c) Calculate the variance of portfolio returns, assuming the correlation is zero