Comparative Analysis of COVID-19 Vaccination Data in the UK

This assignment presents a comparative analysis of the UK's COVID-19 vaccination drive, utilizing data from coronavirus.data.gov.uk and ourworldindata.org. The student downloaded raw data from January 1st to February 28th, 2021, and employed Microsoft Excel to manipulate and visualize the data. The analysis includes comparisons between the two data sources, focusing on similarities and differences. The assignment further compares daily vaccination rates between the UK, US, and Israel, and examines the relationship between total and new vaccinations in these countries. Visual representations, such as graphs, are used to communicate the findings, demonstrating the student's ability to handle and interpret data effectively. The assignment adheres to a specific brief, including a PowerPoint presentation with a limited number of slides to present the findings, showcasing the student's data analysis and presentation skills within the context of a case study. The student also used auto sum function in excel sheets. The assignment's focus is to demonstrate the ability to obtain, manipulate, and present data related to a timely and relevant public health issue, with the use of excel for analysis.

Data Handling
Comparative analysis of COVID-19 Vaccination drive

UK Vaccination data
Source: coronavirus.data.gov.uk
Source: ourworldindata.org

Sample raw data
United Kingdom:

COMPARISION BETWEEN UK GOV
WEBSITE AND WORLDIN DATA WEBSITE

• The graph shows the comparative analysis between the daily number
of vaccination per day of Israel , UK and US .
COMPARISION BETWEEN DAILY
VACCINATION OF ISRAEL , UK AND US
1/1/2021
1/4/2021
1/7/2021
1/10/2021
1/13/2021
1/16/2021
1/19/2021
1/22/2021
1/25/2021
1/28/2021
1/31/2021
2/3/2021
2/6/2021
2/9/2021
2/12/2021
2/15/2021
2/18/2021
2/21/2021
2/24/2021
2/27/2021
0
4000000
COMPARASION BETWEEN UK,US AND
ISRAEL
new_vaccination (Israel) new_vaccinations (UK) new_vaccinations (US)
DATE
NUMBER OF PEOPLE

COMPARISIONB/W TOTAL VACCINATION AND NEW
VACCINATION OF ISRAEL, UK AND US
• Combo chart used to
manipulate the
comparision between total
vaccination and new
vaccination of Israel , UK
and US.
1/1/2021
1/6/2021
1/11/2021
1/16/2021
1/21/2021
1/26/2021
1/31/2021
2/5/2021
2/10/2021
2/15/2021
2/20/2021
2/25/2021
0
20000000
40000000
60000000
80000000
0
1000000
2000000
3000000
C OM PA RA S I ON B /W TO TA L V A C C IN A TI ON A N D N EW
V A C C IN A TI ON OF IS RA EL , U K A N D US
total_vaccinations (Israel) total_vaccinations (UK)
total_vaccinations (US) new_vaccination (Israel)
new_vaccinations (UK) new_vaccinations (US)
DATE
NUMBER OF PEOPLE
NUMBER OF PEOPLE

PRECENTAGE VACCINATION ON
ISRAEL, UK AND US

Data view and formula view of auto
sum function in excel sheet

References
Online:
• UK Vaccination Data. 2021. [Online]. Available through:
<https://coronavirus.data.gov.uk/details/vaccinations>
• World data of Vaccination. 2021. [Online]. Available through: <https://ourworldindata.org/covid-
vaccinations>