The LINEST function is what you need. You just need two xs series: x and x^2. The polynomial regression in charts is actually a linear regression.
Le vendredi 02 octobre 2009 à 00:29 -0400, David Heinrich a écrit : > Hi all, > > I like the polynomial regression inside of the chart dialog for > gnumeric. I want to set up a interactive spreadsheet such that the > graph and equation of the form ax^2 + bx + c changes as I change data. > This works easily. However, I also want to have access to the result > of the polynomial equation function's coefficients (a, b, c) changing > without manually typing them over. > > The reason is because I want to setup another chart for predicted > values based on the equation. But this becomes a pain if I always have > to re-copy the coefficients. > > Is there a way to do this? > _______________________________________________ > gnumeric-list mailing list > gnumeric-list@gnome.org > http://mail.gnome.org/mailman/listinfo/gnumeric-list _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
