Analyse-it logo
Analyse-it logo Analyse-it logo
  • Products

    Editions

    Standard Edition Standard US$ 155/yr The statistics behind most research. Included in every edition.
    • ANOVA
    • Contingency tables
    • Correlation
    • Descriptive statistics
    • Hypothesis tests
    • Logistic regression
    • Principal component analysis
    • Regression
    Quality Control Improvement Quality Control US$ 290/yr For monitoring a process over time and detecting when it changes.
    • Control charts
    • Pareto analysis
    • Process capability
    MEdical Edition Medical US$ 340/yr For biomedical and clinical research.
    • Bland-Altman agreement
    • Diagnostic accuracy
    • Reference intervals
    • Survival analysis
    Method Validation Edition Method Validation US$ 475/yr For establishing and verifying how a measurement method performs.
    • Bland-Altman agreement
    • Deming regression
    • Detection capability
    • Diagnostic performance
    • Linearity
    • Measurement system analysis
    • Method comparison
    • Passing-Bablok regression
    • Precision
    • Reference intervals
    Ultimate Icon Ultimate US$ 575/yr For laboratories that do method validation and quality control.

    All features from every edition in a single licence.

    Solutions

    • IVD manufacturers
    • Clinical laboratories
    • Analytical & testing laboratories
    • Biomedical & clinical research
    • Manufacturing & process quality

    Case studies

    • EOC
    • National reference laboratory

    Validation and accuracy

    • How we develop and validate Analyse-it
    • NIST StRD numerical accuracy benchmarks
    Upgrade or renew Resellers
    Compare editions
  • Pricing
  • Learn

    Guides

    Start here

    • I am bringing a method into service
    • I do not know whether I am validating or verifying
    • I have data and do not know which test to use
    • I have the results and have to write them up
    • I need to put a process under control

    Method validation

    • Getting started
    • Precision & verification
    • Detection & measuring range
    • Method comparison & agreement
    • Total error & performance goals
    • Regulation & accreditation
    • Reference intervals

    Diagnostic & clinical

    • Diagnostic performance
    • Survival analysis

    Quality control

    • Quality control & SPC

    General statistics

    • Statistics fundamentals
    • ANOVA & multiple comparisons
    • Regression & multivariate
    Blog
    All 70 guides
  • Support

    Support

    Example analyses Fifty worked analyses, each with the data behind it.
    Download the latest version Licensed users — enter your product key to get version 6.23.1. Release history, and older versions →
    Analyse-it not starting? Run the trouble-shooter. It tries the common fixes.
    Knowledge base Licensing, the free trial, installation and validation, answered.
    Contact support Your message goes to the people who build Analyse-it.
    Consultancy & training Courses and consultancy from independent specialists.

    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
    • Measurement systems analysis (MSA)
    • Reference interval
    • Diagnostic performance
    • Survival & reliability
    • Control charts
    • Process capability
    • Pareto analysis

    Getting started with Analyse-it

    • Tutorials

    User guide

    • Preparing data for analysis
    • Creating an analysis
    • Recalculating an analysis

    Installers & administrator’s guide

    • System requirements
    • Installing the software
    • Deploying to many computers, or to every user
    • Activating a license
    • Moving a license to another computer
    • Using a concurrent-user license
    • Updating the software
    • Troubleshooting

    Validation and accuracy

    • How we develop and validate Analyse-it
    • NIST StRD numerical accuracy benchmarks
    Complete guide (PDF)
    All support & documentation
  • About us
Download trial

13-May-2020 COVID-19: Calculating the detection limit for a SARS-CoV-2 RT-PCR assay using Analyse-it

Method validation Statistics Using Analyse-it

Recent improvements to the Analyse-it Method Validation edition, in version 5.50 and later, include the addition of probit regression. Probit regression is useful when establishing the detection limit (LoD) for an RT-qPCR assay.

The CLSI EP17-A2: Evaluation of Detection Capability for Clinical Laboratory Measurement Procedures protocol provides guidance for estimating LoD and is recognized by the FDA. In this blog post, we will look at how to perform the relevant part of the CLSI EP17-A2 protocol using Analyse-it.

For details on experimental design, see section 5.5 in the CLSI EP17-A2 guideline. In Analyse-it, you should arrange the data in 2 columns: the first should be the concentration, and the second should be the result, positive or negative. You should have a minimum of 20 replicates at each concentration. We have put together a hypothetical example in the workbook COVID-19 Detection Limit.xlsx which you can use the follow the steps below:

