#1   Report Post  
Eugepticus
 
Posts: n/a
Default Trendline error???

Has anybody else had this problem? If one uses a 6 order polynomial as
trendline and then s/he enters manually in an other column the same equation
taken from the displayed trendline equation on the graph , the original
trendline is different from the one manually entered. Excel plots the two
different curves having the same equation!!!
Please see an example at : http://www.geocities.com/audax/error.xls
Thank you for the help.
Gene


  #2   Report Post  
Eugepticus
 
Posts: n/a
Default

Disregard the previous message. The problem is due to the rounding off. The
trendline calculation is OK.
Gene


  #3   Report Post  
Bernard Liengme
 
Posts: n/a
Default

See my website for the use of LINEST to get coefficients of polynomial fit
into cells
Then you are using Excel's maximum precision.

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"Eugepticus" wrote in message
om...
Disregard the previous message. The problem is due to the rounding off.
The
trendline calculation is OK.
Gene




  #4   Report Post  
Eugepticus
 
Posts: n/a
Default

Thanks for the lead. Interesting site!
Gene

"Bernard Liengme" wrote in message
...
See my website for the use of LINEST to get coefficients of polynomial fit
into cells
Then you are using Excel's maximum precision.

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"