must be answered on excel

PROBLEM 4: Part-A Based on the following data; State of the Economy Probability Stock A Rate of Return Stock B Rate of Return Recession 0.2 5% -20% Low Growth 0.3 10% 10% Normal Growth 0.5 16% 24 Calculate the expected return and the standard deviation on the portfolio (Portfolio 1), where the portfolio is formed by investing 50% of the funds in Stock A and the rest in Stock B Part-B: Given the following historical data: Year Rate of return for Stock X 2020 25% 2019 6% 2018 14% Calculate the average return and the standard deviation of returns for Stock X