Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trend Line 5 or 6th order polynomial not working
The formerly excellent chart polynomial trendline engine was "improved" in
2007 to the point that it is no longer trustworthy. LINEST on the other hand does seem to work better, and you can fit a polynomial with a formula like =LINEST(ydata,xdata^{1,2,3,4,5}) Note however that fitting a high order polynomial is a very challenging numerical problem unless your x data spans a very broad range. Jerry "Stuart Saich" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TREND function for a polynomial fit results in a linear fit | Excel Worksheet Functions | |||
How do I solve for x in a second-order polynomial trend? | Charts and Charting in Excel | |||
What makes a polynomial trend line curve up or down? | Charts and Charting in Excel | |||
trend for polynomial curve fitting by regressing | Excel Worksheet Functions | |||
higher order polynomial fit line x-coefficients | Excel Discussion (Misc queries) |