This is part a and b of the qurstion which i have already answered in the excel sheet I have already provided.

c) Calculate the standard deviation of returns for each stock and for the portfolio. \begin{tabular}{|r|r|r|r|r|} \hline \multicolumn{1}{|l|}{ Year } & \multicolumn{1}{|c|}{ Stock A's Returns, r A } & Stock B's Returns, r B & Portfolio AB (Realized rate of return) \\ \hline 2014 & 18.00% & 14.50% & 16.25% \\ \hline 2015 & 33% & 21.80% & 27.40% \\ \hline 2016 & 15% & 30.50% & 22.75% \\ \hline 2017 & 0.50% & 7.60% & 4.05% \\ \hline 2018 & 27% & 26.30% & 26.65% \\ \hline \end{tabular} standard deviation: 20.79% 20.78% 20.13% Assume a third stock, Stock C, is available for inclusion in the portfolio. Stock C produced the following returns during the 2014-2018 period: i. In part b, you should see that the standard deviation of the portfolio decreased only slightly because Stocks A and B were highly positively correlated with each other. The addition of Stock C causes the standard deviation of the portfolio to decline dramatically, even though sC=sA =sB. What does this change indicate about the correlation between Stock C and Stocks A and B? j. Would you prefer to hold a portfolio consisting only of Stocks A and B or a portfolio that also includes Stock C? If others react similarly, how might this fact affect the stocks' prices and rates of return? Stock A and Stock B produced the following returns during the past five years: a. Calculate the average rate of return for each stock during the period 2014-2018. b. Assume that someone held a portfolio consisting of 50 percent Stock A and 50 percent Stock B. What would have been the realized rate of return on the portfolio in each year from 2014 through 2018 ? What would have been the average return on the portfolio during this period