I know the answer is 11.10. However, I don't know how to calculate it on excel. I need ALL the steps included in the formula, please. I will give thumps up

G 0.1891 0.1661 1.0000 B D E F 7 Here are the expected returns and standard deviations for stocks A, B, and C: 8 Stock 9 7.0% 33.11% 10 B 10.0% 53.85% 11 20.0% 89.44% 12 13 Here is the correlation matrix: 14 A B 15 1.0000 0.1571 16 B 0.1571 1.0000 17 0.1891 0.1661 18 19 a. Suppose a portfolio has 30 percent invested in A, 50 percent in B, and 20 percent in C. 20 What are the expected return and standard deviation of the portfolio? 21 30% 50% 20% 25 26 'p 27 28 29 Hint: for the portoflio standard deviation, start by creating a table like the one in Section 30 25.1 for the N-asset case. In fact, begin by creating a table with the products of the 31 weights and standard deviations for each pair of stocks. If you are careful about how you 32 construct the formulas, you can copy them. Then take the results from this intermediate 22 WA 23 wg 24 Wc