4-parameter fit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
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

Use Graphpad for ease. Academic license and student licenses are, while not affordable in Asian countries,affordable for Western Europe, Canada and US.

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.
 
4 Parameter Logistic

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
 
Back
Top