1. Estimating prevalence and incidence of HIV/AIDS in the U.S. using spreadsheet methods
- Author
-
Harris, Carl M. and Rattner, Edward
- Subjects
Usage ,Diseases ,Statistical Analysis ,Statistical/Mathematical Software ,Modeling ,Mathematical Models ,Spreadsheet Software ,AIDS (Disease) ,Computer simulation ,Spreadsheet software -- Usage ,Mathematical software ,Statistical software ,Data modeling software ,Mathematical models ,Software ,Spreadsheets -- Usage - Abstract
This paper describes Cohort Cascade, which uses interactive techniques to connect spreadsheets, programming and computer modeling methods to provide interesting insights into the spread of the AIDS/HIV epidemic. Cohort Cascade uses estimated progression rates for time-to-AIDS by using information from the years 1976-1985. Computer simulation is then used to extrapolate the AIDS onset information for the years 1986 to 1995. The model used in this simulation treats each cohort as a homogeneous Markov chain with a sparse transition matrix, this makes it well suited to spreadsheet transformation. The model takes into consideration weaknesses in data collection and underreporting of the disease.
- Published
- 1992