Posted by Luke on Monday, September 27, 2010 at 8:42pm.
Scientists are researching a contagious disease. They found that, on average, each person who is infected transmits the disease to 0.03 other people within one year. Currently, there are 3,000 infected people in the country. Use Excel or another spreadsheet application to find out (1) how many people will contract the disease each year over the next decade, and (2) how many infected people will there be each year if no medication is administered. (Do not worry: there is a medication for this disease.) "Currently" means in the first year of your calculation. Calculate for the next nine years. Explain why this is a model¬ing problem. What is your model in the spreadsheet?
Hint: People who were sick in the beginning of year remain to be sick and may transmit the disease next year.

Math  Anonymous, Thursday, September 3, 2015 at 3:00pm
na
Answer This Question
Related Questions
 Math :)  1.Try to solve this problem without using a formula. Suppose a disease...
 algebra  A contagious disease is infecting residents of a town of 7,300 ...
 Algebra  A contagious disease is infecting residents of a town of 7,300 ...
 Statistics  ) In a rural area, the infected rate of certain disease is 0.20 (i....
 Algebra 2  PLEASE HELP WITH THISITS DUE APRIL 5TH, 2011!!! During a past ...
 Math  #5. If a rancher has one cow with a contagious disease in a herd of 1000...
 algebra  Town has popultion of 5,000.Number of people infected after t days ...
 history  i need to invent a terrible disease myself that has been detected in ...
 Calculus  During a certain epidemic, the number of people that are infected at ...
 Epidemiology  How do you calculate the disease frequency rate in these problems...
More Related Questions