Question: Need help with A, C, D, E, F, G, H no excel 6. The following are monthly rates of return for Madison Cookies and Sophie

6. The following are monthly rates of return for Madison Cookies and Sophie Electric during a six-month period. Madison Sophie [R;-E(R)]* Month Cookies(R) Electric(R) R-ER) R-ECR] [R-E(R) 1 -04 .07 --057 .06 --0034 2 .06 -02 .043 -.03 -.0013 3 -.07 ..10 -.087 - 11 .0096 4 .12 .15 .103 .14 .0144 5 -.02 --06 --037 -.07 .0026 6 05 02 .033 .01 .0003 ON a. What level of correlation would you expect before performing any calculations? b. What is the average monthly return for each stock? c. What is the standard deviation for each stock? d. What is the covariance between the rates of returns? e. What is the correlation coefficient between the rates of return? f. Do these two stocks appear to be good choices for diversification? Why? g. What are the weights to achieve the minimum variance portfolio? h. Based on those weights, what is the expected return on the portfolio and the standard deviation of the portfolio
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
