Hello Excel Tippers,

I have median sales prices for the years 2000-2005 for each census
tract in my City. The median is derived from any number of sales that
have occurred at any time during that particular year in that
particular census tract.

From one year to the next, some tract sale values have gone up. Some
years, some sales values have gone down. Some tracts have never gone
down in consecutive years.

Tract 2000 2001 2002 2003 2004 2005
101 120,000 110,000 130,000 180,000 210,000 215,000
102 110,000 150,000 145,000 180,000 190,000 190,000
103 210,000 250,000 240,000 280,000 340,000 360,000
104 130,000 160,000 190,000 210,000 230,000 240,000
105 350,000 400,000 500,000 575,000 600,000 650,000

What formula would provide me with this answer in Excel? Although I
described this as "average annual" in the title to this thread I'm not
sure that really describes what I'm after. I don't think Compound
Annual Growth Rate (am I wrong?) is the correct measure.


--
James Hobart
------------------------------------------------------------------------
James Hobart's Profile: http://www.excelforum.com/member.php...o&userid=17540
View this thread: http://www.excelforum.com/showthread...hreadid=526223