Re: Constrain a polynomial trend line to intercept y-axis horizontally

[Mike Simms <mesimms gmail com>]

Thanks Jean and John,

I guess most of the time I'm trying to fit the a quadratic which intersects
the y-axis with a slope of zero. 
Suppose I have my 'y's in A1:A1000 and my 'x's in B1:B1000. I prepare
C1=B1^2 and copy down to C1000. Then i select three cells in a row and type
=linest(A1:A1000,B1:C1000,TRUE) and I get the same coefficients for x^2, x
and the constant term that I see when I display the equation on the chart. 
x^2 coeff is 0.062222
x coeff is 0.82926
constant is 23.70

So far so good. I'm not sure where/how to type the array constant {0,2} into
the cell, if i type 
=linest(A1:A1000^{0,2},b1:c1000,TRUE) then I get some large numbers which
can't be right. 
first cell: 13.04667
second cell 77.1289

Am I typing this formula withe array constant correctly?



--
View this message in context: 
http://gnome-apps.13852.n7.nabble.com/Constrain-a-polynomial-trend-line-to-intercept-y-axis-horizontally-tp63654p63662.html
Sent from the GnuMeric mailing list archive at Nabble.com.