Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Growth Rate for number series

Jan 2125
Feb 2055.63
Mar 2303.889
Apr 2624.77
May 1978.356
Jun 2084.52

I want to calculate the growth rate percent for the above data.

The data are not financial. also i like to know can i average monthly percentages?, following data are monthly percent difference. If i average them i come up with 1% growth. Is this the right way?
-3%
12%
14%
-25%
5%



  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,045
Default Growth Rate for number series

On Wed, 06 Apr 2011 10:22:46 GMT, learner wrote:

Jan 2125
Feb 2055.63
Mar 2303.889
Apr 2624.77
May 1978.356
Jun 2084.52

I want to calculate the growth rate percent for the above data.

The data are not financial. also i like to know can i average monthly percentages?, following data are monthly percent difference. If i average them i come up with 1% growth. Is this the right way?
-3%
12%
14%
-25%
5%



What do the values represent? If they are, for example, the size of a pool, what is it you are trying to determine?

If you want to know the percent growth rate over the time period, then simply:

=(LastValue - FirstValue) / FirstValue or -1.9%

That would also be the average growth rate.

If all you have are the percentages (in, for example, C2:C6), you could do something like:

=FVSCHEDULE(1,C2:C6)-1

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2,059
Default Growth Rate for number series

On Apr 6, 3:22*am, learner wrote:
Jan 2125
Feb 2055.63
Mar 2303.889
Apr 2624.77
May 1978.356
Jun 2084.52
I want to calculate the growth rate percent for the above
data. The data are not financial.


It actually does not matter whether or not the data are financial.
The same formulas might apply.

What does matter is whether those numbers represent a time series --
snapshots of the value of the same thing(s) over time -- or something
else entirely.

For a time series, the month-to-month growth rate can be computed by
=B2/B1-1 for example, assuming that B2 is 2055.63 and B1 is 2125.

The (geometric) average monthly growth rate of a time series can be
computed by =RATE(5,0,-B1,B6) or (B6/B1)^(1/5)-1, formatted as
Percentage, where B6 is 2084.52 and 5 is the number of time periods
minus one (i.e. the number of changes).

Note that if that rate is in C6, =FV(C6,5,-B1) is B6. That is, it is
the compounded monthly rate.

However, for some purposes, it is desirable to compute the
__arithmetic__ average monthly growth rate -- for example, if you plan
to use that rate for simulation.

In that case, the average monthly growth rate would be about 0.7% as
you computed (I presume). You can use the following array formula[*]:

=AVERAGE(B6:B2/B5:B1)-1

formatted as Percentage.

But if that rate is in C6, note that FV(C6,5,-B1) is __not__ B6. That
is, the arithmetic average rate is __not__ the compounded monthly
rate.
[*] Enter an array formula by pressing ctrl+shift+Enter instead of
Enter. Excel will display an array formula surrounded by curly braces
in the Formula Bar, i.e. {=formula}. You cannot type the curly braces
yourself. If you make a mistake, select the cell, press F2 and edit,
then press ctrl+shift+Enter.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Compound Interest Rate or Growth Rate 1944-71222 Excel Worksheet Functions 2 March 15th 10 05:38 AM
Average Growth Rate scott Excel Discussion (Misc queries) 8 October 26th 06 12:01 AM
Growth Rate Native Excel Discussion (Misc queries) 2 September 21st 06 12:34 AM
trouble with a growth rate Larry Holt Excel Worksheet Functions 4 March 18th 06 04:40 AM
monthly growth rate my Excel Worksheet Functions 5 March 2nd 06 02:07 AM


All times are GMT +1. The time now is 01:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"