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 <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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
> > [email protected]
> > http://mail.gnome.org/mailman/listinfo/gnumeric-list
>
>
_______________________________________________
gnumeric-list mailing list
[email protected]
http://mail.gnome.org/mailman/listinfo/gnumeric-list
