Hi, I need help on C and D. Please show it in excel format. Thank you.

Stocks A and B have the following historical returns: a. Calculate the average rate of return for each stock during the period 2014 through 2018 . Round your answers to two decimal places. Stock A: % Stock B: % 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 Round your answers to two decimal places. Negative values should be indicated by a minus sign. What would the average return on the portfolio have been during this period? Round your answer to two decimal places. c. Calculate the standard deviation of returns for each stock and for the portfolio. Round your answers to two decimal places. d. Calculate the coefficient of variation for each stock and for the portfolio. Round your answers to two decimal places. e. Assuming you are a risk-averse investor, would you prefer to hold Stock A, Stock B, or the portfolio