Re: Access coefficients in trendline

[Mike Simms <mesimms gmail com>]

Hi Jean,

You say "you can evaluate them with the linest function (you need a column
for each power of the x values)." That sounds good, but reading section
5.2.4.5. of the manual, "Array Formulas", I don't understand what is meant.
does it mean, if my 'y' data is a1:a100 and my 'x' data is in b1:b100, and I
want a 3rd order polynomial, it sounds like I should try to get 
={linest(a1:a100Wind,b1:b100,TRUE)}(1,3)[0][0]
={linest(a1:a100Wind,b1:b100,TRUE)}(1,3)[0][1]
={linest(a1:a100Wind,b1:b100,TRUE)}(1,3)[0][2]
in three cells.
I can type
=linest(a1:a100Wind,b1:b100,TRUE)
in one cell, press Ctrl+Shift+Enter and the cells contents change to 
={linest(a1:a100Wind,b1:b100,TRUE)}(1,1)[0][0]
but how do I change the (1,1)[0][0] section? Or am I way off?

Regards,
Mike


-- 
View this message in context: http://old.nabble.com/Access-coefficients-in-trendline-tp34620098p34642382.html
Sent from the GnuMeric mailing list archive at Nabble.com.