ELISA curve-fitting

Fitting a curve onto the standards results of an ELISA is not straight-forward. However, Excel can be coerced to perform the curve fitting using the Solver addin. In this blog post I collect some online resources on curve fitting.


Findlay JW, Dillard RF. Appropriate calibration curve fitting in ligand binding assays. AAPS J. 2007;9:E260-E267.

Liao JJZ & Liu R. Re-parameterization of five-parameter logistic function. J. Chemometrics 2009;23:248–253.

Gottschalk PG, Dunn JR. The five-parameter logistic: a characterization and comparison with the four-parameter logistic. Anal Biochem. 2005;343:54-65.

MiraiBio, a company that specializes in curve-fitting, has some very good blog articles on this topic:

Curve-fitting with Excel

The manual way is explained on SharpStatistics.co.uk: “Non Linear Curve Fitting in Excel”.

There is a semi-automated and an automated spreadsheet for Excel by Andreas Swart.

Curve-fitting with the Toolbox

I am hoping to implement a 4-parameter or 5-parameter logistic regression function into the next generation of the XL Toolbox.