Please answer in Excel

1. Use the security returns below, to answer the following questions. Assume that each return is equally likely to occur. Security A Returns (%) 17 11.3 10 7.8 6.2 4.7 Security B Returns (%) 9 8 7 6 5 -2.5 a. What is the correlation between these securities? b. Assuming that an investor can only choose between two securities, A or B, generate a model that will calculate the expected returns and the portfolio standard deviations for each of the following weights in security A: 0%, 10% 25%, 50%, 75%, 90%, 100%. c. Plot the expected the returns and standard deviations for the portfolios above and tell which ones are efficient (you can write on your graph (a scatterplot is fine)). d. Find the expected return and portfolio standard deviation for the minimum variance portfolio