Please answer this question in Excel,

Consider the following joint PDF (1.75 points) a) Calculate the expected return of IBM and the market. (0.5 points) b) Calculate the variance of IBM and the market. (0.25 points) c) Calculate the covariance and correlations of IBM and the market without using the excel function. (You may use the function to confirm your answer is correct). (0.50 points) d) Compute the expected return and standard deviation of a portfolio that invests X% in IBM and (1-X%) in the market for values of 10% to 100% in increments of 10%. (0.50 points) 2. Download daily stock prices for the Vanguard Total Bond Market ETF (Ticker:BND) and the Vanguard Total Stock Market ETF (Ticker: VTI) for 2015. Calculate daily returns. (2 points) a. Does one asset mean-variance dominate the other? Why or why not? (0.25 points) b. Solve for the weight of the minimum variance portfolio. Explain what these weights mean. Impose the no short-selling constraint when finding the weights. (0.5 points) c. Compute the expected return and standard deviation for a portfolio that invests X% in the bond market portfolio and 1-X% in the stock portfolio in increments of 10%. In addition, include the weights for the minimum variance portfolio. (0.25 points) d. Plot the mean-variance frontier and the efficient frontier in one graph. (0.5 points) e. Repeat the analysis in part D but now assume that the correlation between the two assets increases by 0.5 (and change the covariance accordingly). Compare the results of the graphs and explain whether investors are better or worse off after the increase in the correlation. [You may want to show this results in a separate tab]. (0.5 points)