Asset Allocation Data

a$.$ Using EXCEL's Data Table Feature, create a one$-$way data table that determines the different means and standard deviations for combinations of Portfolio $1$ and Portfolio $2$ by varying the proportion of Portfolio $1.$

b$.$ Graph the combinations of the portfolios from the one$-$way data table and add the individual asset means and standard deviations to the graph.

c$.$ Using EXCEL's Text Box feature, explain why the envelope portfolios may or may not be on the efficient frontier?

d$.$ Using Solver or Goal Seek, find an envelope portfolio that would yield an expected return of $4\mathrm{.}50\%.$ What would be the corresponding portfolio standard deviation?

e$.$ Using Solver or Goal Seek, find two envelope portfolios that would yield a standard deviation of $11\%.$ What would be the corresponding expected returns for each of these portfolios?

f$.$ Using Solver, find the envelope portfolio that would yield the smallest $($minimum$)$ standard deviation. What would be the corresponding expected return and standard deviation for this portfolio?