2x2 Contingency Table for Medical Screening
Click on the image below for the contingency table spreadsheet. When the spreadsheet appears, remember to check out the sheet labeled "Reference." You'll find that tab at the bottom of spreadsheet.
The spreadsheet is set to "view only" which means you can't make changes to it. I definitely am not letting anyone fiddle around with! So I suggest opening a Google spreadsheet of your own on Google Drive and copying my sheet to yours. You can use the contingency table after that. Just don't alter any formulas in the cells unless you know what you're doing.
Numerical values that do need user input are in cells with a bright yellow background.
An older contingency table spreadsheet is located here and is used by my blog post on human pregnancy tests and a subsequent follow-up post.