Probability an infected person would be in crowds of various sizes
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This spreadsheet simply calculates the probability that at least one person infected with Covid-19 is in a crowd of a given size, assuming a community infection rate.
2
Assuming crowd members aren't psychopaths or idiots, the appropriate infection rate is for people who do not yet know that they are infected.
3
It is important to note that nobody knows what that rate is so it's just a tool to test the implications of your assumptions.
4
The calculation also assumes that the people who show up are a random subset of the population whose infection probabilities are independent.
5
In other words, it does not apply to a group of 20 people stepping off a cruise ship or arriving from the same province in Italy.
6
7
What is likelihood someone infected with COVID-19 is at your event?
8
Probability that at least one participant is infected as function of number of participants and community infection rate
9
Undetected community infection rate is 1 in …
10
Expressed as Percent# of participants
11
10301002501,00035,000
12
1,000,0000.0001%0.00%0.00%0.01%0.02%0.10%3.44%
13
100,0000.001%0.01%0.03%0.10%0.25%1.00%29.53%
14
10,0000.01%0.10%0.30%1.00%2.47%9.52%96.98%
15
1,0000.1%1.00%2.96%9.52%22.13%63.23%100.00%
16
1001.0%9.56%26.03%63.40%91.89%100.00%100.00%
17
1010.0%65.13%95.76%100.00%100.00%100.00%100.00%
18
520.0%89.26%99.88%100.00%100.00%100.00%100.00%
19
User can change highlighted cells2.540.0%99.40%100.00%100.00%100.00%100.00%100.00%
20
21
22
FYI, the formula is 1 - (1-p)^n, where p is the community infection rate (column c) and n is the number of participants (row 11). (1-p)*n is the probability that nobody is infected. So 1 - (1-p)^n is the probability that at least one person is infected. You could also figure the probability distribution for the number of infected people, but that is a more complex calculation.
23
24
Source: Len Burman (who is not an epidemiologist or infectious disease expert, but does know some probability and statistics)
25
@lenburman
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100