Please use excel when explaining the answers

Calculate the correlation coefficient of Stocks X and Stock Y

and

Calculate the standard deviation of the portfolio using Markowitz formula.

Mani Assume the following information concerning a two-stone: portfolio: Stock X Stodc '1' Percent of Portfolio 23% Please calculate it Average annual retum F515; 10% Standard deviation of retum5 109 8.62 Covariance of return5 15.63 Calmla'be the {DITELIHDI'I coefcient of Stocks K and Stuck'l' . Round the answers to [our decimal places. Quunn-Il Aseurne the following information concerning a two-atom portfolio: Stock X Stone; '1" Percent of Portfolio 54% Pleaae calcuLate it Avemge annual retum 9.12% 9.96% Standard deviation of retum5 11.4 13.2 Covariance of returns 29 Calculate the standard deviation 6f the portfolio [Bing Merkowii: funnule. Round the gamers to {1way Lifetime! plate: Write the percentage sign in the 'om'' hand