Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Polynomial trendline order in Excel 2007
Any particular reason why the maximum order for a polynomial trendline in
Excel 2007 is 6? This seems rather limiting. Any way of using a higher order polynomial? Thanks in advance, Arnaud |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Polynomial trendline order in Excel 2007
FWIW, most poly fits of order six that you see in Excel have been
woefully overfitted. Most poly fits should not have an order higher than two. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ Arnaud Miege wrote: Any particular reason why the maximum order for a polynomial trendline in Excel 2007 is 6? This seems rather limiting. Any way of using a higher order polynomial? Thanks in advance, Arnaud |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Polynomial trendline order in Excel 2007
I concur with Jon (who is not know for lightly forgiving Microsoft for any
of its 'trespasses') In the physical sciences, a fit with more than 4 terms is very rare One has to ask: what is the meaning of these terms? Mathematically, any N order pairs of data can be fitted to a N-1 order polynomial (2 points - straight line, 3 points - a parabola, etc) but just because we can make a fit it does not mean we necessarily know more about the data. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Arnaud Miege" wrote in message ... Any particular reason why the maximum order for a polynomial trendline in Excel 2007 is 6? This seems rather limiting. Any way of using a higher order polynomial? Thanks in advance, Arnaud |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Polynomial Order Incorrect | Charts and Charting in Excel | |||
how to: polynomial regression trendline excel 2007 | Charts and Charting in Excel | |||
polynomial trendline | Excel Worksheet Functions | |||
How do I determine which order to use in a polynomial trendline? | Charts and Charting in Excel | |||
Is there a way to obtain a polynomial trendline of order higher th | Charts and Charting in Excel |