Dec 11 2018 02:21 AM
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!
Dec 11 2018 03:58 AM
Solved. The formula shown in the diagram is inaccurately simplified and only shows rounded coefficients unless specified.
See MS Support.