Part 2: You are considering an investment in the stock market and have identified two potential (XYZ and ABC) to purchase. The historical returns for the past five years are shown in the table below.

I have already done the calculations. I need help with answering the questions.

Which stock would you prefer to own? Would everyone make the same choice?

Does it appear that a portfolio consisting of XYZ and ABC would provide good diversification?

How does the portfolio compare with the individual stocks? Would you prefer the portfolio to own either of the stocks alone?

- Calculate the average return and standard deviation of returns for each stock over the past five years. Which stock would you prefer to own? Would everyone make the same choice? - Calculate the correlation coefficient between the two stocks. Does it appear that a portfolio consisting of XYZ and ABC would provide good diversification? - Calculate the annual returns that would have been achieved had you owned a portfolio consisting of 50% in XYZ and 50% in ABC over the past five years. - Calculate the average return and standard deviation of returns for the portfolio. How does the portfolio compare with the individual stocks? Would you prefer the portfolio to own either of the stocks - Create a chart that shows the standard deviation of the portfolio's returns changes as the weight of XYZ changes. Std Deviation of a Two-Stock Portfolio as the weights