Document Type
Article
Publication Date
8-2020
Abstract
This paper uses pooled testing as a teaching example for undergraduate statistics, econometrics, or quantitative methods courses. It offers step-by-step instructions to create an Excel spreadsheet that uses Monte Carlo simulation to find the optimal group size for a given infection rate. A completed version of the spreadsheet, along with readings, questions, and analytical solution is available at tiny.cc/pooledtesting.
Recommended Citation
Barreto, Humberto, "A Covid-19 Teaching Example: Pooled Testing with Microsoft Excel" (2020). Economics and Management Faculty publications. 3, Scholarly and Creative Work from DePauw University.
https://scholarship.depauw.edu/econ_facpubs/3
