Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Calculate 'Compound Annual Growth Rate'?
Go
New
Search
Notify
Tools
Reply
  
Calculate 'Compound Annual Growth Rate'?
 Login/Join
 
Member
posted
Does any one knows how to calculate 'Compound Annual Growth Rate? In Excel it is this

formula =POWER((E2/B2),(1/(E1-B1)))-1

Thanks.

Margaret
 
Posts: 12 | Registered: March 30, 2006Reply With QuoteReport This Post
Virtuoso
posted Hide Post
should be:
 COMPUTE VALUE/D12.2 = ((E2/B2) ** (1/(E1-B1))) -1;  
I think.


"There is no limit to what you can achieve ... if you don’t care who gets the credit." Roger Abbott
 
Posts: 1102 | Location: Toronto, Ontario | Registered: May 26, 2004Reply With QuoteReport This Post
Expert
posted Hide Post
margo, it may help to think about it this way:
if you have values starting in 2000 and ending in 2005, then you have 6 data points, and 5 time periods.
so the cgr is the 5th root of the simple growth rate between the 2006 ending value and the 2000 starting value, that rate which if applied to the 2000 value for each of 5 years, would give you the exact same 2006 value as you actually have.
In focus , a root, of a number X is X**(1/root)
So a square root would be X**(1/2)
Yes there's a SQRT function, but to continue to other roots, its useful to know that exponentiating by the desired root's inverse is the way to go, as dhagen says




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
 
Posts: 3811 | Location: Manhattan | Registered: October 28, 2003Reply With QuoteReport This Post
Member
posted Hide Post
Thank you for an explanation and such a quick response. Code works like a charm.

Margaret
 
Posts: 12 | Registered: March 30, 2006Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     Calculate 'Compound Annual Growth Rate'?

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.