How To Do Nonlinear Regression In Excel

Nonlinear regression is a regression technique that is used when the human relationship between a predictor variable and a response variable does not follow a linear design.

The post-obit pace-by-stride instance shows how to perform nonlinear regression in Excel.

Step ane: Create the Data

Showtime, permit's create a dataset to piece of work with:

Footstep 2: Create a Scatterplot

Side by side, let's create a scatterplot to visualize the data.

Start, highlight the cells in the range A1:B21. Next, click the Insert tab along the peak ribbon, and and then click the first plot option under Scatter:

The post-obit scatterplot will appear:

Footstep iii: Add together a Trendline

Next, click anywhere on the scatterplot. Then click the + sign in the meridian correct corner. In the dropdown carte, click the arrow side by side to Trendline and and so click More Options:

In the window that appears to the right, click the button next to Polynomial. So check the boxes side by side to Brandish Equation on chart and Display R-squared value on chart.

This produces the following curve on the scatterplot:

Notation that y'all may need to experiment with the value for the Lodge of the polynomial until you find the curve that best fits the information.

Step 4: Write the Regression Equation

From the plot we can see that the equation of the regression line is equally follows:

y = -0.0048x⁴ + 0.2259x³ – 3.2132x² + 15.613x – 6.2654

The R-squared tells united states the per centum of the variation in the response variable that can be explained by the predictor variables.

The R-squared for this particular curve is 0.9651. This means that 96.51% of the variation in the response variable tin can exist explained by the predictor variables in the model.

Additional Resources

How to Perform Simple Linear Regression in Excel
How to Perform Multiple Linear Regression in Excel
How to Perform Logarithmic Regression in Excel
How to Perform Exponential Regression in Excel