Math

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.

  1. 👍 0
  2. 👎 0
  3. 👁 85
asked by Luke
  1. na

    1. 👍 0
    2. 👎 0

Respond to this Question

First Name

Your Response

Similar Questions

  1. 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.5t How many residents are infected with the

    asked by joyce on November 21, 2010
  2. 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

    asked by Laurie on August 2, 2009
  3. 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((1000-n)/999n where “ln()” stands for natural logarithm

    asked by Sam on January 18, 2013
  4. Public Health

    There is an airborne disease that is highly contagious and deadly. It is suspected that a passenger in a flight coming from overseas is infected. You are the infectious disease specialist and decide to keep the passengers on the

    asked by Jennifer on February 3, 2012
  5. Health

    1.Antibiotics can be used to cure which of the following diseases? A) the flu B) mononucleosis C) strep throats D) hepatitis 2.Athlete's foot is caused by______. A) a fungus < my answer B)swimming pools C) bacteria D) a virus 3.

    asked by kaliyah on November 13, 2017
  6. Health

    1.Antibiotics can be used to cure which of the following diseases? A) the flu < my answer B) mononucleosis C) strep throats D) hepatitis 2.Athlete's foot is caused by______. A) a fungus < my answer B)swimming pools C) bacteria D)

    asked by kaliyah on November 13, 2017
  7. 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

    asked by Stacy on November 6, 2017
  8. 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

    asked by Kim on December 2, 2013
  9. Biology

    Explain why would there be more white blood cells found in a person's body who is infected by salmonella bacteria rather than a healthy person?

    asked by Laila on November 24, 2010
  10. Spelling

    Here are the words that I have to unscramble to form a sentence. It seems like it might be missing a word. disease contagious could not he doctor his conceal from... I can only come up with a sentence if I add an extra "his". The

    asked by Claire on March 3, 2013

More Similar Questions