Microsoft Solver

S

scantor145

Can the MS Solver Add-in program be used to perform nonlinear regressio
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 availabl
programs for Excel that can do the job
 
J

Jerry W. Lewis

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
 
Top