The following are monthly percentage price changes for four market indexes. Compute the following. a. Average...

 

Transcribed Image Text:

The following are monthly percentage price changes for four market indexes. Compute the following. a. Average monthly rate of return for each index. Round your answers to five decimal places. DJIA: S&P 500: Russell 2000: Nikkei: b. Standard deviation for each index. Do not round intermediate calculations. Round your answers to four decimal places. DJIA: S&P 500: Russell 2000: Since S&P 500 and Russell 2000 have a strong -Select correlation, meaningful reduction in risk -Select- Since S&P 500 and Nikkei have a strong -Select-correlation, meaningful reduction in risk -Select- Month ✓ 1 2 3 4 5 6 if they are combined. DJIA 0.02 0.08 -0.03 0.01 0.05 -0.07 if they are combined. S&P 500 Russell 2000 0.03 0.07 -0.01 0.04 Nikkei: c. Covariance between the rates of return for the following indexes. Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers to six decimal places. Covariance (DJIA, S&P 500): Covariance (S&P 500, Russell 2000): Covariance (S&P 500, Nikkei): Covariance (Russell 2000, Nikkei): d. The correlation coefficients for the same four combinations. Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers to four decimal places. Correlation (DJIA, S&P 500): Correlation (S&P 500, Russell 2000): Correlation (S&P 500, Nikkei): Correlation (Russell 2000, Nikkei): e. Using the unrounded 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. Do not round intermediate calculations. Round your answers to five decimal places. Expected return (S&P 500 and Russell 2000): Standard deviation (S&P 500 and Russell 2000): Expected return (S&P 500 and Nikkei): Standard deviation (S&P 500 and Nikkei): 0.04 -0.02 0.03 0.10 -0.04 0.04 0.11 -0.08 Nikkei 0.03 -0.03 0.05 0.03 0.03 0.05 The following are monthly percentage price changes for four market indexes. Compute the following. a. Average monthly rate of return for each index. Round your answers to five decimal places. DJIA: S&P 500: Russell 2000: Nikkei: b. Standard deviation for each index. Do not round intermediate calculations. Round your answers to four decimal places. DJIA: S&P 500: Russell 2000: Since S&P 500 and Russell 2000 have a strong -Select correlation, meaningful reduction in risk -Select- Since S&P 500 and Nikkei have a strong -Select-correlation, meaningful reduction in risk -Select- Month ✓ 1 2 3 4 5 6 if they are combined. DJIA 0.02 0.08 -0.03 0.01 0.05 -0.07 if they are combined. S&P 500 Russell 2000 0.03 0.07 -0.01 0.04 Nikkei: c. Covariance between the rates of return for the following indexes. Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers to six decimal places. Covariance (DJIA, S&P 500): Covariance (S&P 500, Russell 2000): Covariance (S&P 500, Nikkei): Covariance (Russell 2000, Nikkei): d. The correlation coefficients for the same four combinations. Use a minus sign to enter negative values, if any. Do not round intermediate calculations. Round your answers to four decimal places. Correlation (DJIA, S&P 500): Correlation (S&P 500, Russell 2000): Correlation (S&P 500, Nikkei): Correlation (Russell 2000, Nikkei): e. Using the unrounded 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. Do not round intermediate calculations. Round your answers to five decimal places. Expected return (S&P 500 and Russell 2000): Standard deviation (S&P 500 and Russell 2000): Expected return (S&P 500 and Nikkei): Standard deviation (S&P 500 and Nikkei): 0.04 -0.02 0.03 0.10 -0.04 0.04 0.11 -0.08 Nikkei 0.03 -0.03 0.05 0.03 0.03 0.05

Answer rating: 100% (QA)

each index See below bThis is calculated using the STDEV function in E... View the full answer