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.
