Please help with the bottom portion using excel. What am I missing or doing wrong? Thank you.

Week 5 Homework X Q Cell Styles L! Format Clipboard Font Alignment Number Styles Cells Editing Ideas answers to two decimal places. Stock A: 11.74 % D20 X =C20^2 Stock B: 11.74 % D E F H | K L M b. Assume that someone held a portfolio consisting of 50% of Stock A and 50% of Stock B. What would the realized rate of return on the portfolio have been each year? Round your answers to two decimal places. Negative values should be indicated by a minus sign. B 1 Year Stock A Stock B 2 2014) -19.30% - 15.90% 3 2015 37.50% 26.10% 4 2016 19.25% 36.20% 5 2017 -4.25% -11.70% 6 2018 25.50% 24.00% 7 Average 11.74% 8 Year Portfolio 2014 -17.60 0% 2015 11.74% 31.80 % 2016 27.73 % 9 2017 -7.98 % 2018 24.75 % What would the average return on the portfolio have been during this period? Round your answer to two decimal places. 11.74 % C. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places. Stock A Stock B Portfolio Standard Deviation 20.63 X 21.30 % % X -.67 d. Calculate the coefficient of variation for each stock and for the portfolio. Round your answers to two decimal places. Realized rate 10 Year Stock A Stock B of returns 11 2014 -19.30% - 15.90% -17.60% 12 2015 37.50% 26.10% 31.80% 13 2016 19.25% 36.20% 27.73% 14 2017 -4.25% - 11.70% -7.98% 15 2018 25.50% 24.00% 24.75% 16 Average return on portfolio 11.74% 17 18 Squared Deviation 19 Year Stock A Devation (SD) 20 2014 -19.30% -31.04% 9.63% 21 2015 37.50% 25.76% 6.64% 22 2016 19.25% 7.51% 0.56% 23 2017 -4.25% -15.99% 2.56% 24 2018 25.50% 13.76% 1.89% Average rate of 25 return 11.74% 26 Variance 4.26% 27 Standard Deviation 20.63% 28 29 Standard Deviation Portfolio for Stock A & B 30 -0.67% Stock A Stock B Portfolio CV X Squared Deviation Year Stock B Devation (SD) 2014 - 15.90% -27.64% 7.64% 2015 26.10% 14.36% 2.06% 2016 36.20% 24.46% 5.98% 2017 - 11.70% -23.44% 5.49% 2018 24.00% 12.26% 1.50% Average rate of return 11.74% Variance 4.54% Standard Deviation 21.30% e. Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio? Portfolio Hide Feedback Partially Correct Check My Work 31