It would be easier to set up the problem in Excel by referring to the value of correlation as a variable in a cell.

Hyacinth Macaw invests $74\%$ of her funds in stock I and the balance in stock J$.$ The standard deviation of returns on I is $13\%,$ and on J it is $27\%.$

Note: Use decimals, not percents, in your calculations.

Calculate the variance and standard deviation of portfolio returns, assuming the correlation between the returns is $1.$

Calculate the variance and standard deviation of portfolio returns, assuming the correlation is $0\mathrm{.}7.$

Calculate the variance and standard deviation of portfolio returns, assuming the correlation is $0.$

Note: For all requirements, do not round intermediate calculations. Round your answers to $4$ decimal places.