Vaccination Drive for a Local Community: A Data Analysis Approach

System of Linear Equations for Vaccination Drive

In a local community of 1.25 million residents, a pandemic has struck and the local health authorities have been battling it for sometime through measures of wearing personal protective equipment and social distancing etc.

Now that vaccines have been created and are made available, the pandemic response team  PRT) wants to study the possibilities of implementation. To date, there are 3 vaccines that have been tested and approved by the world health authority.  You have been engaged as a data analyst by the PRT, who has the following considerations.

(a) In an attempt to achieve ‘herd immunity’, the PRT is aiming to vaccinate 64% of its community with a mean vaccine efficacy of 80%. The total cost of purchasing the vaccines is budgeted at $17.5 million (assumed to be spent entirely). 

Form a system of linear equations representing these requirements and solve it for the number of doses of each vaccine needed. Demonstrate the use of matrix row operations in your solution. The mean vaccine efficacy can be calculated from: 
where ηi is the efficacy of each vaccine and xi is the number of persons taking that vaccine.

(b) The world health authority has decided to provide the PRT some monetary assistance, hence enabling them to increase their budget of buying vaccines to $25.5 million (assumed to be spent entirely). The PRT is also considering achieving a higher mean vaccine efficacy of 85%.
Based on these two requirements, form a system of 2 linear equations and solve it. Show that there are infinitely many solutions and explain its meaning in the context of the vaccination problem.(14 marks)

(c) Some studies have been conducted on various countries on their vaccination drives and the following findings relating the vaccinated percentage to the new daily infections (7- day moving average) are tabulated where parameters a and b represent respectively the gradient and y-intercept of the linear-fit. Provide a screenshot of the dataset and your predictive function plotted in one graph to show the fit.
(15 marks)

(d) In order to prevent the healthcare facilities from being overwhelmed, the PRT wants to reduce the new daily infections in the community of 1.25 million residents to a maximum of 100 (based on the 7-day moving average). With reference to the predictive function in part (c), determine the minimum percentage of the local community population that needs to be vaccinated in order to achieve this goal. Give your answer to the nearest whole percent. Then, combining with the two requirements in part (b), determine the number of doses of each vaccine to be purchased by the PRT in their vaccination drive. (16 marks)

(e) A salesperson of the Biotac vaccine claims that since the PRT wants to achieve a mean vaccine efficacy of 85%, they should only purchase Biotac because it has a vaccine efficacy of 85% as proven in clinical trials. Considering the requirements in parts (b) and (c), advise the PRT on whether the salesperson’s claim should be followed. (7 marks)

(f) Express your solution in part (b) using a vector equation.