Forum Discussion
Excel trendline doesn't fit
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 (u...
Solved. The formula shown in the diagram is inaccurately simplified and only shows rounded coefficients unless specified.
See https://support.microsoft.com/en-us/help/211967/chart-trendline-formula-is-inaccurate-in-excel.