+ a 3*x 3 + a 2*x 2 + a 1*x + b is transformed to a linear function using a change of variables. Note: Excel uses a linear model: the polynomial function y = a n*x n + .
Excel works with polynomial orders from 2 nd to 6 th. , a 3, a 2, a 1 and b are calculated parameters of the function (also named function coefficients or constants) that describe the relationship between x and y, The polynomial trendline is a curved line with the function:
Polynomial trendline equation and formulas
The degree of the polynomial is specified in the Order field - see more about the polynomial trendline in Excel.Įxcel uses the least squares method to fit a polyline for the data points.įor a trend line, two sets of variables are required:
