October 7, 2015

Homework Help: Math

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

First Name:
School Subject:

Related Questions

More Related Questions