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.
Make sure your group of data is displayed in a clean and tidy manner.
Select the entire data cell, choose ‘Insert’, and select ‘Scatter’.
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’.
Next, we will customise the trendline with the following settings.
Once you are done editing and customizing the scatter plot, it will look something like this.