Comparative Analysis of COVID-19 Vaccination Data (UK, US, Israel)

This report provides a comprehensive data analysis of COVID-19 vaccination trends in the United Kingdom, United States, and Israel. It begins with an introduction to COVID-19 vaccines and their significance, followed by a detailed examination of vaccination data in the UK, including the number of individuals receiving first and second doses. The report then compares the UK data with those of the United States and Israel, highlighting differences in vaccination rates and population percentages. Various MS Excel functions, such as Mean, Mode, Median, and AutoSum features (COUNT, MIN, MAX), are employed to analyze the data effectively. Charts and graphs are used to visualize the comparisons. The analysis reveals that the United States has the highest number of vaccinated people, followed by the UK and then Israel. The report concludes with a summary of findings and references to the sources used.

Data Analysis

 INTRODUCTION
 Data on COVID VACCINES IN UK, UK and ISRAEL
 Comparison of the UK vaccination data
 Comparison of the UK vaccination data with Israel and
Unites States
 Comparison of the people vaccinated in different
countries according to their population
 CONCLUSION
 REFERENCES
TABLE OF CONTENTS

 Vaccines for COVID-19 are injected to the patients so that they can be safe from
the disease of COVID-19.
 The report will shed light on the data of UK regarding the vaccinations given to the
people as a prevention measure against COVID-19.
 It will also focus on the people who got the 1st dose, 2nd dose and both the doses of
the vaccinations.
 The data of 3 countries: UK, Israel and United States will be compared and
analysed. The various excel functions like Mean, Mode and median will be used to
find the respective values.
 The AutoSum functions will also be used to find the values like COUNT, MIN,
MAX etc. Various charts and graphs will be used to do the comparison among the
data of different countries.
INTRODUCTION

 The first source presented the vaccination data of UK in last 4 months while the
other source presented the vaccination data between various countries.
 In the first source, the data was last updated on 9 April which means the recent data
is updated regularly.
 It was observed that the people who got 1st dose of vaccination was given to almost
31,903,366 people and the second dose was given to almost 6,541,174 which
means the total of 38,444,540 people got the 1st and 2nd dose of vaccination.
Comparison of the UK vaccination data
41%
9%
50% 1st dose
2nd dose
1st and 2nd
dose
Doses of vaccinations
given
People in UK
1st dose 31,903,366
2nd dose 6,541,174
1st and 2nd dose 38,444,540

•The similarities in both of the sources is that they both represented the data
regarding the vaccinations given to the people for the prevention of COVID-19 and
the differences between both is that in the first source, the data is given restricted to
UK people but in the other source, data was given regarding the vaccines in many
countries.
•There is a comparison of the vaccine doses given to the people in different countries
but it also gives the facility to view the data of only a single country or more than the
same.

 This can be observed from the above figure that In United Kingdom 37.90 million
people got vaccinated with one dose whereas in Israel, only 10.19 million people
got the first dose of vaccine.
 On the other hand the United states, 171.48 million people got vaccinated. This
interprets that the highest number of people are vaccinated in United States then
comes the UK and then the least number of people are vaccinated in Israel.
Comparison of the UK vaccination data
with Israel and Unites States
Country People Vaccinated
United states 171.48 million
United Kingdom 37.90 million
Israel 10.19 million

Comparison of the people vaccinated in
different countries according to their
population
United
States
United
Kingdom
Israel
0%
20%
40%
60%
80%
100%
120%
Percentage of people
vaccinated
Percentage of
people vaccinated
Country People
Vaccinated
Total
populat
ion
Percenta
ge of
people
vaccinat
ed
United
States
171.48 331.42 52%
United
Kingdom
37.9 66.8 57%
Israel 10.19 10.20 100%

MS EXCEL FUNCTIONS

AUTOSUM FEATURES

 The above report shed light on the people vaccinated in UK and got 1st, 2nd
and both the doses. Various graphs and charts were used to present the
data.
 This helped in concluding that the highest number of people vaccinated is
in US then UK and then Israel.
 This was followed by performing various operations like Mean, Median
and Mode by making use of MS Excel.
 The use of Autosum functions was also used to find the values like
Minimum, Maximum etc. regarding the data of these countries.
CONCLUSION

 Baraniuk, C., 2021. Covid-19: How the UK vaccine rollout delivered
success, so far. Bmj. 372.
 Looi, M.K., 2021. Jeremy Farrar: Make vaccine available to other
countries as soon as our most vulnerable people have received it. Bmj. 372.
 Mills, M.C. and Salisbury, D., 2021. The challenges of distributing
COVID-19 vaccinations. EClinicalMedicine. 31.
 Vasileiou, E. and et.al., 2021. Effectiveness of first dose of COVID-19
vaccines against hospital admissions in Scotland: national prospective
cohort study of 5.4 million people.
 Number of people who received at least one dose of COVID-19 vaccine,
2021. [ONLINE]. Available through :< Coronavirus (COVID-19)
Vaccinations - Statistics and Research - Our World in Data>
 People Vaccinated in UK, 2021. [ONLINE]. Available through: <
Vaccinations | Coronavirus in the UK (data.gov.uk)>
REFERENCES