A COVID-19 Teaching Example: Pooled Testing with Microsoft Excel

20 Pages Posted: 28 Aug 2020

Date Written: August 25, 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.

Keywords: coronavirus, Monte Carlo, simulation, optimization, spreadsheet, pedagogy

JEL Classification: A2, C1, I10

Suggested Citation

Barreto, Humberto, A COVID-19 Teaching Example: Pooled Testing with Microsoft Excel (August 25, 2020). Available at SSRN: https://ssrn.com/abstract=3680835 or http://dx.doi.org/10.2139/ssrn.3680835

Humberto Barreto (Contact Author)

DePauw University ( email )

Greencastle, IN 46135
United States
765-365-4099 (Phone)

HOME PAGE: http://https://www.depauw.edu/learn/econexcel/

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
54
Abstract Views
1,053
rank
515,585
PlumX Metrics