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?