2.8 Constrained Multiple Regression (Pro)

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.
    Constrained Multiple Regression 00.jpg
  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.
    Constrained Multiple Regression 01.jpg
  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.
    Constrained Multiple Regression 02.jpg
  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.
    Constrained Multiple Regression 03.jpg
  5. Click OK button to perfrom the regression. You will get a report sheet "CMR1" and a result sheet "CMRCurve1".
    Constrained Multiple Regression 04.jpg