Use the Excel file Asset Allocation Data to determine the following:

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?