Question

so Home File Insert Page Layout Formulas Data Review View D E C FORD MOTOR COMPANY Adjusted closing Annual Date price return 1995-12-01 9.881 1996-12-02 1.06 1997-12-01 2.25 1998-12-01 075 1999-12-01 3.25 2000-12-01 2001-12-03 0.87 2002-12-02 2003-12-01 2004-12-01 4.18 2005-12-01 8.9 2006-12-01 4.19 2007-12-03 2.37 2008-12-01 2009-12-01 2010-12-01 2011-12-01 2012-12-03 2013-12-02 2014-12-01 683 24 Average annual retum 25 Standard deviation of annual EC Exercise 15 DATA E xercise 16 Template EOC Exercise 17 Temp

Answer 1

	Date	Adjusted closing price	Annual return
	12/1/2014	1.04	-0.329032258	(Current Value-Previous Value)/ Previous Value
	12/2/2013	1.55	0.047297297
	12/3/2012	1.48	-0.113772455
	12/1/2011	1.67	-0.48136646
	12/1/2010	3.22	0.533333333
	12/1/2009	2.1	-0.058295964
	12/1/2008	2.23	-0.05907173
	12/3/2007	2.37	-0.434367542
	12/1/2006	4.19	-0.529213483
	12/1/2005	8.9	1.129186603
	12/1/2004	4.18	0.741666667
	12/1/2003	2.4	1.181818182
	12/2/2002	1.1	0.264367816
	12/3/2001	0.87	-0.074468085
	12/1/2000	0.94	-0.710769231
	12/1/2001	3.25	3.333333333
	12/1/2002	0.75	-0.666666667
	12/1/1997	2.25	1.122641509
	12/2/1996	1.06	-0.892712551
	12/1/1995	9.88
	Average Annual Return		0.210732017
	Standard Deviation of Annual		0.991260416