Excel trendline doesn't fit

Copper Contributor

Hi there

 

While working on trendlines I stumbled on the following problem:

I'm looking for a polynomial, 6th order trendline for the data in column A (x values) and B (y values), which I found (upper diagram). To see the actual inaccuracies I calculated the values of the given function and put those in the lower diagram - which shows a completely other curve than the one I'd need (and than the one shown in the upper diagram). Yet, the trendline is the very same..

 

Any ideas on what could've gone wrong or how to get a fitting trendline?

 

Thanks!

 

1 Reply

Solved. The formula shown in the diagram is inaccurately simplified and only shows rounded coefficients unless specified.

 

See MS Support.