A Covid-19 Teaching Example: Pooled Testing with Microsoft Excel
Humberto Barreto (hbarreto@depauw.edu)
No 2020-01, Working Papers from DePauw University, School of Business and Leadership and Department of Economics and Management
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.
Keywords: coronavirus; Monte Carlo; simulation; optimization; spreadsheet; pedagogy (search for similar items in EconPapers)
JEL-codes: A2 C1 I10 (search for similar items in EconPapers)
Date: 2020-08
New Economics Papers: this item is included in nep-ore
References: Add references at CitEc
Citations:
Downloads: (external link)
https://www.depauw.edu/site/learn/dew/wpaper/worki ... to-PooledTesting.pdf (application/pdf)
Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.
Export reference: BibTeX
RIS (EndNote, ProCite, RefMan)
HTML/Text
Persistent link: https://EconPapers.repec.org/RePEc:dew:wpaper:2020-01
Access Statistics for this paper
More papers in Working Papers from DePauw University, School of Business and Leadership and Department of Economics and Management Contact information at EDIRC.
Bibliographic data for series maintained by Humberto Barreto (hbarreto@depauw.edu).