After changing the variables to X i = x i, the calculations are completely similar to the linear case y = a n*X n +. + 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. n is the degree of the polynomial (in Excel, the order of a polynomial).
, 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
0 kommentar(er)
