# Re: polynomial regression using LINEST (2nd order and higher)

• From: "Nicolas ROUSSELON" <nico rousselon gmail com>
• To: "Jean Bréfort" <jean brefort normalesup org>
• Cc: gnumeric-list gnome org
• Subject: Re: polynomial regression using LINEST (2nd order and higher)
• Date: Tue, 9 Oct 2007 16:52:21 +0200

Hello,

It works well, if the inputs are in the columns, the result is in a row. Does not seem to work if the input is in rows (does not matter to me). A good way to get the results is: =index(linest(Ys,Xss),1,1)  and then 1,2)  1,3) for a 2nd order.

Thanks,

Nicolas

On 10/9/07, Jean Bréfort <jean brefort normalesup org> wrote:
Le mardi 09 octobre 2007 à 12:19 +0200, Nicolas ROUSSELON a écrit :
> Any ideas about how i can do what I want without using Linest?
>
> Nicolas

At the moment, the only way to do that is to add ranges (columns?) with
the x^2 and x^3 values and pass all these data to linest (you need to
pass all the x, x^2 and x^3 values as one block, and linest will return
a four column matrix).

> On 10/8/07, Jean Bréfort <jean brefort normalesup org> wrote:
>         Le lundi 08 octobre 2007 à 16:00 +0200, Nicolas ROUSSELON a
>         écrit :
>         > Hello,
>         >
>         >
>         > In XL, the linest function can be used to do a polynomial
>         regression.
>         > (ex: LINEST(known_y's,known_x's^{1,2,3}) ).
>         > I can't make it work in Gnumeric.
>         > Am i doing something wrong?
>         > Can it be done?
>         >
>         > Regards,
>         >
>         > Nicolas
>
>         Known bug: http://bugzilla.gnome.org/show_bug.cgi?id=317426
>
>         Regards,
>         Jean
>
>
>
> _______________________________________________
> gnumeric-list mailing list
> gnumeric-list gnome org
> http://mail.gnome.org/mailman/listinfo/gnumeric-list