Skip to content

Logit regression in Excel

Ed Nieuwenhuys edited this page Jun 17, 2024 · 1 revision

Welcome to the ELISA-logit-regression wiki!

Logit regression in Microsoft Excel is especially designed for ELISA-tests and RIA's.

The logit regression is suitable for calculating a sigmoidal (S-shaped) curve, up to an almost straight line, through data pairs.

This form of calibration line occurs with dose-response curves that approach asymptotically to a maximum response. With the calculated parameters of the regression line, the response and the dilution of the unknown sample, the dose in a sample is calculated.

An average dose is calculated for multiple measurements of the same sample. Parameters in the worksheet can be used to control the signalling of poor reproducibility of the average, extrapolation of the measurement area, significant digits and the creation of an export file.

This Microsoft Excel program can easily incorporated in a LIMS with its import and export functionality. See also here: https://ednieuw.home.xs4all.nl/Calibration/Logit/Logit.htm

image