Statistics add-in software for statistical analysis in Excel
  • Statistical Reference Guide
  • Measurement systems analysis (MSA)
  • Detection capability

Estimating the detection limit using a probit fit

Fit a probit regression model to estimate the limit of detection.

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Fit Model, and then click Probit.
    The analysis task pane opens.
  3. In the Y drop-down list, select the binary response variable.
  4. In the Event drop-down list, select the positive outcome.
  5. In the X drop-down list, select the level variable.
  6. Next to the X drop-down list, click the drop-down menu, and then in the Transform drop-down list, select Log 10
  7. In the Plot drop-down list, select Scaled - X against Y.
  8. Clear the Individual check box, and select the Aggregate check box.
  9. On the Analyse-it ribbon tab, in the Fit Model group, click Predict, and then click X given Probability.
  10. On the analysis task pane, in the Fit panel, in the Predict X given Probability edit box, type 0.95
  11. Click Calculate.
On the analysis report, in the Predict X for Given Probability section, the predicted level at 0.95 probability is the limit of detection.
Related concepts
Limit of detection (LoD)
Available in Analyse-it Editions
Method Validation edition
Ultimate edition

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Statistical Reference Guide
  •  Distribution
  •  Compare groups
  •  Compare pairs
  •  Contingency tables
  •  Correlation and association
  •  Principal component analysis (PCA)
  •  Factor analysis (FA)
  •  Item reliability
  •  Fit model
  •  Method comparison / Agreement
  •  Measurement systems analysis (MSA)
  •  Precision
  •  Trueness
  •  Detection capability
  •  Limit of blank (LoB)
  •  Limit of detection (LoD)
  •  Estimating the detection limit of a measurement system
  •  Estimating the detection limit using a precision profile
  •  Estimating the detection limit using a probit fit
  •  Limit of quantitation (LoQ)
  •  Study design
  •  Reference interval
  •  Diagnostic performance
  •  Survival/Reliability
  •  Control charts
  •  Process capability
  •  Pareto analysis
  •  Study Designs
  •  Bibliography



Version 6.15
Published 18-Apr-2023
statistics software, statistical software for Excel
  • Products
  • Store 
  • Support
  • Blog
  • About us
  • Download trial
  •  Search
  •  Sign in
  •  Contact us
Analyse-it editions
  • Standard edition
  • Medical edition
  • Method Validation edition
  • Quality Control & Improvement edition
  • Ultimate edition

  • Blog  
  • About us
  • Contact us  
  • Privacy policy


Copyright 2026 Analyse-it Software, Ltd, Leeds, United Kingdom .
We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.