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