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.

Table of Contents

## 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.