Last Update: 10/13/2016
You can get an analytical solution of an equation if the equation has multiple linear terms. Instead of using the NLFit tool to get an iterative solution, you can treat the linear terms as different independent variables (such as , etc.) and use the Multiple Linear Regression tool to the get the analytical solution. The key is to create several new columns in the worksheet and fill data into them according to the linear terms of the function and then to perform multiple linear regression on the new data.
Suppose you want to get the analytical solution to the following function:
The function can be viewed as:
where and .
We need to add two new columns and fill them with data according to the two terms , respectively. Then regression with multiple linear terms should be performed to get an analytical solution. The detailed steps are as follows:
Keywords:regression, fitting, multiple linear regression, analytical solution, iterative solution