Microsoft Solver
 

Can the MS Solver Add-in program be used to perform nonlinear regression
on the folowing four parameter logistic equation:

R = R0 + KC * 1/1 + exp(-(a + b * lnC))

where R0, KC, a and b are the parameters?

Never used Solver before and would appreciate any help or guidance.

Alternaely, are there any other add-in or non-commercially available
programs for Excel that can do the job?


--
scantor145
------------------------------------------------------------------------
scantor145's Profile: http://www.excelforum.com/member.php...o&userid=14766
View this thread: http://www.excelforum.com/showthread...hreadid=511705

Microsoft Solver
 

Of course. Put trial values for the parameters into a block of cells and
write the formula for R in terms of those cells. Then in another cell
calculate the sum of squared deviations between the actual and formula values
of R. Use Solver to minimize that sum of squared deviations by changing the
trial parameter values.

Is your equation written properly? As you posted it, it reduces to
R = R0 + KC + exp(-(a + b * lnC))

Jerry

"scantor145" wrote:

Can the MS Solver Add-in program be used to perform nonlinear regression
on the folowing four parameter logistic equation:

R = R0 + KC * 1/1 + exp(-(a + b * lnC))

where R0, KC, a and b are the parameters?

Never used Solver before and would appreciate any help or guidance.

Alternaely, are there any other add-in or non-commercially available
programs for Excel that can do the job?


--
scantor145
------------------------------------------------------------------------
scantor145's Profile: http://www.excelforum.com/member.php...o&userid=14766
View this thread: http://www.excelforum.com/showthread...hreadid=511705