C
Cam Snow
Dear Microsoft,
Excel 2007 has a bug in the trendline equations generated making 3rd order
and higher polynomials with the intercept = 0. When one makes a graph and
receives the equations y=-a*x^3+b*x^2+cx, the equation, when then entered
into cells to replicate the line does not yield the same answer.
This functionality is crucial for those of us that use excel as our graphing
package of choice. I was able to replicate the error on other data sets.
However, when using office 2003 it works properly.
Furthermore, if one clicks display equation, before changing from a 2nd to
3rd order polynomial, the equation maintains the form of a 2nd order
polynomial.
Thanks,
C
Excel 2007 has a bug in the trendline equations generated making 3rd order
and higher polynomials with the intercept = 0. When one makes a graph and
receives the equations y=-a*x^3+b*x^2+cx, the equation, when then entered
into cells to replicate the line does not yield the same answer.
This functionality is crucial for those of us that use excel as our graphing
package of choice. I was able to replicate the error on other data sets.
However, when using office 2003 it works properly.
Furthermore, if one clicks display equation, before changing from a 2nd to
3rd order polynomial, the equation maintains the form of a 2nd order
polynomial.
Thanks,
C