Calculate:
1. Arithmetic Average Return
2. Geometric Average Return
3. Standard Deviation of Returns
4. Coefficient of deviation/arithmetic average return
5. Make comments on effect of portfolio diversification on average returns and riskiness (measured by the standard deviation of returns) of the portfolios.
Make a comment on portfolios Coefficient of Variation.
1
Year	100% Bonds	10/90	20/80	30/70	40/60	50/50	60/40	70/30	80/20	90/10	100% Stock	S&P 500	Decimal Return	Growth Factor	Investment Value
1970	13.7	11.9	10.2	8.5	6.8	5.1	3.4	1.8	0.1	-1.6	-3.2	4	0.04	1.04	104
1971	6.6	9	11.3	13.7	16.1	18.5	21	23.5	26	28.5	31.1	14.3	0.143	1.143	118.872
1972	3.7	5.2	6.7	8.3	9.8	11.4	12.9	14.5	16.1	17.6	19.2	19	0.19	1.19	141.45768
1973	3.4	1.1	-1.1	-3.4	-5.6	-7.8	-10	-12.1	-14.2	-16.3	-18.4	-14.7	-0.147	0.853	120.663401
1974	6.5	3.3	0.2	-2.9	-5.9	-8.8	-11.7	-14.5	-17.3	-19.9	-22.6	-26.5	-0.265	0.735	88.68759976
1975	6.7	10.2	13.8	17.4	21.1	24.9	28.7	32.6	36.5	40.5	44.5	37.2	0.372	1.372	121.6793869
1976	8.6	9.6	10.6	11.6	12.5	13.5	14.4	15.3	16.2	17	17.9	23.8	0.238	1.238	150.639081
1977	2.1	4.4	6.7	9	11.4	13.9	16.4	18.9	21.5	24.2	26.8	-7.2	-0.072	0.928	139.7930671
1978	1.6	4.2	6.9	9.7	12.5	15.4	18.3	21.3	24.3	27.4	30.6	6.6	0.066	1.066	149.0194096
1979	6	7.1	8.1	9.2	10.2	11.2	12.3	13.3	14.3	15.3	16.3	18.4	0.184	1.184	176.4389809
1980	6.4	8.3	10.3	12.2	14.2	16.1	18.1	20	22	23.9	25.8	32.4	0.324	1.324	233.6052107
1981	9.7	9.1	8.5	7.9	7.2	6.6	6	5.4	4.7	4.1	3.4	-4.9	-0.049	0.951	222.1585554
1982	22.5	21.5	20.5	19.5	18.5	17.5	16.5	15.5	14.5	13.5	12.4	21.4	0.214	1.214	269.7004863
1983	7.1	9.1	11.1	13.2	15.3	17.4	19.5	21.7	23.9	26.1	28.4	22.5	0.225	1.225	330.3830957
1984	12.9	12.3	11.7	11.1	10.5	9.8	9.2	8.6	7.9	7.2	6.5	6.3	0.063	1.063	351.1972307
1985	15.4	18	20.7	23.5	26.3	29.2	32.1	35.1	38.1	41.2	44.4	32.2	0.322	1.322	464.282739
1986	11	12.9	14.8	16.7	18.6	20.6	22.6	24.5	26.5	28.6	30.6	18.5	0.185	1.185	550.1750457
1987	3.1	4.5	5.8	7.1	8.4	9.7	10.9	12	13.1	14.1	15	5.2	0.052	1.052	578.7841481
1988	5.1	6.8	8.6	10.4	12.3	14.1	16	17.9	19.8	21.8	23.8	16.8	0.168	1.168	676.0198849
1989	10.9	11.8	12.6	13.4	14.3	15.1	15.9	16.7	17.5	18.3	19.1	31.5	0.315	1.315	888.9661487
1990	9.5	7.2	5	2.8	0.6	-1.6	-3.8	-5.9	-8	-10.1	-12.2	-3.1	-0.031	0.969	861.4081981
1991	14.1	15	15.9	16.8	17.7	18.6	19.4	20.2	21	21.9	22.6	30.5	0.305	1.305	1124.137699
1992	6.2	5.7	5.3	4.8	4.4	3.9	3.5	3	2.5	2	1.6	7.6	0.076	1.076	1209.572164
1993	8.6	10.6	12.7	14.7	16.8	18.9	21	23.2	25.4	27.6	29.8	10.1	0.101	1.101	1331.738952
1994	-4.2	-3.6	-3	-2.4	-1.8	-1.3	-0.7	-0.1	0.4	1	1.5	1.3	0.013	1.013	1349.051558
1995	15.4	15.5	15.5	15.5	15.5	15.5	15.5	15.5	15.5	15.5	15.5	37.6	0.376	1.376	1856.294944
1996	2.1	3.2	4.3	5.4	6.5	7.6	8.8	9.9	11	12.1	13.3	23	0.23	1.23	2283.242782
1997	5.9	5.8	5.7	5.6	5.5	5.4	5.2	5	4.9	4.7	4.4	33.4	0.334	1.334	3045.845871
1998	7	7	6.9	6.8	6.6	6.4	6.1	5.7	5.4	4.9	4.4	28.6	0.286	1.286	3916.95779
1999	-1.5	0.6	2.8	4.9	7.1	9.3	11.5	13.8	16.1	18.4	20.8	21	0.21	1.21	4739.518926
2000	10.6	9.3	7.9	6.6	5.3	3.9	2.6	1.3	0	-1.3	-2.6	-9.1	-0.091	0.909	4308.222703
2001	7.1	6.2	5.3	4.4	3.5	2.5	1.5	0.5	-0.6	-1.7	-2.8	-11.9	-0.119	0.881	3795.544202
2002	11.3	9.3	7.3	5.2	3.2	1.2	-0.9	-2.9	-5	-7	-9	-22.1	-0.221	0.779	2956.728933
2003	2.4	6.4	10.4	14.6	18.9	23.3	27.8	32.5	37.3	42.3	47.3	28.7	0.287	1.287	3805.310137
2004	3	5	7	9	11.1	13.1	15.2	17.4	19.5	21.7	23.9	10.9	0.109	1.109	4220.088942
2005	0.8	2.1	3.3	4.6	5.9	7.1	8.4	9.7	10.9	12.2	13.5	4.9	0.049	1.049	4426.8733
2006	2	4.1	6.2	8.4	10.6	12.9	15.1	17.4	19.7	22.1	24.5	15.8	0.158	1.158	5126.319282
2007	8.2	7.7	7.2	6.7	6.1	5.5	5	4.4	3.7	3.1	2.5	5.5	0.055	1.055	5408.266842
2008	7.1	1.2	-4.4	-9.8	-14.9	-19.9	-24.6	-29.2	-33.6	-37.7	-41.7	-37	-0.37	0.63	3407.20811
2009	1	4.6	8.2	11.9	15.6	19.3	23.1	26.8	30.6	34.3	38	26.5	0.265	1.265	4310.11826
2010	4.5	6.2	7.9	9.6	11.2	12.8	14.4	15.9	17.4	18.8	20.2	15.1	0.151	1.151	4960.946117
2011	6.9	5.3	3.7	2.1	0.4	-1.3	-3	-4.7	-6.4	-8.1	-9.8	2.1	0.021	1.021	5065.125985
2012	2.4	4	5.6	7.2	8.8	10.4	11.9	13.5	15.1	16.7	18.2	16	0.16	1.16	5875.546143
2013	-4.5	-1.9	0.7	3.4	6.2	9	11.9	14.8	17.9	20.9	24.1	32.4	0.324	1.324	7779.223093
1. Arithmetic Average Return	0.119227273
2. Geometric Average Return	0.104017159	10.402%
2. Geometric Average Return	Geomen Function-1	"Rate" Function
3. Standard Deviation of Returns
4. Coefficion of deviation/arithmetic average return	0
Source:	2014 The Merriman Financial Education Foundation