Please Show work in excel

1. Compute the following: 1. Average monthly rate of return, , for each stock 2. Standard deviation of returns for each stock 3. Covariance between the rates of return 4. The correlation coefficient between the rates of return 2. What level of correlation would you have expected before performing your calculations? 3. How did your expectations compare with the computed correlation? 4. Would these two stocks be good choices for diversification? Why or why not