Mean-Variance Analysis Instructions: 1. Select four publicly traded companies with at least 5 years of trading history. 2. From Yahoo Finance, download each stocks Adjusted Close prices for at least 5 years. Use the latest 5 years. Download monthly prices. Arrange in one table in Excel. 3. Calculate monthly returns. 4. Perform the necessary calculations and rank the stocks from a risk-averse investors point of view. 5. Calculate correlations and covariances (matrices). 6. Calculate average returns and standard deviations of the following portfolios based on your four stocks: a) Portfolio made up of all four stocks equally weighted. b) Portfolio that invests 30%, 20%, 10% and 40% in your stocks respectively. c) Portfolio with minimum variance