# 4-parameter fit

=?Utf-8?B?Sm9lIE5ld2NvbWU=?=
Guest
Posts: n/a

 16th Mar 2004
Just wondering if anyone knows a way to add a 4-parameter fit to a curve in Excel. Any help would be greatly appreciated. Thanks.

Tushar Mehta
Guest
Posts: n/a

 16th Mar 2004
What is a four parameter fit? Is it like the real estate example in XL
help for the LINEST function? Or is it like
http://www.stfx.ca/people/bliengme/E...Polynomial.htm ?
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <25B1E11B-94AB-414E-91A3-(E-Mail Removed)>,
(E-Mail Removed) says...
> Just wondering if anyone knows a way to add a 4-parameter fit to a curve in Excel. Any help would be greatly appreciated. Thanks.
>

Jerry W. Lewis
Guest
Posts: n/a

 17th Mar 2004
Depends on what 4-parameters you want to fit. The 4 coefficients of a
cubic polynomial can be fit with LINEST. If the equation is not linear
in the unknowns (such as a 4-parameter logistic), then you could use
Solver to find the parameters that minimize the sums of squares.

Jerry

Joe Newcome wrote:

> Just wondering if anyone knows a way to add a 4-parameter fit to a curve in Excel. Any help would be greatly appreciated. Thanks.

New Member
Join Date: Nov 2009
Location: \./
Posts: 1

 7th Nov 2009
4 parameters in typical biological systems of curve fitting are:

(1) TOP (highest value) -- This could be dervied from using an asymptote value
(2) BOTTOM (lowest value) -- This could be dervied from using an asymptote value
(3) SLOPE of the line connecting top and bottom (Often used as Hill Slope)
(4) CONSTANT or EC50 value

Graphpad should do something for allowing more users in Asian countries make software available for day's salary (3 dollars), otherwise Rapidshare is easy way to get access to Graphpad (or other software).

I do support software piracy on economic status mitigation.

New Member
Join Date: Aug 2010
Posts: 1

 5th Aug 2010
The 4 Parameter Logistic (4PL) nonlinear regression model is commonly used in bioassay or immunoassay analysis such as ELISA or dose-response.

It's key characteristics are:
• Symmetric - The sigmoidal curve that the 4PL generates is symmetric around the inflection point.
• Monotonic - The function is either always increasing or decreasing.
Here is a blog post I've written that explains the 4 Parameter Logistic model equation in more detail with pictures =)

Allen Liu
MiraiBio

New Member
Join Date: Aug 2010
Posts: 2

 8th Aug 2010
Here is a link to a file that I have on google docs available to everyone. It has 4 parameter curve fitting that's ideal for ELISAs. Fit the curve to the data either manually or by using solver. You can also calculate unknown samples

New Member
Join Date: Apr 2012
Location: The Netherlands
Posts: 1

 18th Apr 2012
Quote:
 Originally Posted by =?Utf-8?B?Sm9lIE5ld2NvbWU=?= Just wondering if anyone knows a way to add a 4-parameter fit to a curve in Excel. Any help would be greatly appreciated. Thanks.
I haver recently come across a 4PL fit in excel at www.ivdtools.com

New Member
Join Date: Aug 2010
Posts: 2

 18th Apr 2012
(or google joseph couto antibody engineering)
Scroll to the bottom and click the yellow button "view full profile" and then scroll again to the bottom of my profile. I got two excel files there and the 4-parameter curve fitting is one of them.

 Thread Tools Rate This Thread Rate This Thread: 5 : Excellent 4 : Good 3 : Average 2 : Bad 1 : Terrible

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are Off Forum Rules

 Similar Threads Thread Thread Starter Forum Replies Last Post BlueWolverine Microsoft Excel Misc 2 26th Oct 2009 08:00 PM Gigi Microsoft Excel Charting 1 20th Jun 2009 08:32 AM =?Utf-8?B?Y2hlbmtlMDE=?= Microsoft Excel Worksheet Functions 2 26th Jul 2007 01:54 PM =?Utf-8?B?dG9wX2tpY2s=?= Microsoft Powerpoint 0 18th Oct 2006 06:49 PM Lisa Windows XP Help 6 9th Sep 2006 05:25 AM

Features