RobertNiles.com
About Robert
Reporting Help
Finding Data on the Internet
Questions for Candidates
Stats Lessons
Mean
Median
Percent
Per capita
Standard Deviation
Margin of Error
Data Analysis
Sample Sizes
Stats Tests
Help Board
Bookstore


Statistics for the Utterly Confused

This book offers a super-accessible approach to the much-misunderstood subject of statistics.
More information
-->

Home > Statistics Every Writer Should Know > The Stats Board > Discusssion

compound annual growth rate
Message posted by Joseph Hogue on February 2, 2000 at 12:00 AM (ET)

Could someone tell me the formula for the compound annual growth rate? Please use symbol such as + for plus, - for minus, / for divided by, and * for multiply. I have no idea what ^ means. Thank you so much.


READERS RESPOND:
(In chronological order. Most recent at the bottom.)

Re: compound annual growth rate
Message posted by Jack Tomsky on February 3, 2000 at 12:00 AM (ET)

If X is the starting amount and Y is the amount after t years, then the compound annual growth rate is given by the t-th root of the ratio of Y to X, minus one.


Re: compound annual growth rate
Message posted by P. Sherwood on March 22, 2000 at 12:00 AM (ET)

See http://www.fool.com/DDow/1999/DDow990309.htm, from the Motley Fool, for a very clear and comprehensible explanation of how to calculate CAGR.


Re: compound annual growth rate
Message posted by David on May 11, 2000 at 12:00 AM (ET)

How does Excel calculate an unknown amount to a specific power. I.e. what is the formula for N^7=2.336198, solving for "N"?

Thanks in advance.


Re: compound annual growth rate
Message posted by Kumud Singh-Altmayer on May 13, 2000 at 12:00 AM (ET)

Need help for doing Energy analysis, forecast and especially on CAGR.

Thank you!

Ms. KSA


Re: compound annual growth rate
Message posted by Y on May 24, 2000 at 12:00 AM (ET)

Your question:
I.e. what is the formula for N^7=2.336198, solving for "N"?

Answer:

N^7=2.336198
N = 2.336198^(1/7)

Therefore the formula in Excel is

=POWER(2.336198,1/7)

The POWER function is found in

Insert/Function/Math & Trig

Or there should be a shortcut button "fx"



Your $5 contribution helps cover part the $500 annual cost of keeping this site online.

Niles Online Sites:RobertNiles.comTheme Park InsiderViolinist.com

RobertNiles.com™, the site, content and services 咀opyright 1996-2002, Robert Niles.
All rights reserved. Questions? Comments? Read my Privacy Policy, or E-mail me!