Polynomial regression using Analysis ToolPack

[EdouardS]

Hi everyone,

I would like to perform a nonlinear polynomial regression (for example y = ax² + bx + c) and obtain, in addition with the equation and R², the conficende interval and p-value of the different coefficients. Such information are provided (in Excel 2019) for linear univariate regression by the Data Analysis ToolPack but other types of regression are not supported by the ToolPack.

This is strange because I found on forums and tutorials (see links below) that previous versions of Excel did include nonlinera polynomial regression in the analysis ToolPack. How can I recover such tool ?

second answer on this forum : https://stackoverflow.com/questions/10857252/quadratic-and-cubic-regression-in-excel 

https://www.real-statistics.com/multiple-regression/polynomial-regression/ 

https://facultystaff.richmond.edu/~rdominey/301/Excel4.html 

Do I have to install older versions of Excel to get back this feature or is there an other way to go ?

Thank you !

[#2 · Accepted solution]

@EdouardS 

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.

 

[#3]

Ow right, I thing I accidentally swap the Xs and Y when I tried last time. Thank you very much for your help !