Re: getting around null cell values?

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.



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

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