Researchers are investigating the properties of a test for hypertension

sensitivity-and-specificity-calculator.xlsx

Sheet1

If you are viewing this in Google Docs, press "Edit Online" to modify the spreadsheet
	Calculate Sensitivity, Specificity, PPV, and NPV				Hypertensive		Total
c					Present	Absent
d	Enter:		Test Outcome	Positive	84	92	176
e	Positive			Negative	16	308	324
	True positive	84		Total	100	400	500
	False negative	16
	Negative
	False positive	92
	True negative	308
	Output: (do not edit fields below)
	Sensitivity	84.00%
	Specificity	77.00%
	Positive predictive value	47.73%
	Negative predictive value	95.06%