A logit regression program in Microsoft Excel

<-- Back to calibration programs

The program can be used for fitting sigmoid, half-sigmoid curves and even straight lines.
This logit regression program in Excel is optimised to work with ELISA-data.
It is also very easy to use with lists like counts from radio immuno assays (RIA).
The ELISA-logit worksheet can be adapted to be used with a LIMS; it supports input and output files.

Read the instructions in the sheet "Instructions" in the XLS-worksheet.
Several options can be set:
- the number of significant digits in the result,
- warning limit when signaling VC% of end result is above limit,
- extrapolation options,


Advise (rules of thumb):
Do not use more than 5 doses and a blank. (This logit needs a blank! (zero dose)).
If you want to use more data points invest in multiplos instead of more doses.
The lowest response of the calibration line must be higher than 6-10 times the standard deviations of the noise in your blank.
The highest response of your curves should be 10% higher in response than the second highest response.
Do not copy, move and paste in the worksheet.
If the program does not work properly use a new empty copy of it.
Enable macro's to run the program!

Several versions of the Logit program in an Excel-sheet are available.
The difference between version 2017 and 2018 is the calculation of the <result and >result.
In the 2017 and older versions the presentation of a <result of >result is based on the response (absorbance).
The 2018 version uses the values of the lowest and highest concentration of the calibration line.
Especially for validation purposes it is difficult to explain why lower and upper limits changes with every test.

Linearity.xlsx

These programs can be used for non-profit purposes (Copyright 1998-2022)

<-- Back to calibration programs

This page was revised 20 july 2022 by Ed Nieuwenhuys