Home Â» How to Perform Polynomial Regression in Excel

# How to Perform Polynomial Regression in Excel

Regression analysis is used to quantify the relationship between one or more explanatory variables and a response variable.

The most common type of regression analysis is simple linear regression, which is used when an explanatory variable and a response variable have a linear relationship.

However, sometimes the relationship between an explanatory variable and a response variable is nonlinear.Â

In these cases it makes sense to useÂ polynomial regression, which can account for the nonlinear relationship between the variables.

This tutorial explains how to perform polynomial regression in Excel.

### Example: Polynomial Regression in Excel

Suppose we have the following dataset in Excel:

Use the following steps to fit a polynomial regression equation to this dataset:

Step 1: Create a scatterplot.

First, we need to create a scatterplot. Go to theÂ ChartsÂ group in theÂ InsertÂ tab and click the first chart type inÂ Scatter:

A scatterplot will automatically appear:

Step 2: Add a trendline.

Next, we need to add a trendline to the scatterplot. To do so, click on any of the individual points in the scatterplot. Then, right click and selectÂ Add Trendlineâ€¦

A new window will pop up with the option to specify a trendline. ChooseÂ PolynomialÂ and choose the number youâ€™d like to use forÂ Order. We will use 3. Then, check the box near the bottom that saysÂ Display Equation on chart.Â

A trendline with a polynomial regression equation will automatically appear on the scatterplot:

Step 3: Interpret the regression equation.

For this particular example, our fitted polynomial regression equation is:

y = -0.1265x3 + 2.6482x2 â€“ 14.238x + 37.213

This equation can be used to find the expected value for the response variable based on a given value for the explanatory variable. For example, suppose x = 4. The expected value for the response variable, y, would be:

y =Â -0.1265(4)3 + 2.6482(4)2 â€“ 14.238(4) + 37.213 =Â 14.5362.