Trendline error???

[Eugepticus]

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

 

[Eugepticus]

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

 

[Bernard Liengme]

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

 

[Eugepticus]

Thanks for the lead. Interesting site!
Gene