ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
This workbook supports the paper, "A Covid-19 Teaching Example: Pooled Testing with Microsoft Excel"
2
3
Here is a description of each sheet:
4
5
DGP is what is produced by following the steps in the paper. It is the end product.
6
If you scroll to column AA you will see an idea for using Solver to find the optimal group size.
7
I decided not to do this, but it does work. Data --> Solver shows how.
8
9
LearnList is Figure 3 in the concluding section of the paper.
10
11
Analytical works out the analytical solution for the expected number of tests as a function of group size and the infection rate.
12
It is beyond my target introductory audience, but you can certainly share it with advanced students.
13
It confirms the simulation results and contains the data for Figures 1 and 2 in the paper.
14
The Lambert W function is kinda nifty, IMHO.
15
16
DiscussionQuestions has a few questions for a class discussion or maybe a small-group breakout room.
17
18
Q&A has questions and suggested answers for a homework or other assignment.
19
20
NYT is the article that gave me the idea to do this.
21
22
Biblio has links to other articles and papers.
23
24
MCSimCheck was an early sim (using the MCSim add-in) that confirmed my analytical results.
25
The MCSim add-in is here:
http://www3.wabash.edu/econometrics/EconometricsBook/Basic%20Tools/ExcelAddIns/MCSim.htm
26
If I used this instead of the Data Table, I could have greatly increased the number of repetitions to find the optimal group size for IR=1%.
27
The trade-off is that you have to explain add-ins, then download and install it. It did not seem worth it to me.
28
29
If you have any questions, corrections, or suggestions, please let me know.
30
Humberto Barreto
31
hbarreto@depauw.edu
32
25-Aug-2020
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