also, is there any way to get LINEST to display a, b, and c coefficients in cells one-beneath the other. I want my a, b, c coefficients displayed in say B9, B10, and B11...not in B9, C9, D9. I have other y-data in the B, C, and D columns.
On Fri, Oct 2, 2009 at 2:51 AM, David Heinrich <dh0...@gmail.com> wrote: > I have a column with y values that is populated by an IF function like > such: IF(B1="","",<calculation>). > > I want to do a polynomial regression on these y values with LINEST so as to > get the coefficients for ax^2 + bx + c. Yet, the blank cells screw up > LINEST. If I delete the ones that end up blank, LINEST counts them as 0's, > and that completely messes up the coefficient calculation. > > Any way to get around this? Any way to populate a series of cells (say B10, > B11, B12, B13) with the 4 our of 8 y-value cells in the guys above that > contain data, along with the corresponding x-value cells (A10-A13).
_______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
