2.3 Constrained Multiple Regression (Pro)

Constrained-Multiple-Regression

Summary

The app Constrained Multiple Regression is used to perform constrained multiple regression and solve constrained linear least-squares problems.

Tutorial

1. Start this tutorial with the app Constrained Multiple Regression installed. If you have not installed this app, please click Add Apps button in Apps Gallery to open App Center to search and install the app.

   

2. With a new worksheet, select Data>Connect To File: Text/CSV to import the sample file "<Origin Program Folder>\Samples\Curve Fitting\Multiple Linear Regression.dat" into the worksheet with the default import settings.

   

3. Click the app icon Constrained Multiple Regression in App Gallery to open the app dialog. Select col(D) as Dependent Data and col(A)~col(C) as Independent Data.

   

4. Now, we are going to specify the bounds and linear constraints:
   • Expand the branch Bounds, click the check box Same for All Bounds to set same bound for all parameters. Enter -0.5 for Lower Bound and 2.5 for Upper Bound.
   • Expand the branch General Linear Constraints, set Number of Constraints to 1; in the Constraints No.1 sub-branch, enter the expression 0.5*a0+3*a1-0.9*a2+1.5*a3 into Constraints Expression and set 6 for the following Upper Bound.

   

5. Click OK button to perfrom the regression. You will get a report sheet "CMR1" and a result sheet "CMRCurve1".