View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Stuart Saich Stuart Saich is offline
external usenet poster
 
Posts: 1
Default Trend Line 5 or 6th order polynomial not working

I have a spreadsheet from excel 2003 in which I curve fitted many fifth order
polynomials. I then use the constants from the polynomial function as a
selection for curve generation.

I now want to add some curves and generate constants from trend lines but am
now using office 2007.

The old curve fitted data works well in 2007.

The new curve fitting trend line system cannot generate a fifth or sixth
order polynomial and the polynomial constants generated for a fourth order
polynomial do not generate the same source curve when inserted into the
polynomial equation.



Seems like the polyniimial solving routine has a problem?

Any ideas

Stu