To Analyse-it:

  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 Result variable, and then in the Event drop-down list, select the Positive state (1).
  4. In the X drop-down list, select the RNA variable, and then click the drop-down menu icon next to the variable drop-down, and in the Transform drop-down list, select Log 10.
  5. In the Plot drop-down list, select Scaled - X against Y to show the X axis as a logarithmic scale.
  6. Clear the Individual check-box, and select the Aggregate check-box.
  7. On the Analyse-it ribbon tab, in the Fit Model group, click Predict, and then click X given Probability.
  8. On the analysis task pane, on the Fit panel, next to the Predict X given Probability, click More…, and then on the Predict X given Probability panel, click Add and select LoD=95%.

    NOTE: If using Analyse-it pre-version 5.65, on the Fit panel, in the Predict X given Probability edit box, type 0.95.

  9. Click Calculate.
  10. The analysis report shows the probit regression fit:

    Probit regression limit of detection

    The Predict X for given Probability section shows the limit of detection (LoD) as the point where the probability of a positive result is 95%.

    For more information, see the online documentation:
    Estimating the detection limit using a probit fit

Previous post
COVID-19: Calculating PPA/NPA agreement measures using Analyse-it
Next post
Analyse-it 5.50 to 5.65: Recent improvements

Comments

Comments are now closed.

Tags

  • All (65)
  • Business (10) 
  • Case studies (2) 
  • Excel (6) 
  • In development (16) 
  • Method validation (19) 
  • Plots (2) 
  • Press releases (1) 
  • Publications (1) 
  • Releases (35) 
  • Statistics (17) 
  • Using Analyse-it (31) 

Latest posts

  • A New Year. A New Edition.
  • Analyse-it v6.10: Survival Analysis and other improvements
  • Analyse-it v5.90: Support for the updated CLSI EP6-Ed2 protocol and inverse predictions
  • Analyse-it 5.50 to 5.65: Recent improvements
  • COVID-19: Calculating the detection limit for a SARS-CoV-2 RT-PCR assay using Analyse-it
  • COVID-19: Calculating PPA/NPA agreement measures using Analyse-it
  • Diagnostic accuracy (sensitivity/specificity) versus agreement (PPA/NPA) statistics
  • COVID-19: Establishing the diagnostic accuracy (sensitivity/specificity) of a test using Analyse-it
  • Why the diagnostic test 'accuracy' statistic is useless
  • Sensitivity/Specificity and The Importance of Predictive Values for a COVID-19 test

Most popular posts

  • Announcing the Analyse-it Quality Control & Improvement Edition
  • Analyse-it 4.0 released: Support for CLSI guidelines, and Measurement Systems Analysis
  • Analyse-it 3.80 released: Principal Component Analysis (PCA)
  • Recent improvements in Analyse-it 3.76 and our first video tutorial!
  • Our software development and validation process
  • The numerical accuracy of Analyse-it against the NIST StRD
  • Quantiles, Percentiles: Why so many ways to calculate them?
  • Handbook of Parametric & Non-parametric Statistical procedures
  • A sombre note: Professor Rick Jones
Products
  • All editions
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Solutions
  • IVD manufacturers
  • Clinical laboratories
  • Analytical & testing laboratories
  • Manufacturing & process quality
  • Biomedical & clinical research
Learn
  • All guides
  • Choosing a statistical test
  • Method validation roadmap
  • Choosing a method comparison
  • ROC curves & diagnostic performance
  • Choosing a control chart
Support
  • Support centre
  • Tutorials
  • Knowledge base
  • Numerical accuracy
  • Download latest version
  • Release history
Company
  • About us
  • Published research
  • Contact us
  • Development & validation
  • Blog
  • Privacy policy

Get started

  • Download free trial
  • Sign In

© 2026 Analyse-it® Software, Ltd. All rights reserved.
GBLeeds, United Kingdom · Founded 1997 · Registered in England & Wales, company no. 3022685
support@analyse-it.com

Statistical analysis, method validation, diagnostic performance and quality control software for Microsoft Excel.

We value your privacy

We use essential cookies to run the site. With your permission we'd also like to use analytics and advertising cookies to see how visitors find and use Analyse-it, so we can keep improving it and reach more people like you.

You can change your mind at any time, see our Privacy policy.