contingency by xuyuzhu

VIEWS: 2 PAGES: 4

									Guidelines

Sheet 1 allows you to complete a 2x2 contingency table and will give values of prevalence, sensitivity, specificity, LR+, LR-, an
Sheet 2 allows you to give a population size, prevalence, sensitivity and specificity, and will then populate the table and calcu
Grey boxes indicate where numbers can be inserted
Group sizes are in whole numbers; results are expressed as proportions not percentages
Some rounding is used in sheet 2 which may give slightly inconsistent appearing results at times; at most the error should be
sensitivity, specificity, LR+, LR-, and OR
then populate the table and calculate the other statistics


mes; at most the error should be 1 in any group
Results from a contingency table

                      Condition
                      Positive  Negative
           Positive                            0
Test       Negative                            0
                                 0         0   0

Prevalence:            #DIV/0!
Sensitivity:           #DIV/0!
Specificity:           #DIV/0!
PPV:                   #DIV/0!
NPV:                   #DIV/0!
Positive LR:           #DIV/0!
Negative LR:           #DIV/0!
OR                     #DIV/0!
Results from a prevalence

                      Condition
                      Positive Negative
           Positive            0        0   0
Test       Negative            0        0   0
                               0        0

Prevalence:
Sensitivity:
Specificity:
PPV:                   #DIV/0!
NPV:                   #DIV/0!
Positive LR:               0.00
Negative LR:           #DIV/0!
OR                     #DIV/0!

								
To top