https://www.chegg.com/homework-help/questions-and-answers/21-following-table-find-annual-return-data-six-high-tech-companies-years-1997-2007-use-inf-q75485681

q.21 from this link

Need in Excel worksheet with all steps

ALso show me Excel functions

22. Use the data from question 21, and calculate the variance - covariance matrix with the single-index model. You may assume that the variance of the S&P 500 index (market portfolio) is 18%. In other words, the variances of each stock remain the same as in question 21, but the covariances (outside the main diagonal) are adjusted (multiplied) by the market index variance (a sort of a shrinkage factor). 22. Use the data from question 21, and calculate the variance - covariance matrix with the single-index model. You may assume that the variance of the S&P 500 index (market portfolio) is 18%. In other words, the variances of each stock remain the same as in question 21, but the covariances (outside the main diagonal) are adjusted (multiplied) by the market index variance (a sort of a shrinkage factor)