Growth Function

Closed
Peter - 14 Oct 2008 à 06:42
 Peter - 14 Oct 2008 à 10:04
Hello,
I cant get the GROWTH function to predict the next in the series from Y = X^2.
I have just started practising using forecasting functions and this seemed like a good test for me.
Peter
Related:

1 response

austqui Posts 15 Registration date Wednesday 10 September 2008 Status Member Last seen 16 April 2009 1
14 Oct 2008 à 09:56
hello,

here is a link which might help you:

https://www.techonthenet.com/excel/formulas/growth.php

just check that buddy
Thanks for looking. That is similar to the Excel help
Take the series 1, 4, 9, 25, 36 (ie Y = X^2). The next in the series is obviously 49 but Growth returns 87 or 99 depending on whether you turn the constant off or on.
The basic Growth formula is highly exponential being based on m^x and yet x^2 is exponential (isn't it ?)