Open Access. Powered by Scholars. Published by Universities.®

Econometrics Commons

Open Access. Powered by Scholars. Published by Universities.®

DePauw University

Series

2020

Articles 1 - 1 of 1

Full-Text Articles in Econometrics

A Covid-19 Teaching Example: Pooled Testing With Microsoft Excel, Humberto Barreto Aug 2020

A Covid-19 Teaching Example: Pooled Testing With Microsoft Excel, Humberto Barreto

Economics and Management Faculty publications

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.