ABCDEFGHIJKLMNOPQRSTUVWXYZAAAB
1
Calculate the Probability that 1 Person (or more) is Infected in Group of Size n
2
Created by:Dr. Jeff Gilchrist
3
Last updated:January 3, 2022
4
5
For more details on these calculations please see:
6
For an index of my COVID-19 related articles see:
7
https://blogs.scientificamerican.com/observations/online-covid-19-dashboard-calculates-how-risky-reopenings-and-gatherings-can-be/
8
Inspired by Ryan Imgrund's probabilty reports:
9
For more daily COVID-19 related statistics and graphs:
http://gilchrist.ca/jeff/COVID-19/
http://gilchrist.ca/jeff/COVID-19/vaccine.html
http://gilchrist.ca/jeff/COVID-19/Ottawa.html
10
11
Formula:
Where p is the per-person probability of being infected, and n is the size of the group
12
13
14
# Active COVID-19 Cases (Ottawa):8952Get latest from:
https://www.ottawapublichealth.ca/en/reports-research-and-statistics/daily-covid19-dashboard.aspx
15
Population (Ottawa):1006210See:
https://ottawa.ca/en/city-hall/get-know-your-city/statistics-and-economic-profile/statistics/current-population-and-household-estimates
16
Population (Ontario):14745040Q2 2020 See:
https://www150.statcan.gc.ca/t1/tbl1/en/tv.action?pid=1710000901
17
Seroprevalence (Ontario):1.2%October 31, 2020 data:
https://www.publichealthontario.ca/en/data-and-analysis/infectious-disease/covid-19-data-surveillance/covid-19-serosurveillance
18
Ottawa Cases on October 31, 2020:7000See:
https://open.ottawa.ca/datasets/covid-19-cases-and-deaths-in-ottawa
19
Ontario Cases on October 31, 2020:75730See:
https://data.ontario.ca/dataset/status-of-covid-19-cases-in-ontario
20
Seroprevalence Factor (Ontario):2.33646480919
21
Per-person probability (p):0.00889675118
Lower Bound: only known active cases from positive tests, best case scenario, doesn't account for those infected who never got tested
22
Seroprevalence (Ontario factor) per-person prob. (p):0.02078694604
Seroprevalence (Ontario factor): active cases + factor for 1.2% prevalence of COVID-19 in Ontario via antibody blood tests, best estimate for real # of infections in a city
23
24
Group Size (n)
Lower Bound (Active Cases)
Active + Seroprevalence (1.2%)
25
108.5%18.9%
26
1512.5%27.0%
27
2520.0%40.9%
28
5036.0%65.0%
29
10059.1%87.8%
30
25089.3%99.5%
31
50098.9%100.0%
32
1000100.0%100.0%
33
2000100.0%100.0%
34
5000100.0%100.0%
35
36
Note: Feel free to make a copy of this spreadsheet and change the # active cases, population, seroprevalence, and group sizes for your area and calculate what you are interested in knowing.
37
You can do this by selecting "File -> Make a copy" within Google Sheets which will let you edit the values.
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