Growth Function

[rgoubet]

Hi,

I'm trying to project the growth of a series of numbers and I'm
struggling with the Growth function. The trouble is, I'm not a
statistician, nor even have any training in mathematics, so this is all
totally obscure. Here's the data I want to project:

2001 | 1757
2002 | 4875
2003 | 8688
2004 | 11827
2005 | 16517

I'm looking for the values for 2006-2010. So I thought the function for
2006 would be
=GROWTH(B1:B5;A1:E5;2006)

But I get a #NUM! Error.

Could anyone help?

Thanks!

Raph

 

[Frank]

I suggest you try ploting the data. Then from the shape of the curve
try to choose the appropriate Trendline to match it as well as
possible. Several varieties of Trendlines are available when you click
on the line in the graph. When you find one that you think fits pretty
well have it print it out on the graph. And there you are (wallah)!
Just use the equation and plug in the years you want.

Pranas Rudys