1. Find the Global Minimum Variance Portfolio (the portfolio with the lowest variance achievable with the assets in the investment opportunity set). Save the portfolio and enter the return and volatility in the table.
2. Plot the minimum variance set, varying return. For example, use 4% to 30% in 2% intervals (or another similar set if this one does not fit your portfolio).

please use excel" solver" to do these questions! (non-constraint) it is short sales!

	asset weights	weights from solver
INTC: Intel Corp	0.166667	1
ORCL: Oracle	0.166667	0
GOOG: Alphabet	0.166667	0
LMT: Lockheed Martin	0.166667	0
C: Citigroup	-0.166667	0
BAC: Bank of America	-0.166667	0
AAL: American Airlines	0.166667	0
KR: Kroger	0.166667	0
CVS: CVS	0.166667	0
AXP: American Express	0.166667	0
	Portfolio	Solver Portfolio
sum of weights	1.00	1.00
portfolio return	0.195763538	0.163982972
portfolio return		0.163982972
portfolio variance	0.039016366	0.06661251
portfolio volatility	0.197525609	0.258093994

Expected return

expected returns

16.40%

11.42%

21.46%

16.48%

-1.79%

7.61%

16.28%

9.85%

11.03%

20.36%