Re: getting around null cell values?

["Andreas J. Guelzow" <aguelzow pyrshep ca>]

On Fri, 2009-10-02 at 02:52 -0400, David Heinrich wrote:
> 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.

TRANSPOSE(LINEST...))

Andreas

> On Fri, Oct 2, 2009 at 2:51 AM, David Heinrich <dh003i 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