A COVID-19 Teaching Example: Pooled Testing with Microsoft Excel
20 Pages Posted: 28 Aug 2020
Date Written: August 25, 2020
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.
Keywords: coronavirus, Monte Carlo, simulation, optimization, spreadsheet, pedagogy
JEL Classification: A2, C1, I10
Suggested Citation: Suggested Citation