View Single Post
  #2  
Old November 4th, 2009, 03:52 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default 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