How can I force the coefficients in a multiple linear regression to only be positive.
H H Miller Feb 25, 2004 #1 How can I force the coefficients in a multiple linear regression to only be positive.
J Jerry W. Lewis Feb 25, 2004 #2 You could calculate the sum of squares based on trial estimates in cells. Then use Solver to minimize the sum of squares by changing the estimates with the constraints that the coefficients cannot be negative. Jerry
You could calculate the sum of squares based on trial estimates in cells. Then use Solver to minimize the sum of squares by changing the estimates with the constraints that the coefficients cannot be negative. Jerry
