9-I Assume the annual price data below is for General Foods and the S&P 500, covering the period 1997-2012. Calculate the beta for General Foods. Use the ESTLIN function or the SLOPE function in the spreadsheet.

9-1 Assume the annual price data below is for General Foods and the S&P 500, covering the period 1997-2012. Calculate the beta for General Foods. Use the ESTLIN function or the SLOPE function in the spreadsheet. Year GF S&P 2012 2011 2010 2009 2008 2007 2006 2005 2004 40.58 48.38 40.96 4334 55.38 52.26 59.49 58.72 45.93 32.06 21.93 18.67 17.24 163 9.29 1.211.92 1.111.92 879.82 1.148.08 1.320.28 1.46925 1.229.23 97043 74074 61593 45927 46645 43571 41709 33022 3534 2003 2002 2001 2000 1999 1998 1997 757