Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Solver does not work from Macros | Setting up and Configuration of Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Excell VS Office | Excel Discussion (Misc queries) | |||
Using Solver with VBA | Excel Discussion (Misc queries) | |||
Solver Adds in Microsoft Edition 2003 (student version) | New Users to Excel |