Please download the weekly price data of eight stocks contained in the Don Jones Industrial Average index from January 4th, 2015 to December 30th, 2021 from Yahoo Finance. Assume a risk-free rate of 50 basis points (annual rate). Use the "adjusted close price when calculating returns. (a) For all eight stocks, compute the mean, standard deviation and Sharpe ratio (both weekly and annual). (b) Compute the correlation matrix and variance-covariance matrix of the eight stocks. (c) Choose two stocks from the eight stocks. Draw the investment opportunity set with the two stocks. (d) Draw the minimum variance frontier by creating portfolios of the eight stocks with short sale constraints. Here you should use Excel solver to come up with at least 8 portfolios including the global minimum risk portfolio. (Hint: add constraints that all weights are greater than zero or turn on the making unconstrained variables non-negative option in Excel solver. ] Please download the weekly price data of eight stocks contained in the Don Jones Industrial Average index from January 4th, 2015 to December 30th, 2021 from Yahoo Finance. Assume a risk-free rate of 50 basis points (annual rate). Use the "adjusted close price when calculating returns. (a) For all eight stocks, compute the mean, standard deviation and Sharpe ratio (both weekly and annual). (b) Compute the correlation matrix and variance-covariance matrix of the eight stocks. (c) Choose two stocks from the eight stocks. Draw the investment opportunity set with the two stocks. (d) Draw the minimum variance frontier by creating portfolios of the eight stocks with short sale constraints. Here you should use Excel solver to come up with at least 8 portfolios including the global minimum risk portfolio. (Hint: add constraints that all weights are greater than zero or turn on the making unconstrained variables non-negative option in Excel solver. ]