Annual Change from Decennial Data

C

Charles Bennett

I have a data series at ten-year intervals. I want to calculate the
implied annual rate of change in each decade. Is there a function for
this?
 
J

joeu2004

I have a data series at ten-year intervals. I want to calculate the
implied annual rate of change in each decade. Is there a function
for this?
Click to expand...

Suppose A1:A5 have data covering 40 years at 10-year intervals. The
average annual rate of change can be computed by either of the
following equivalent formulas:

=rate(40, 0, -1, A5/A1)

=(A5/A1)^(1/40) - 1
 
J

joeu2004

Suppose A1:A5 have data covering 40 years at 10-year intervals. The
average annual rate of change can be computed by either of the
following equivalent formulas:

=rate(40, 0, -1, A5/A1)
=(A5/A1)^(1/40) - 1
Click to expand...

I may have misinterpreted your question. I tried to offer the most
simplistic answer. But if you would like the growth rate for a curve
that (hopefully) closely fits the data, you might be interested in:

=growth(A1:A5,B1:B5,1)/growth(A1:A5,B1:B5,0) - 1

where B1:B5 has the values 0, 10, 20, 30 and 40.

But it would be prudent to graph the exponential curve to see just how
well it fits the data.
 
C

Charles Bennett

I may have misinterpreted your question. I tried to offer the most
simplistic answer. But if you would like the growth rate for a curve
that (hopefully) closely fits the data, you might be interested in:

=growth(A1:A5,B1:B5,1)/growth(A1:A5,B1:B5,0) - 1

where B1:B5 has the values 0, 10, 20, 30 and 40.

But it would be prudent to graph the exponential curve to see just how
well it fits the data.
Click to expand...
Many thanks, joeu2004 -- that's exactly what you wanted.
 
Top