Please show how to answer the question using excel and showing the formulas

1 Refer to the following table 2 Construct an equal-weighted (50/50) portfolio of Investments A and B. What is the expected rate of 3 return and standard deviation of the portfolio? Explain your results. 5 State 6 Very poor 7 Poor 8 Average 9 Good 10 Very good Probability AB 0.1-10% 0.2 0.4 10% 0.2 20% 0.1 30% -25% -17.5% 590-2590 12.5% 27.5% 42.5% 090 15% 35% 55% 12