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.

## Answer this Question

## Related Questions

- 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 ...
- Math :) - 1.Try to solve this problem without using a formula. Suppose a disease...
- Statistics - ) In a rural area, the infected rate of certain disease is 0.20 (i....
- Math - #5. If a rancher has one cow with a contagious disease in a herd of 1000...
- Algebra 2 - PLEASE HELP WITH THIS-ITS DUE APRIL 5TH, 2011!!! During a past ...
- 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...