Mad Cow Testing

Saving...

| cells cell options

| spreadsheet formula options

Mad Cow Testing-False Positives

Variable	Value Value
1. Cows to be tested	35000000 35,000,000
2. Mad cow prevelance	0.000001 0.00009999999999999999%
3. Accuracy of test	.9999 99.99%


Output
		Actual Condition
		Cow is diseased	Cow is healthy
Test Result	Test says "diseased"	34.9965 34	3499.9964999996146 3,499
	Test says "diseased"	34.9965 34	3499.9964999996146 3,499
	Test says "healthy"	0.0034999999999996145 0	34996465.0035 34,996,465
	Test says "healthy"	0.0034999999999996145 0	34996465.0035 34,996,465

Total tested as "diseased"	3534.9929999996148 3,534
False positive rate (percentage of those tested as "diseased" that are actually healthy cows)	0.9900999803959997 99.00%

Average Rating:

(Not yet rated)

Add Comment

	Number Formatting
		none		1,234 1,234.56 $1,234 $1,234.56		1234 1234.56 25% 25.35%		Currency symbol: Decimal places:

	Row/Column Options
		insert row before insert row after		insert column before insert column after		remove row remove column

	Font Formatting
		B I U		strike a⁺ a^-