EconPapers    
Economics at your fingertips  
 

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).

 
Page updated 2024-10-27
Handle: RePEc:dew:wpaper:2020-01