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

1 reply

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
-1
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