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

[Jean Bréfort <jean brefort normalesup org>]

Le mardi 09 octobre 2007 �2:19 +0200, Nicolas ROUSSELON a �it :
> 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�rt <jean brefort normalesup org> wrote:
>         Le lundi 08 octobre 2007 �6:00 +0200, Nicolas ROUSSELON a
>         �it : 
>         > 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