From chemistry-request /at\server.ccl.net Fri Dec  6 00:21:34 2002
Received: from cascara.uvic.ca ([142.104.5.28])
	by server.ccl.net (8.11.6/8.11.0) with ESMTP id gB65LYA23290
	for <chemistry(+ at +)ccl.net>; Fri, 6 Dec 2002 00:21:34 -0500
Received: from [24.65.168.211] ([24.65.168.211])
	by cascara.uvic.ca (8.12.6/8.12.6) with ESMTP id gB65KVJ8267472;
	Thu, 5 Dec 2002 21:21:27 -0800
From: Roy Jensen <royj -A_T- uvic.ca>
To: james.metz %-% at %-% abbott.com
Cc: chemistry-!at!-ccl.net
Subject: Re: CCL:constrained multiple linear regression
Date: Thu, 05 Dec 2002 21:21:58 -0800
Message-ID: <jvc0vu0md04gvrbbj7fttoeg8g7rut9vmt- at -4ax.com>
References: <OF054C59F9.EB41DCF8-ON86256C84.00055726 %-% at %-% northamerica.intra.abbott.com>
In-Reply-To: <OF054C59F9.EB41DCF8-ON86256C84.00055726.,at,.northamerica.intra.abbott.com>
X-Mailer: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-UVic-Virus-Scanned: OK - Passed virus scan by Sophos (sophie) on cascara
X-Scanned-By: MIMEDefang 2.19 (www . roaringpenguin . com / mimedefang)
Content-Transfer-Encoding: 8bit
X-MIME-Autoconverted: from quoted-printable to 8bit by server.ccl.net id gB65LYA23291

Excel does multiple linear regression with the LINEST function (from
the Insert:Function menu). It isn't obvious that it will work from the
description. I can fax you (and everyone else who is interested) the
pages from our lab-manual that explains the procedure.

In reading your request, I noticed that you need to impose
constraints. To apply constraints, use the Solver add-in.

NOTE: LINEST is a linear regression method (analytical solution)
whereas Solver is a non-linear algorithm (numeric). Solver can, and
does, converge to local minima.

Roy Jensen

-----BEGIN PGP PUBLIC KEY BLOCK-----
Comment: available at www.consol.ca

------END PGP PUBLIC KEY BLOCK------



On Mon, 2 Dec 2002 19:08:14 -0600, you wrote:

> CCL,
> 
>         I am looking for software (preferably free or inexpensive, code is 
> OK) that will allow me to perform
> constrained multiple linear regression.  For example, I have an equation 
> of the form:
> 
>         Y = a*X1 + b*X2 + c*X3 + d
> 
>         where: Y is the dependent variable
>                   X1 - X3 are independent variables (more than 1)
>                 a, b, c are coefficients
>                         d is a constant
> 
>         I must be able to constrain the range of values for a, b, c, and d 
> during the fitting.
> 
>         Please note that programs such as JMP, KalediaGraph, GraphPad 
> Prism, and several other packages do 
> NOT allow the user to do this, especially for more than one independent 
> variable.
> 
>         Can someone suggest a program or code to do this?
> 
>         Thank you,
>         Jim Metz
> 
> 
> James T. Metz, Ph.D.
> Research Investigator Chemist
> 
> GPRD R46Y AP10-2
> Abbott Laboratories
> 100 Abbott Park Road
> Abbott Park, IL  60064-6100
> U.S.A.
> 
> Office (847) 936 - 0441
> FAX    (847) 935 - 0548
> 
> james.metz $#at#$ abbott.com