Trendline error???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Eugepticus - 26 Nov 2004 17:30 GMT

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

Reply to this Message

Eugepticus - 26 Nov 2004 19:17 GMT

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

Reply to this Message

Bernard Liengme - 29 Nov 2004 20:34 GMT

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

Signature

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

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

Reply to this Message

Eugepticus - 30 Nov 2004 04:40 GMT

Thanks for the lead. Interesting site!
Gene

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

Reply to this Message