Negative Predictive Value Calculator
Instructions: This Negative Predictive Value Calculator computes the negative predictive value (NPV) of a test, showing all the steps. Please provide the information required to fill out the 2x2 table below with the information about disease presence and absence, and screening test status:
More about this Negative Predictive Value Calculator
The Negative Predictive Value a test (NPV) corresponds to the probability that a patient does not have the disease, given that the patient tests negative.
How do you compute the Negative Predictive Value of a test?
Consider the following 2x2 crosstabulation about the results of the screening test and presence of the disease:
• The value \(TP\) corresponds to the number of true positive cases, which is when the test shows positive for patients with the condition.
• The value \(FP\) corresponds to the number of false positive cases, which is when the test shows positive for patients who don't have the condition.
• The value \(FN\) corresponds to the number of false negative cases, which is when the test shows negative for patients with the condition.
• The value \(TN\) corresponds to the number of true negative cases, which is when the test shows negative for patients who don't have the condition.
Since \(TN + FN\) is the total number of those who test negative, the negative predictive value of the test is
\[\text{NPV} = \displaystyle \frac{TN}{TN + FN}\]What are other related metrics to negative predictive value (NPV)?
When working with the characteristics of a test, you probably are going to be interested in knowing about the specificity of the test , the sensitivity of the test , as well as the positive predictive value (PPV).
How to calculate sensitivity and specificity, PPV and NPV using Excel
You need to follow the same calculation formula used above to compute the sensitivity and specificity of a test in Excel. First, you need to put the elements in the crosstabulation form specified above.
