Positive regression co-efficients

H

H Miller

How can I force the coefficients in a multiple linear regression to only be positive.
 
J

Jerry W. Lewis

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How does Excel calculate Multiple R when doing multiple regression 1
multiple polynomial regression in Excel 4
Automatic Regressions based on Field Values 0
multivariate regression 1
Multiple (as in many) regressions 3
Linear Regresion. Sales By Year. 1
Having trouble using LINEST in Excel 2007 VBA 1
Inverse prediction in regression 3

Top