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\mathrm{.}25$ points$)$b$.$ Solve for the weight of the minimum variance portfolio. Explain what these weights mean. $(0\mathrm{.}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\mathrm{.}25$ points$)$d$.$ Plot the mean$-$variance frontier and the efficient frontier in one graph. $(0\mathrm{.}5$ points$)$e$.$ Repeat the analysis in part D but now assume that the correlation between the two assets increases by $0\mathrm{.}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\mathrm{.}5$ points$)$

It$$s financial modeling, iI need it in Excel