Please use Excel to show work

4. Based on the following data: ) calculate the expected return and the standard deviation of returns for each stock. Stock B Rate of Return Sate of the Economy Probability Stock A Rate of Return Recession 0.2 4% 20% 0,65 Normal Growth 8% 20% 60% Boom 0.15 16% b) Calculate the expected return and the standard deviation on the portfolio, where the portfolio is formed by investing 50% of the funds in Stock A and the rest Stock B Stock B c) Calculate the expected return and the standard deviation on the portfolio, where the portfolio formed by investing 65% of the funds in Stock A and the rest