Modeling a Pandemic with Excel
We develop a discrete-time model of a pandemic and implement the model in Excel. We then compare the model with the standard SIR model and with a standard Markov model.
Thanks to:
Professor Jacob Glower for his video: • ECE 341.22 Markov Chains and Coronavirus
Also, thanks to the following for their videos on modeling a pandemic:
3Blue1Brown (for the pandemic simulation): • Simulating an epidemic
Numberphile (for the GeoGebra animation/solver): • The Coronavirus Curve - Numberphile
Tom Rocks Math (for the formula to compute max infected in SIR model): • Oxford Mathematician explains SIR Disease ...