Statistics add-in software for statistical analysis in Excel

15-Apr-2020 COVID-19: Establishing the diagnostic accuracy (sensitivity/specificity) of a test using Analyse-it

Method validation Statistics Using Analyse-it
In the last couple of blog posts, we’ve covered some of the statistics related to the diagnostic accuracy of COVID-19 anti-body tests. In this post, we will demonstrate how to establish these claims using the Analyse-it Method Validation edition. A useful companion resource for laboratories and diagnostic companies developing qualitative diagnostic tests is CLSI EP12: User Protocol for Evaluation of Qualitative Test Performance.

It is important in diagnostic accuracy studies that the true clinical state of the patient is known. For example, in developing a SARS-CoV-2 anti-body test, for the positive subgroup, you might enlist subjects who had a positive SARS-CoV-2 PCR test and clinically confirmed illness. Then, for the negative subgroup, you might use samples taken from subjects before the illness was in circulation. It is also essential to consider other factors, such as the severity of illness, as they can have a marked effect on the performance characteristics of the test. A test that shows high sensitivity/specificity in a hospital situation in very ill patients can be much less effective in population screening where the severity of the illness is less.

In cases where the true condition of the subject is not known, and only results from a comparative method and a new test method are available, an agreement measure is more suitable. We will cover that scenario in detail in a future blog post.

Statistical analysis of diagnostic test study data

In Analyse-it, there are two ways to arrange your data for this analysis.

Frequency form data summarizes the frequency counts for each combination of true state, test result:

Case form data lists the individual true state and test result for each subject:

You can find examples of both, and follow along with the steps below, using the workbook COVID-19 Diagnostic Accuracy Example.xlsx

To Analyse-it:

  1. Select a cell in the dataset.
  2. On the Analyse-it ribbon tab, in the Statistical Analyses group, click Diagnostic, and then click Binary (Sensitivity / Specificity).
    The analysis task pane opens.
  3. In the True state drop-down list, select the true state variable.
  4. In the Positive event drop-down list, select the state that indicates the presence of the condition of interest.
  5. In the Y drop-down list, select the test variable.
  6. In the Positive event drop-down list, select the state that indicates a positive test.
  7. If the data are in frequency form, in the Frequency drop-down list, select the frequency variable containing the counts.
  8. Select the required statistics Sensitivity/Specificity, Likelihood ratios.
    NOTE: Hover the mouse pointer over an option to see a context-sensitive help pop-up with more information and notes on when to use it.
  9. Click Calculate.

The analysis report shows the sensitivity/specificity and other statistics.

To compute the predictive values given the prevalence of illness in a population:

  1. On the Analyse-it task ribbon tab, in the Diagnostic Accuracy group, click Predictive values.
    The analysis task pane opens, and the Predictive value checkbox is selected.
  2. In the Prior probability edit box, type the prevalence. If you have more than one scenario, click the More button, and then in the Prior probabilities grid, type the prevalences and optional scenario names.
  3. Click Recalculate.

If you have any questions about using the Analyse-it Method Validation edition for diagnostic accuracy studies, please contact us.

For more information, see our online documentation:
Measures of diagnostic accuracy
Estimating the sensitivity and specificity of a binary test

Previous post
Why the diagnostic test 'accuracy' statistic is useless
Next post
Diagnostic accuracy (sensitivity/specificity) versus agreement (PPA/NPA) statistics

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
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.