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.

General

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:

• Bioassay Analysis with the Five Parameter Logistic (5-PL) Non-Linear Regression Curve-Fitting Model
• The importance of weighting with the 4PL and 5PL

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.

Blog index

Atom newsfeed

Comments

Post date

Fri 3 Jan 2014

Tags

Share

Recent posts

Exit ThinkPad T430s, enter ThinkPad T480s

Linux and VirtualBox on a T480s with high-resolution display

What I like and dislike about Ubuntu 18.04

Excel Blogs