Re: Positive regression co-efficients

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jerry W. Lewis (post_a_reply_at_no_e-mail.com)
Date: 02/25/04 

Date: Wed, 25 Feb 2004 14:07:58 GMT

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

H Miller wrote:

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

Quantcast