Forum Discussion
Polynomial regression using Analysis ToolPack
There is no special option for polynomial regression, never has been.
As the links in your post explain, you have to create an extra column: to the right of the column with the x-values, use formulas to return the square of the x-values (i.e. x²). These formulas are of the form
=A2^2
Enter the range consisting of the column with the x-values AND the column with their squares in the Input X Range box.
There is no special option for polynomial regression, never has been.
As the links in your post explain, you have to create an extra column: to the right of the column with the x-values, use formulas to return the square of the x-values (i.e. x²). These formulas are of the form
=A2^2
Enter the range consisting of the column with the x-values AND the column with their squares in the Input X Range box.
