Growth Function

Closed
Peter - Oct 14, 2008 at 06:42 AM
 Peter - Oct 14, 2008 at 10:04 AM
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 September 10, 2008 Status Member Last seen April 16, 2009 1
Oct 14, 2008 at 09:56 AM
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 ?)
0