Using only excel functions

Using excel functions

Assume a third stock, Stock C, is available for inclusion in the portfolio. Stock C produced the following returns during the 2014-2018 period: g. Assume that the portfolio now consists of 33.33 percent Stock A, 33.33 percent Stock B, and 33.33 percent Stock C. How does this composition affect the portfolio return, standard deviation, and coefficient of variation versus when 50 percent was invested in A and in B? h. Make some other changes in the portfolio, making sure that the percentages sum to 100 percent. For example, enter 25 percent for Stock A, 25 percent for Stock B, and 50 percent for Stock C. Notice that ^p remains constant and that Sp changes. Why do these results occur? Stock A and Stock B produced the following returns during the past five years: e. Assume a third stock, Stock C, is available for inclusion in the portfolio. Stock C produced the following returns during the 2014-2018 period: g. Assume that the portfolio now consists of 33.33 percent Stock A, 33.33 percent Stock B, and 33.33 percent Stock C. How does this composition affect the portfolio return, standard deviation, and coefficient of variation versus when 50 percent was invested in A and in B ? h. Make some other changes in the portfolio, making sure that the percentages sum to 100 percent. For example, enter 25 percent for Stock A, 25 percent for Stock B, and 50 percent for Stock C. Notice that r^P remains constant and that sn changes. Why do these results occur