Spreadsheet Exercise 3
			Assets			Portfolios
						AB	AC	BC
	Year	Stock A	Stock B	Stock C		(50% A + 50% B)	(50% A + 50% C)	(50% B + 50% C)
	2015	10%	10%	12%		10.00%	11.00%	11.00%
	2016	13%	11%	14%
	2017	15%	8%	10%
	2018	14%	12%	11%
	2019	16%	10%	9%
	2020	14%	15%	9%
	2021	12%	15%	10%
	Statistics:
a.	Expected Value	AVERAGE(C9:C15)			c.
b.	Standard Deviation	STDEVA(C9:C15)			d.
e.
f.