Event Title
Using Excel to Model Infectious Diseases
Date of Publication
2-3-2021
Document Type
Presentation
Abstract
In 2020, the world faced a pandemic due to a coronavirus disease (COVID-19), resulting in tens of millions of cases and hundreds of thousands of deaths across at least 235 countries (WHO, 2020). Like other infectious diseases transmitted from one host to another, COVID-19 can be modeled using a mathematical model known as SIR, where the population is divided into susceptible (S), infected (I), and recovered (R) individuals. In this paper, Microsoft Excel is used to store historical COVID-19 data, simulate the SIR model and fit it to the data, and test control measures, such as self-isolation, education, and vaccination.
Keywords
Excel, Infectious Diseases
Persistent Identifier
http://hdl.handle.net/10950/2954
Using Excel to Model Infectious Diseases
In 2020, the world faced a pandemic due to a coronavirus disease (COVID-19), resulting in tens of millions of cases and hundreds of thousands of deaths across at least 235 countries (WHO, 2020). Like other infectious diseases transmitted from one host to another, COVID-19 can be modeled using a mathematical model known as SIR, where the population is divided into susceptible (S), infected (I), and recovered (R) individuals. In this paper, Microsoft Excel is used to store historical COVID-19 data, simulate the SIR model and fit it to the data, and test control measures, such as self-isolation, education, and vaccination.