Spreadsheet Exercise: Chapter 8YearStock AStock BStock C201210%10%12%201313%11%14%201415%8%10%201514%12%11%201616%10%9%201714%15%9%201812%15%10%To DoCreate a spreadsheet similar to Tables 8.6 and 8.7 to answer the following:a.Calculate the average return for each individual stock.b.Calculate the standard deviation for each individual stock.c.Calculate the average returns for portfolios AB, AC, and BC.d.Calculate the standard deviations for portfolios AB, AC, and BC.e.f.Calculate the standard deviation for each individual stock.Jane is considering investing in three different stocks or creating three distinca rather conservative investor. She is able to obtain historical returns for the t2018. The data are given in the following table.In any of the possible two-stock portfolios, the weight of each stock in the poportfolio combinations are AB, AC, and BC.Would you recommend that Jane invest in the single stock A or the portfoyour answer from a risk–return viewpoint.Would you recommend that Jane invest in the single stock B or the portfoyour answer from a risk–return viewpoint.Solutiona.Calculate the average return for each individual stock.Stock AStock BStock CExpected return94.00%81.00%75.00%b.Calculate the standard deviation for each individual stock.Jane is considering investing in three different stocks or creating three distinca rather conservative investor. She is able to obtain historical returns for the t2018. The data are given in the following table.In any of the possible two-stock portfolios, the weight of each stock in the poportfolio combinations are AB, AC, and BC.Would you recommend that Jane invest in the single stock A or the portfoyour answer from a risk–return viewpoint.Would you recommend that Jane invest in the single stock B or the portfoyour answer from a risk–return viewpoint.

Stock AStock BStock C