How to Perform Nonlinear Regression in Excel

In this tutorial, you will learn how to perform Nonlinear Regression in Excel.

In statistics, nonlinear regression is a type of regression analysis in which observational data are represented by a function that depends on one or more independent variables and is a nonlinear combination of the model parameters. In order to fit the data, a method of sequential approximations is used.

Once you are ready, we can get started by using real-life scenarios to help you understand how to perform Nonlinear Regression in Excel.

Nonlinear Regression in Excel

Before we begin we will need a group of data to be used to perform Nonlinear Regression in Excel.

Step 1

Make sure your group of data is displayed in a clean and tidy manner.

Step 2

Select the entire data cell, choose ‘Insert’, and select ‘Scatter’.

Step 3

Next, we will need to add a trendline. To do so you press ‘Chart Deisgn’, then select ‘Add Chart Elements’, then select ‘Trendline’, and select ‘More Trendline Options’.

Step 4

Next, we will customise the trendline with the following settings.

Step 5

Once you are done editing and customizing the scatter plot, it will look something like this.