ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Trendline error??? (https://www.excelbanter.com/charts-charting-excel/9-trendline-error.html)

Eugepticus

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



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.

--
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





Eugepticus

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





All times are GMT +1. The time now is 11:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com