You just started your summer internship with immunityPlus based in La Crosse, Wisconsin. You are working with forecasting team to estimate how many doses of an immunization drug will be needed. For each drug estimation, you will be provided the following information: 1. The size of the target population 2. The life expectancy, in yeras of an individual in the population 3. A file containig ages, in years, of a sample of 12 people infected in the population To calculate the number of doses needed: 1. Calulate the average age of infection from a sample of 12 years 2.  Calculate the Base reproduction number(Ro) Ro = life expectancy / average age of infection 3. Calculate herd immunity threshold (Q) Q = 1 - 1/Ro 4. Calculate the numebr of doses Doses = Q * population size Construct a profram that allos a user to enter the size of the target population, the life expectancy of an individual in the population, and the name of the sample file. Once this information is obtained, perform the above four calculations and output the result of each calculation, appropriately labled. sample file: Corona.txt Data in sample file: 39 20 31 10 42 49 54 21 70 40 47 60

Np Ms Office 365/Excel 2016 I Ntermed
1st Edition
ISBN:9781337508841
Author:Carey
Publisher:Carey
Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts
Section: Chapter Questions
Problem 3.3CP
icon
Related questions
Question

You just started your summer internship with immunityPlus based in La Crosse, Wisconsin. You are working with forecasting team to estimate how many doses of an immunization drug will be needed.

For each drug estimation, you will be provided the following information:

1. The size of the target population

2. The life expectancy, in yeras of an individual in the population

3. A file containig ages, in years, of a sample of 12 people infected in the population

To calculate the number of doses needed:

1. Calulate the average age of infection from a sample of 12 years

2.  Calculate the Base reproduction number(Ro)

Ro = life expectancy / average age of infection

3. Calculate herd immunity threshold (Q)

Q = 1 - 1/Ro

4. Calculate the numebr of doses

Doses = Q * population size

Construct a profram that allos a user to enter the size of the target population, the life expectancy of an individual in the population, and the name of the sample file. Once this information is obtained, perform the above four calculations and output the result of each calculation, appropriately labled.

sample file: Corona.txt

Data in sample file:

39
20
31
10
42
49
54
21
70
40
47
60 

Expert Solution
steps

Step by step

Solved in 5 steps with 2 images

Blurred answer
Knowledge Booster
Fundamentals of Datawarehouse
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage