I need help solving question 18 without using excel.

this is the information for question 13

18. Yortfolio Analysis. Use the data in the scenario analysis from Problem 13 and consider a portfolio with weights of . 60 in stocks and . 40 in bonds. (\$ LO11-3) a. What is the rate of return on the portfolio in each scenario? b. What are the expected rate of return and standard deviation of the portfolio? c. Would you prefer to invest in the portfolio, in stocks only, or in bonds only? Explain the benefit of diversification. 13. Seenario Analysis. Consider the following scenario anabsis: () LOI1.2) A. Is If reatonake to assume that Treasury bonds will provide higher returns in recessions than in booms? b. Cakculate the expected rate of return and sandard deviation for each investment. c. Which imestment woold you prefer