Re: Access coefficients in trendline

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 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 
in three cells.
I can type
in one cell, press Ctrl+Shift+Enter and the cells contents change to 
but how do I change the (1,1)[0][0] section? Or am I way off?


View this message in context:
Sent from the GnuMeric mailing list archive at

[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]