Answer the questions by MS Excel

Use the security returns below, to answer the following questions. Assume that each return is equally likely to occur. 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%. 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. Given the following historical returns on XYZ and the market: a. Calculate beta using regression techniques. (show your regression output). b. Calculate beta using one of the formulas in the book. c. Graphically show the beta relationship by plotting XYZ's returns on the Y-axis and the market returns on the X-axis