I could not find any Excel function for a very basic task: Calculating
the average percentile (or other) rate of change of a value between two
time periods.

Example: if in 1990 Ed weighed 100 and in 2000 Ed weighed 200, this
means that his weight rose by 7.18 percent in an average year between
1990 and 2000, as I can tell from using the compound interest
calculator at
http://www.moneychimp.com/calculator...calculator.htm.

There is a whole host of functions for statistical analyis functions.

The one that you wanted was growth.

=GROWTH(D12,C1:C2,1991)-100

where d1:d2=100,200
c1:c2=1990,2000

--
Hope this helps
Martin Fishlock
Please do not forget to rate this reply.


"David Virgil Hobbs" wrote:

> I could not find any Excel function for a very basic task: Calculating
> the average percentile (or other) rate of change of a value between two
> time periods.
>
> Example: if in 1990 Ed weighed 100 and in 2000 Ed weighed 200, this
> means that his weight rose by 7.18 percent in an average year between
> 1990 and 2000, as I can tell from using the compound interest
> calculator at
> http://www.moneychimp.com/calculator...calculator.htm.
>
>