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.

These files on Github  
ELISA-Logit-V01Jul2018 Latest version with spline.
< and > based on concentration of the calibration curve instead response
Manual in Dutch and English as Docx As PDF
Handleiding_Logit_in_Excel.pdf Manual in Dutch
   
Older versions  
ELISA-logit21042005 First validated program
ELISA-Logit-V04apr2007 V21042005 --> V04apr2007 absorbance file input directly from two types of ELISA-readers.
ELISA-Logit-V25Oct2009 V04apr2007 --> V25Oct2009 Corrected some type errors in text
ELISA-Logit-V01Sept2012-Beta

Added logit log graph. Corrected minor issues

ELISA-Logit-V03Feb2013_1.xls V03Feb2013_1. Small bug that data in matrixresult are sorted after "Sort on name".
ELISA-Logit-V24May2017.xlsm < and > results based on the average respons
   

Linearity.xlsx

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

<-- Back to calibration programs


This page was revised 20 may 2020 by Ed Nieuwenhuys