The correct way to do CAGR calculations? The Next CEO of Stack OverflowAre these derivatives correct??Is my working correct? Exponenial decayMore than one way to solve a exponential equation?Is this proof that $e$ is irrational correct?Other Way to Express an Exponential FunctionIs this a correct way of expressing number in natural logarithmA mathmatical way to solve for $x$ in $(a + b)^2 = a^x + b^x$On the way finding limit.What is the significance of the number 2.87682 popping up in my calculations?Simple way of explaining the empty product
Is fine stranded wire ok for main supply line?
What is the difference between "hamstring tendon" and "common hamstring tendon"?
It is correct to match light sources with the same color temperature?
Is it convenient to ask the journal's editor for two additional days to complete a review?
Getting Stale Gas Out of a Gas Tank w/out Dropping the Tank
In the "Harry Potter and the Order of the Phoenix" video game, what potion is used to sabotage Umbridge's speakers?
Is there such a thing as a proper verb, like a proper noun?
Is a distribution that is normal, but highly skewed, considered Gaussian?
What is the process for purifying your home if you believe it may have been previously used for pagan worship?
How to find image of a complex function with given constraints?
How to get the last not-null value in an ordered column of a huge table?
"Eavesdropping" vs "Listen in on"
Point distance program written without a framework
Small nick on power cord from an electric alarm clock, and copper wiring exposed but intact
What are the unusually-enlarged wing sections on this P-38 Lightning?
How do I fit a non linear curve?
Why is the US ranked as #45 in Press Freedom ratings, despite its extremely permissive free speech laws?
Help/tips for a first time writer?
What difference does it make using sed with/without whitespaces?
Players Circumventing the limitations of Wish
The Ultimate Number Sequence Puzzle
How did Beeri the Hittite come up with naming his daughter Yehudit?
Is there a way to save my career from absolute disaster?
What day is it again?
The correct way to do CAGR calculations?
The Next CEO of Stack OverflowAre these derivatives correct??Is my working correct? Exponenial decayMore than one way to solve a exponential equation?Is this proof that $e$ is irrational correct?Other Way to Express an Exponential FunctionIs this a correct way of expressing number in natural logarithmA mathmatical way to solve for $x$ in $(a + b)^2 = a^x + b^x$On the way finding limit.What is the significance of the number 2.87682 popping up in my calculations?Simple way of explaining the empty product
$begingroup$
I was recently familiarizing myself with CAGR formulae and spotted that several sources interpret the formula in different ways.
METHOD ONE: from Wikipedia
$V_0$=9000 (2004),
$V_n$=13000 (2007)
$ mathrm CAGR (t_0,t_n)=left(frac V(t_n)V(t_0)right)^frac 1t_n-t_0-1$
Which gives us the CAGR value to be 13%.
$rm CAGR(0,3) = left( frac130009000 right)^frac13 - 1 = 0.13 = 13%$
METHOD TWO: Extend Office
However, other sources appear to count the number of years differently, namely using the (N-1) notation, such as here:(https://www.extendoffice.com/documents/excel/2596-excel-average-compound-growth-rate.html):
Where instead of $t_n -t_0$ the author is counting all the periods and subtracting one. In this particular example, the date range of 2011-2020 is counted as 9 years (the distance between $t_n$ and $t_0$).
For now, both methods of calculating years line up, which doesn't affect the answers.
METHOD THREE: CAGRCALCULATOR
What get's confusing is when some sources appear to count the total number of years including the original year, such as here (https://cagrcalculator.net/formula-for-cagr-calculation/), where between 2008 and 2016 is counted as 9 years, where the prior formulae would return 8.
Putting aside the gotchas of calculating CAGR and treating it as the definitive growth metric, which one of these is correct?
exponential-function
$endgroup$
add a comment |
$begingroup$
I was recently familiarizing myself with CAGR formulae and spotted that several sources interpret the formula in different ways.
METHOD ONE: from Wikipedia
$V_0$=9000 (2004),
$V_n$=13000 (2007)
$ mathrm CAGR (t_0,t_n)=left(frac V(t_n)V(t_0)right)^frac 1t_n-t_0-1$
Which gives us the CAGR value to be 13%.
$rm CAGR(0,3) = left( frac130009000 right)^frac13 - 1 = 0.13 = 13%$
METHOD TWO: Extend Office
However, other sources appear to count the number of years differently, namely using the (N-1) notation, such as here:(https://www.extendoffice.com/documents/excel/2596-excel-average-compound-growth-rate.html):
Where instead of $t_n -t_0$ the author is counting all the periods and subtracting one. In this particular example, the date range of 2011-2020 is counted as 9 years (the distance between $t_n$ and $t_0$).
For now, both methods of calculating years line up, which doesn't affect the answers.
METHOD THREE: CAGRCALCULATOR
What get's confusing is when some sources appear to count the total number of years including the original year, such as here (https://cagrcalculator.net/formula-for-cagr-calculation/), where between 2008 and 2016 is counted as 9 years, where the prior formulae would return 8.
Putting aside the gotchas of calculating CAGR and treating it as the definitive growth metric, which one of these is correct?
exponential-function
$endgroup$
1
$begingroup$
What is CAGR for the dumbs ?
$endgroup$
– Jean Marie
Mar 19 at 21:54
$begingroup$
If you mean as an expansion of abbreviation - compound annual growth rate
$endgroup$
– Thomas E
Mar 19 at 21:57
$begingroup$
Thanks for your prompt answer to a non native english speaker.
$endgroup$
– Jean Marie
Mar 19 at 22:00
add a comment |
$begingroup$
I was recently familiarizing myself with CAGR formulae and spotted that several sources interpret the formula in different ways.
METHOD ONE: from Wikipedia
$V_0$=9000 (2004),
$V_n$=13000 (2007)
$ mathrm CAGR (t_0,t_n)=left(frac V(t_n)V(t_0)right)^frac 1t_n-t_0-1$
Which gives us the CAGR value to be 13%.
$rm CAGR(0,3) = left( frac130009000 right)^frac13 - 1 = 0.13 = 13%$
METHOD TWO: Extend Office
However, other sources appear to count the number of years differently, namely using the (N-1) notation, such as here:(https://www.extendoffice.com/documents/excel/2596-excel-average-compound-growth-rate.html):
Where instead of $t_n -t_0$ the author is counting all the periods and subtracting one. In this particular example, the date range of 2011-2020 is counted as 9 years (the distance between $t_n$ and $t_0$).
For now, both methods of calculating years line up, which doesn't affect the answers.
METHOD THREE: CAGRCALCULATOR
What get's confusing is when some sources appear to count the total number of years including the original year, such as here (https://cagrcalculator.net/formula-for-cagr-calculation/), where between 2008 and 2016 is counted as 9 years, where the prior formulae would return 8.
Putting aside the gotchas of calculating CAGR and treating it as the definitive growth metric, which one of these is correct?
exponential-function
$endgroup$
I was recently familiarizing myself with CAGR formulae and spotted that several sources interpret the formula in different ways.
METHOD ONE: from Wikipedia
$V_0$=9000 (2004),
$V_n$=13000 (2007)
$ mathrm CAGR (t_0,t_n)=left(frac V(t_n)V(t_0)right)^frac 1t_n-t_0-1$
Which gives us the CAGR value to be 13%.
$rm CAGR(0,3) = left( frac130009000 right)^frac13 - 1 = 0.13 = 13%$
METHOD TWO: Extend Office
However, other sources appear to count the number of years differently, namely using the (N-1) notation, such as here:(https://www.extendoffice.com/documents/excel/2596-excel-average-compound-growth-rate.html):
Where instead of $t_n -t_0$ the author is counting all the periods and subtracting one. In this particular example, the date range of 2011-2020 is counted as 9 years (the distance between $t_n$ and $t_0$).
For now, both methods of calculating years line up, which doesn't affect the answers.
METHOD THREE: CAGRCALCULATOR
What get's confusing is when some sources appear to count the total number of years including the original year, such as here (https://cagrcalculator.net/formula-for-cagr-calculation/), where between 2008 and 2016 is counted as 9 years, where the prior formulae would return 8.
Putting aside the gotchas of calculating CAGR and treating it as the definitive growth metric, which one of these is correct?
exponential-function
exponential-function
asked Mar 19 at 20:49
Thomas EThomas E
11
11
1
$begingroup$
What is CAGR for the dumbs ?
$endgroup$
– Jean Marie
Mar 19 at 21:54
$begingroup$
If you mean as an expansion of abbreviation - compound annual growth rate
$endgroup$
– Thomas E
Mar 19 at 21:57
$begingroup$
Thanks for your prompt answer to a non native english speaker.
$endgroup$
– Jean Marie
Mar 19 at 22:00
add a comment |
1
$begingroup$
What is CAGR for the dumbs ?
$endgroup$
– Jean Marie
Mar 19 at 21:54
$begingroup$
If you mean as an expansion of abbreviation - compound annual growth rate
$endgroup$
– Thomas E
Mar 19 at 21:57
$begingroup$
Thanks for your prompt answer to a non native english speaker.
$endgroup$
– Jean Marie
Mar 19 at 22:00
1
1
$begingroup$
What is CAGR for the dumbs ?
$endgroup$
– Jean Marie
Mar 19 at 21:54
$begingroup$
What is CAGR for the dumbs ?
$endgroup$
– Jean Marie
Mar 19 at 21:54
$begingroup$
If you mean as an expansion of abbreviation - compound annual growth rate
$endgroup$
– Thomas E
Mar 19 at 21:57
$begingroup$
If you mean as an expansion of abbreviation - compound annual growth rate
$endgroup$
– Thomas E
Mar 19 at 21:57
$begingroup$
Thanks for your prompt answer to a non native english speaker.
$endgroup$
– Jean Marie
Mar 19 at 22:00
$begingroup$
Thanks for your prompt answer to a non native english speaker.
$endgroup$
– Jean Marie
Mar 19 at 22:00
add a comment |
0
active
oldest
votes
StackExchange.ifUsing("editor", function ()
return StackExchange.using("mathjaxEditing", function ()
StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
);
);
, "mathjax-editing");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "69"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
noCode: true, onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3154589%2fthe-correct-way-to-do-cagr-calculations%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Mathematics Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
Use MathJax to format equations. MathJax reference.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fmath.stackexchange.com%2fquestions%2f3154589%2fthe-correct-way-to-do-cagr-calculations%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
1
$begingroup$
What is CAGR for the dumbs ?
$endgroup$
– Jean Marie
Mar 19 at 21:54
$begingroup$
If you mean as an expansion of abbreviation - compound annual growth rate
$endgroup$
– Thomas E
Mar 19 at 21:57
$begingroup$
Thanks for your prompt answer to a non native english speaker.
$endgroup$
– Jean Marie
Mar 19 at 22:00