Solve in Excel

Please write legibly. For each of the problems, show all your work and clearly explain how you solve the problem. You should follow these rules to get credit for your work. Problem 1: Miss Maple is considering two securities, A and B, with the relevant information given below, State of the economy Probability Return on Security A (%) Return on Security B (%) Bear 0.4 3.00% 6.50% Bull 0.6 15.00% 6.50% a. Calculate the expected return and standard deviation of each of the two securities. b. Suppose Miss Maple invested $2,500 in security A and $3,500 in security B. Calculate the ex- pected return and standard deviation of the portfolio