 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2006trouble with a growth rate
I am tring to calculate a city's Compound growth rate, but I keep getting an error. the city has 233,149 as of 2004, and 242,820 in 2000. My formula is =(D4/J4)^(1/(2004 -2000))-1 Thanks for any help. I'm getting 1%, assuming that D4 contains 242,820 and J4 contains 233,149 That looks about right > I am tring to calculate a city's Compound growth rate, but I keep > getting an error. the city has 233,149 as of 2004, and 242,820 in 2000. > My formula is =(D4/J4)^(1/(2004 -2000))-1 > Thanks for any help. I am getting +1.0212%. For growth rate, the 2000 value should be less than 2004 value, right? You can also use rate function.  SignatureBest regards, --- Yongjun CHEN XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download ================================= >I am tring to calculate a city's Compound growth rate, but I keep getting >an error. the city has 233,149 as of 2004, and 242,820 in 2000. > My formula is =(D4/J4)^(1/(2004 -2000))-1 > Thanks for any help. > I am getting +1.0212%. > For growth rate, the 2000 value should be less than 2004 value, right? > You can also use rate function. That may be my problem-the 2000 pop is more than the 2004. lhs Even though the population has decreased, you can still calculate the growth rate. It's just negative. You might find it easier (for both you and anyone looking at the spreadsheet later on) to use the Rate function. SignatureRegards, Fred >> I am getting +1.0212%. >> For growth rate, the 2000 value should be less than 2004 value, right? >> You can also use rate function. > > That may be my problem-the 2000 pop is more than the 2004. > lhs |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.