*56*

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.1265x^{3} + 2.6482x^{2} â€“ 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**.