The following is market data as of the close of each year for the shares of General Motors (GM) and Microsoft (MSFT). GM MSFT Date Closing Price Dividend Closing Dividend USS USS Price USS Dec 29, 1989 42.3 1.2 Dec 31 1990 37.4 3.0 2.1 Dec 31 1991 30.5 1.6 4.6 Dec 31 1992 33.7 1.4 5.3 - Dec 31 1993 55.7 0.8 5.0 - Dec 30 1994 42.9 0.8 7.6 Dec 29 1995 54.0 1.1 11.0 - Dec 31 1996 57.4 1.6 20.7 Dec 31 1997 66.3 5.6 32.3 Dec 31 1998 73.6 2.0 69.3 Dec 31 1999 86.8 14.2 116.8 - According to the data shown, the following is requested: a) Complete following table: Metrics GM MSFT Average return Variance of returns Standar Deviation of returns Returns Covariance Returns Correlation Help : If you notice, there are no scenario probabilities here. Therefore, conventional statistical formulas should be used to use historical data to fill in the blanks.b) If you wish to build a portfolio based on these two stocks, determine the expected return and standard deviation of the portfolio for the following combinations of investment percentages in both stocks (WMSFT ; WGM): b. 1 50% invested in General Motors (GM) and 50% in Microsoft (MSFT). b.2 30% invested in General Motors (GM) and 70% in Microsoft (MSFT). b.3 63% invested in General Motors (GM) and 37% in Microsoft (MSFT). What can you conclude from your results? c) Apply the following formula to determine the minimum variance portfolio when obtaining the percentage of investment in General Motors (GM) stock. Var (TMSFT ) - Cov(GM , 'MSFT ) WGM Var(ToM ) + Var ("MSFT ) - 2Cov(GM , I'MSET Help: The percentage invested in MSFT is obtained by difference. (WMSFT = 1 - WGM). What can you conclude from your results when compared to those obtained in section b