Math
posted by Luke .
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
na
Respond to this Question
Similar Questions

history
i need to invent a terrible disease myself that has been detected in another part of the world .. the people are unhappy because the government are not helping them to treat the disease..please help me find a terrible disease but it … 
Algebra
A contagious disease is infecting residents of a town of 7,300 residents. The number of residents infected t days after the disease has begun is given by the function f(t)=(7300)/1+500e^0.5 t How many residents are infected with the … 
algebra
A contagious disease is infecting residents of a town of 7,300 residents. The number of residents infected t days after the disease has begun is given by the function f(t)= 7300/1+500e0.5t How many residents are infected with the … 
Algebra 2
PLEASE HELP WITH THISITS DUE APRIL 5TH, 2011!!! During a past epidemic, the number of infected people increased exponentially with time, or f (t) = ab^t , where f is the number of infected people at time t, in days. Suppose that at … 
algebra
Town has popultion of 5,000.Number of people infected after t days with a disease is N(t) = 5000/1 + 21.7e^0.4t Find number initially infected find number infected after 12 days 
Math
#5. If a rancher has one cow with a contagious disease in a herd of 1000, then the time in days “t” for “n” of the cows to become infected is modelled by: t= 5ln((1000n)/999n where “ln()” stands for natural logarithm … 
Math :)
1.Try to solve this problem without using a formula. Suppose a disease is transmitted from an individual to one other during the period of a week. Each of those two gives the disease to two more people in the second week, so that the … 
Statistics
) In a rural area, the infected rate of certain disease is 0.20 (i.e., 20%). A sample of 20 people is taken from the area  selections are independent. Define X as the number of people in the sample who are infected by the disease. … 
Calculus
During a certain epidemic, the number of people that are infected at any time increases at rate proportional to the number of people that are infected at that time. 1,000 people are infected when the epidemic is first discovered, and … 
Math
Annie learned that on day 1 of the outbreak, there were 105 infected dogs, and on day 2, there were 120 infected dogs. She noticed that each day, 15 more dogs became infected. Annie used these numbers to set up an alternative model …