Need help with the following problem please: Please provide it on excel form...thks

3. The following are the monthly rates of return for Madison Cookies and for Sophie Electric

during a six-month period.

Month Madison CookiesSophie Electric

1 0.040.07

20.06 0.02

3 0.07 0.10

4 0.12 0.15

50.02 0.06

60.05 0.02

Compute the following.

a. Average monthly rate of return Ri for each stock

b. Standard deviation of returns for each stock

c. Covariance between the rates of return

d. The correlation coefficient between the rates of return

What level of correlation did you expect? How did your expectations compare with the

computed correlation? Would these two stocks be good choices for diversification? Why

or why not?