5. You can also use Excel for solve this question (15 POINTS, 3 POINTS EACH)

The following are monthly percentage price changes for four market indexes:

Month	DJIA	S&P 500	Russell 2000	Nikkei
1	0.03	0.02	0.04	0.04
2	0.07	0.06	0.10	0.02
3	0.02	0.01	0.04	0.07
4	0.08	0.13	0.13	0.12
5	0.05	0.04	0.11	0.02
6	0.08	0.04	0.09	0.08

Compute the following:

1. Average monthly rate of return for each index
2. Standard deviation for each index
3. Covariance between the rates of return for the following indexes:
   1. DJIAS&P 500
   2. S&P 500Nikkei
   3. S&P 500Russel 200
   4. Russell 2000Nikkei
4. The correlation coefficients for the same four combinations
5. Using the answers from parts (a), (b), and (d), calculate the expected return and standard deviation of a portfolio consisting of equal parts of (1) the S&P and the Russell 2000 and (2) the S&P and the Nikkei. Discuss the two portfolios.