For this assignment, you are asked to pick 6 stocks and perform the mean-variance analysis discussed in Chapter 8. I expect your answer to be in a single excel sheet similar to the one on Page 209. The due date is Friday midnight, Dec 7 (no exception this time). Here are the guidelines 1. Pick 6 stocks and compute the means, variances and standard deviations. 2. Present the variance-covariance matrix (S) and Mean returns (E) as done in Page 209 3. Construct two portfolios, x and y as follows: Portfolio Weightstockl Weightsok Weightstocks Weightstock4 Weightstocks Weightstock 10% 20% 5% I 5% 30% 20% 12% 13% 20% 5% 20% 30% 4. Calculate the mean portfolio return, variance, and standard deviation for each portfolio. 5. Calculate the covariance between portfolios x and y from the historical data. 6. Using Data Table, graph the relationship between risk and return from the combinations of portfolio x and y Using Solver, construct a portfolio from the six stocks that give the highest return for each unit of risk. (Note: restrict weights to be more than zero and the sum of weights to be equal one) 7