You are considering investing in three different stocks or creating three distinct two-stock portfolios for your company described in Part 1 of this project. You are a conservative investor. You have obtained historical returns for the three securities for the years 2015 through 2021. The data are given in the following table. In any of the possible two-stock portfolios, the weight of each stock in the portfolio will be 50%. The three possible portfolio combinations are AB, AC, and BC. Create a spreadsheet similar to the table above to fill out the following information: a. Calculate the average return for each individual stock. . Calculate the standard deviation for each individual stock. c. Calculate the average returns for portfolios AB, AC, and BC. Calculate the standard deviations for portfolios AB, AC, and BC. Respond to the following two questions below the table you create: 1. Would you recommend that your company invest in the single stock A or the portfolio consisting of stocks A and B? Explain your answer from a riskreturn viewpoint. 2. Would you recommend that your company invest in the single stock B or the portfolio consisting of stocks B and C? Explain your answer from a riskreturn viewpoint.

YEAR	Stock A	Stock B	Stock C
2015	10%	10%	12%
2016	13	11	14
2017	15	8	10
2018	14	12	11
2019	16	10	9
2020	14	15	9
2021	12	15	10