Analysis of COVID-19 Vaccination Data: A Comparison of Three Countries

This project presents a comparative analysis of COVID-19 vaccination data from the UK, Israel, and the United States, focusing on the period from January 1st to February 28th, 2021. The study utilizes data obtained from two different sources to compare vaccination progress across the three countries. The analysis involves the use of charts, percentage/ratio/fraction calculations, and statistical techniques, including Excel's AutoSum features. The primary goal is to provide an effective comparison of vaccination rates, including first and second doses, to assess the relative progress of vaccination campaigns in each country. The raw data, encompassing dates, vaccination counts, and cumulative totals, is presented and manipulated to facilitate the comparison. The project aims to highlight key insights into the effectiveness and pace of vaccination programs in the UK, Israel, and the United States during the specified time frame.

Data Handling
Table of Contents
• Summary
• Raw Data Presentation
• Statistical Techniques
• Data Manipulation
• Visual Presentation
• Conclusion

Summary:
The study summaries multiple key aspects related to the Data handling on the basis of the given
case study and data of COVID vaccinations obtained from two different sources. The main
objective of the study is to make effective comparison of vaccination data for period 1st Jan
2021 till 28th Feb 2021, published on two different sites. Based on published data, comparison
has been made between UK vaccinations data and Israel & United State Vaccination data using
charts, percentage/ratio/fraction, Statistical techniques and Excel AutoSum features. This
comparison will help in effective analysis of progress of vaccination in UK as in comparison of
Israel and United State.

Continue… UK:
Principle of Reality:areaName date newPeopleVaccinatedFirstDoseByPublishDate newPeopleVaccinatedSecondDoseByPublishDate
United Kingdom 28-02-2021 185900 19684
United Kingdom 27-02-2021 407503 27322
United Kingdom 26-02-2021 504493 32773
United Kingdom 25-02-2021 485720 35319
United Kingdom 24-02-2021 448962 31613
United Kingdom 23-02-2021 326692 26317
United Kingdom 22-02-2021 192341 18463
United Kingdom 21-02-2021 141719 9177
United Kingdom 20-02-2021 334679 10263
United Kingdom 19-02-2021 371906 15294
United Kingdom 18-02-2021 452454 15867
United Kingdom 17-02-2021 482110 15147
United Kingdom 16-02-2021 364865 12412
United Kingdom 15-02-2021 275956 6535
United Kingdom 14-02-2021 237962 1915
United Kingdom 13-02-2021 505362 2846
United Kingdom 12-02-2021 544603 4775
United Kingdom 11-02-2021 503116 5647
United Kingdom 10-02-2021 450810 4894
United Kingdom 09-02-2021 411812 3161
United Kingdom 08-02-2021 352480 3811
United Kingdom 07-02-2021 278988 862
cumPeopleVaccinatedFirstDoseByPublishDate cumPeopleVaccinatedSecondDoseByPublishDate
20275451 815816
20089551 796132
19682048 768810
19177555 736037
18691835 700718
18242873 669105
17916181 642788
17723840 624325
17582121 615148
17247442 604885
16875536 589591
16423082 573724
15940972 558577
15576107 546165
15300151 539630
15062189 537715
14556827 534869
14012224 530094
13509108 524447
13058298 519553
12646486 516392
12294006 512581
United Kingdom 06-02-2021 549808 1662
United Kingdom 05-02-2021 494163 4064
United Kingdom 04-02-2021 480560 4036
United Kingdom 03-02-2021 469016 2995
United Kingdom 02-02-2021 374756 2166
United Kingdom 01-02-2021 350348 2587
United Kingdom 31-01-2021 319038 3156
United Kingdom 30-01-2021 598389 10621
United Kingdom 29-01-2021 487756 2178
United Kingdom 28-01-2021 414419 1769
United Kingdom 27-01-2021 312378 2329
United Kingdom 26-01-2021 311060 1710
United Kingdom 25-01-2021 279757 1968
United Kingdom 24-01-2021 220249 818
United Kingdom 23-01-2021 491970 1043
United Kingdom 22-01-2021 478248 1821
United Kingdom 21-01-2021 409855 2760
United Kingdom 20-01-2021 363508 3411
United Kingdom 19-01-2021 343163 3759
United Kingdom 18-01-2021 204076 4565
United Kingdom 17-01-2021 190107 2239
United Kingdom 16-01-2021 296131 2620
United Kingdom 15-01-2021 341317 4208
United Kingdom 14-01-2021 316694 5257
United Kingdom 13-01-2021 278943 9745
United Kingdom 12-01-2021 207661 16065
United Kingdom 11-01-2021 145076 20768
United Kingdom 10-01-2021
12015018 511719
11465210 510057
10971047 505993
10490487 501957
10021471 498962
9646715 496796
9296367 494209
8977329 491053
8378940 480432
7891184 478254
7476765 476485
7164387 474156
6853327 472446
6573570 470478
6353321 469660
5861351 468617
5383103 466796
4973248 464036
4609740 460625
4266577 456866
4062501 452301
3872394 450062
3576263 447442
3234946 443234
2918252 437977
2639309 428232
2431648 412167
2286572 391399

Continue… Israel:
iso_code continent location date total_vaccinations people_vaccinated people_fully_vaccinated
ISR Asia Israel 01-01-2021 1069799 1069799
ISR Asia Israel 02-01-2021 1142228 1142228
ISR Asia Israel 03-01-2021 1293264 1293264
ISR Asia Israel 04-01-2021 1446414 1446412 2
ISR Asia Israel 05-01-2021 1573186 1573184 2
ISR Asia Israel 06-01-2021 1678023 1678021 2
ISR Asia Israel 07-01-2021 1795497 1795492 5
ISR Asia Israel 08-01-2021 1862648 1862640 8
ISR Asia Israel 09-01-2021 1907663 1907633 30
ISR Asia Israel 10-01-2021 1951778 1945766 6012
ISR Asia Israel 11-01-2021 1992451 1967203 25248
ISR Asia Israel 12-01-2021 2052369 1991473 60896
ISR Asia Israel 13-01-2021 2161753 2043931 117822
ISR Asia Israel 14-01-2021 2287487 2100749 186738
ISR Asia Israel 15-01-2021 2354625 2131751 222874
ISR Asia Israel 16-01-2021 2410527 2161453 249074
ISR Asia Israel 17-01-2021 2563518 2229858 333660
ISR Asia Israel 18-01-2021 2753043 2299368 453675
ISR Asia Israel 19-01-2021 2962966 2371955 591011
ISR Asia Israel 20-01-2021 3182692 2448464 734228
ISR Asia Israel 21-01-2021 3415921 2517985 897936
ISR Asia Israel 22-01-2021 3524448 2555676 968772
ISR Asia Israel 23-01-2021 3617684 2595489 1022195
ISR Asia Israel 24-01-2021 3826759 2664383 1162376
ISR Asia Israel 25-01-2021 4046444 2745063 1301381
ISR Asia Israel 26-01-2021 4250759 2823505 1427254
ISR Asia Israel 27-01-2021 4452902 2901133 1551769
ISR Asia Israel 28-01-2021 4662371 2980479 1681892
ISR Asia Israel 29-01-2021 4763397 3016971 1746426
ISR Asia Israel 30-01-2021 4840266 3051207 1789059
new_vaccinations new_vaccinations_smoothed total_vaccinations_per_hundred people_vaccinated_per_hundred people_fully_vaccinated_per_hundred new_vaccinations_smoothed_per_million stringency_index population population_density
72155 116781 12.36 12.36 13492 82.41 8655541 402.606
72429 122432 13.2 13.2 14145 82.41 8655541 402.606
151036 128991 14.94 14.94 14903 82.41 8655541 402.606
153150 131449 16.71 16.71 0 15187 82.41 8655541 402.606
126772 127075 18.18 18.18 0 14681 82.41 8655541 402.606
104837 120006 19.39 19.39 0 13865 82.41 8655541 402.606
117474 113979 20.74 20.74 0 13168 85.19 8655541 402.606
67151 113264 21.52 21.52 0 13086 85.19 8655541 402.606
45015 109348 22.04 22.04 0 12633 85.19 8655541 402.606
44115 94073 22.55 22.48 0.07 10869 85.19 8655541 402.606
40673 78005 23.02 22.73 0.29 9012 85.19 8655541 402.606
59918 68455 23.71 23.01 0.7 7909 85.19 8655541 402.606
109384 69104 24.98 23.61 1.36 7984 85.19 8655541 402.606
125734 70284 26.43 24.27 2.16 8120 85.19 8655541 402.606
67138 70282 27.2 24.63 2.57 8120 85.19 8655541 402.606
55902 71838 27.85 24.97 2.88 8300 85.19 8655541 402.606
152991 87391 29.62 25.76 3.85 10097 85.19 8655541 402.606
189525 108656 31.81 26.57 5.24 12553 85.19 8655541 402.606
209923 130085 34.23 27.4 6.83 15029 85.19 8655541 402.606
219726 145848 36.77 28.29 8.48 16850 85.19 8655541 402.606
233229 161205 39.47 29.09 10.37 18624 85.19 8655541 402.606
108527 167118 40.72 29.53 11.19 19308 85.19 8655541 402.606
93236 172451 41.8 29.99 11.81 19924 85.19 8655541 402.606
209075 180463 44.21 30.78 13.43 20849 85.19 8655541 402.606
219685 184772 46.75 31.71 15.04 21347 85.19 8655541 402.606
204315 183970 49.11 32.62 16.49 21255 85.19 8655541 402.606
202143 181459 51.45 33.52 17.93 20964 85.19 8655541 402.606
209469 178064 53.87 34.43 19.43 20572 85.19 8655541 402.606
101026 176993 55.03 34.86 20.18 20449 85.19 8655541 402.606
76869 174655 55.92 35.25 20.67 20178 85.19 8655541 402.606
ISR Asia Israel 31-01-2021 4972630 3124308 1848322
ISR Asia Israel 01-02-2021 5089962 3206458 1883504
ISR Asia Israel 02-02-2021 5190614 3276234 1914380
ISR Asia Israel 03-02-2021 5301759 3336228 1965531
ISR Asia Israel 04-02-2021 5431912 3408558 2023354
ISR Asia Israel 05-02-2021 5494281 3442306 2051975
ISR Asia Israel 06-02-2021 5537901 3463814 2074087
ISR Asia Israel 07-02-2021 5660208 3517946 2142262
ISR Asia Israel 08-02-2021 5783699 3576618 2207081
ISR Asia Israel 09-02-2021 5916887 3642924 2273963
ISR Asia Israel 10-02-2021 6058932 3713192 2345740
ISR Asia Israel 11-02-2021 6211091 3793945 2417146
ISR Asia Israel 12-02-2021 6287342 3832843 2454499
ISR Asia Israel 13-02-2021 6345006 3860206 2484800
ISR Asia Israel 14-02-2021 6488233 3934698 2553535
ISR Asia Israel 15-02-2021 6644650 4015783 2628867
ISR Asia Israel 16-02-2021 6805655 4098917 2706738
ISR Asia Israel 17-02-2021 6942359 4160466 2781893
ISR Asia Israel 18-02-2021 7090370 4229253 2861117
ISR Asia Israel 19-02-2021 7167758 4268725 2899033
ISR Asia Israel 20-02-2021 7227782 4300231 2927551
ISR Asia Israel 21-02-2021 7385037 4379308 3005729
ISR Asia Israel 22-02-2021 7549642 4463952 3085690
ISR Asia Israel 23-02-2021 7696499 4540905 3155594
ISR Asia Israel 24-02-2021 7819803 4601619 3218184
ISR Asia Israel 25-02-2021 7935205 4652795 3282410
ISR Asia Israel 26-02-2021 7990985 4677639 3313346
ISR Asia Israel 27-02-2021 8028820 4695094 3333726
ISR Asia Israel 28-02-2021 8121737 4734158 3387579
132364 163696 57.45 36.1 21.35 18912 87.04 8655541 402.606
117332 149074 58.81 37.05 21.76 17223 87.04 8655541 402.606
100652 134265 59.97 37.85 22.12 15512 87.04 8655541 402.606
111145 121265 61.25 38.54 22.71 14010 87.04 8655541 402.606
130153 109934 62.76 39.38 23.38 12701 87.04 8655541 402.606
62369 104412 63.48 39.77 23.71 12063 87.04 8655541 402.606
43620 99662 63.98 40.02 23.96 11514 87.04 8655541 402.606
122307 98225 65.39 40.64 24.75 11348 64.81 8655541 402.606
123491 99105 66.82 41.32 25.5 11450 64.81 8655541 402.606
133188 103753 68.36 42.09 26.27 11987 64.81 8655541 402.606
142045 108168 70 42.9 27.1 12497 64.81 8655541 402.606
152159 111311 71.76 43.83 27.93 12860 62.96 8655541 402.606
76251 113294 72.64 44.28 28.36 13089 62.96 8655541 402.606
57664 115301 73.31 44.6 28.71 13321 62.96 8655541 402.606
143227 118289 74.96 45.46 29.5 13666 62.96 8655541 402.606
156417 122993 76.77 46.4 30.37 14210 62.96 8655541 402.606
161005 126967 78.63 47.36 31.27 14669 62.96 8655541 402.606
136704 126204 80.21 48.07 32.14 14581 62.96 8655541 402.606
148011 125611 81.92 48.86 33.06 14512 62.96 8655541 402.606
77388 125774 82.81 49.32 33.49 14531 62.96 8655541 402.606
60024 126111 83.5 49.68 33.82 14570 62.96 8655541 402.606
157255 128115 85.32 50.6 34.73 14802 57.41 8655541 402.606
164605 129285 87.22 51.57 35.65 14937 57.41 8655541 402.606
146857 127263 88.92 52.46 36.46 14703 57.41 8655541 402.606
123304 125349 90.34 53.16 37.18 14482 57.41 8655541 402.606
115402 120691 91.68 53.76 37.92 13944 73.15 8655541 402.606
55780 117604 92.32 54.04 38.28 13587 73.15 8655541 402.606
37835 114434 92.76 54.24 38.52 13221 73.15 8655541 402.606
92917 105243 93.83 54.7 39.14 12159 59.26 8655541 402.606

Continue… USA:
iso_code continent location date total_vaccinations people_vaccinated people_fully_vaccinated new_vaccinations
USA North AmericaUnited States01-01-2021
USA North AmericaUnited States02-01-2021 4225756 4225756
USA North AmericaUnited States03-01-2021
USA North AmericaUnited States04-01-2021 4563260 4563260
USA North AmericaUnited States05-01-2021 4836469 4836469 273209
USA North AmericaUnited States06-01-2021 5306797 5306797 470328
USA North AmericaUnited States07-01-2021 5919418 5919418 612621
USA North AmericaUnited States08-01-2021 6688231 6688231 768813
USA North AmericaUnited States09-01-2021
USA North AmericaUnited States10-01-2021
USA North AmericaUnited States11-01-2021 8987322 8987322
USA North AmericaUnited States12-01-2021 9327138 9327138 339816
USA North AmericaUnited States13-01-2021 10278462 951324
USA North AmericaUnited States14-01-2021 11148991 9690757 1342086 870529
USA North AmericaUnited States15-01-2021 12279180 10595866 1610524 1130189
USA North AmericaUnited States16-01-2021
USA North AmericaUnited States17-01-2021
USA North AmericaUnited States18-01-2021
USA North AmericaUnited States19-01-2021 15707588 13595803 2023124
USA North AmericaUnited States20-01-2021 16525281 14270441 2161419 817693
USA North AmericaUnited States21-01-2021 17546374 15053257 2394961 1021093
USA North AmericaUnited States22-01-2021 19107959 16243093 2756953 1561585
USA North AmericaUnited States23-01-2021 20537990 17390345 3027865 1430031
USA North AmericaUnited States24-01-2021 21848655 18502131 3216836 1310665
USA North AmericaUnited States25-01-2021 22734243 19252279 3346390 885588
USA North AmericaUnited States26-01-2021 23540994 19902237 3481921 806751
USA North AmericaUnited States27-01-2021 24652634 20687970 3801053 1111640
USA North AmericaUnited States28-01-2021 26193682 21698606 4263056 1541048
USA North AmericaUnited States29-01-2021 27884661 22858318 4780888 1690979
USA North AmericaUnited States30-01-2021 29577902 24064165 5259693 1693241
USA North AmericaUnited States31-01-2021 31123299 25201143 5657142 1545397
new_vaccinations_smoothed total_vaccinations_per_hundred people_vaccinated_per_hundred people_fully_vaccinated_per_hundred new_vaccinations_smoothed_per_million stringency_index population population_density
302329 904 71.76 331002647 35.608
325882 1.26 1.26 974 71.76 331002647 35.608
336949 1007 71.76 331002647 35.608
348017 1.36 1.36 1041 71.76 331002647 35.608
339372 1.45 1.45 1015 71.76 331002647 35.608
358887 1.59 1.59 1073 71.76 331002647 35.608
378253 1.77 1.77 1131 71.76 331002647 35.608
419933 2 2 1256 71.76 331002647 35.608
461263 1379 71.76 331002647 35.608
546636 1634 71.76 331002647 35.608
632009 2.69 2.69 1890 71.76 331002647 35.608
641524 2.79 2.79 1918 71.76 331002647 35.608
710238 3.07 2124 71.76 331002647 35.608
747082 3.33 2.9 0.4 2234 71.76 331002647 35.608
798707 3.67 3.17 0.48 2388 71.76 331002647 35.608
811670 2427 71.76 331002647 35.608
824632 2466 71.76 331002647 35.608
837595 2504 71.76 331002647 35.608
911493 4.7 4.07 0.6 2725 71.76 331002647 35.608
892403 4.94 4.27 0.65 2668 71.76 331002647 35.608
913912 5.25 4.5 0.72 2733 71.76 331002647 35.608
975540 5.71 4.86 0.82 2917 71.76 331002647 35.608
1057387 6.14 5.2 0.91 3162 71.76 331002647 35.608
1122182 6.53 5.53 0.96 3355 71.76 331002647 35.608
1126251 6.8 5.76 1 3368 71.76 331002647 35.608
1119058 7.04 5.95 1.04 3346 71.76 331002647 35.608
1161050 7.37 6.19 1.14 3472 71.76 331002647 35.608
1235330 7.83 6.49 1.27 3694 71.76 331002647 35.608
1253815 8.34 6.83 1.43 3749 71.76 331002647 35.608
1291416 8.84 7.2 1.57 3861 71.76 331002647 35.608
1324949 9.31 7.54 1.69 3962 71.76 331002647 35.608
USA North AmericaUnited States01-02-2021 32222402 26023153 5927847 1099103
USA North AmericaUnited States02-02-2021 32780860 26440836 6064792 558458
USA North AmericaUnited States03-02-2021 33878254 27154956 6436931 1097394
USA North AmericaUnited States04-02-2021 35203710 27905197 6926050 1325456
USA North AmericaUnited States05-02-2021 36819212 28909497 7503864 1615502
USA North AmericaUnited States06-02-2021 39037964 30250964 8317180 2218752
USA North AmericaUnited States07-02-2021 41210937 31579100 9147185 2172973
USA North AmericaUnited States08-02-2021 42417617 32340146 9518015 1206680
USA North AmericaUnited States09-02-2021 43206190 32867213 9840429 788573
USA North AmericaUnited States10-02-2021 44769970 33783384 10469514 1563780
USA North AmericaUnited States11-02-2021 46390270 34723964 11188782 1620300
USA North AmericaUnited States12-02-2021 48410558 35834855 12085830 2020288
USA North AmericaUnited States13-02-2021 50641884 37056122 13082172 2231326
USA North AmericaUnited States14-02-2021 52884356 38292270 14077440 2242472
USA North AmericaUnited States15-02-2021
USA North AmericaUnited States16-02-2021 55220364 39670551 15015434
USA North AmericaUnited States17-02-2021 56281827 40268009 15471536 1061463
USA North AmericaUnited States18-02-2021 57737767 41021049 16162358 1455940
USA North AmericaUnited States19-02-2021 59585043 41977401 17039118 1847276
USA North AmericaUnited States20-02-2021 61289500 42809595 17895667 1704457
USA North AmericaUnited States21-02-2021 63090634 43628092 18865319 1801134
USA North AmericaUnited States22-02-2021 64177474 44138118 19438495 1086840
USA North AmericaUnited States23-02-2021 65032083 44544969 19882544 854609
USA North AmericaUnited States24-02-2021 66464947 45237143 20607261 1432864
USA North AmericaUnited States25-02-2021 68274117 46074392 21555117 1809170
USA North AmericaUnited States26-02-2021 70454064 47184199 22613359 2179947
USA North AmericaUnited States27-02-2021 72806180 48435536 23698627 2352116
USA North AmericaUnited States28-02-2021 75236003 49772180 24779920 2429823
1355451 9.63 7.78 1.77 4053 71.76 331002647 35.608
1319981 9.8 7.91 1.81 3947 71.76 331002647 35.608
1317946 10.13 8.12 1.92 3941 68.06 331002647 35.608
1287147 10.53 8.34 2.07 3849 68.06 331002647 35.608
1276364 11.01 8.64 2.24 3816 68.06 331002647 35.608
1351437 11.67 9.05 2.49 4041 68.06 331002647 35.608
1441091 12.32 9.44 2.74 4309 68.06 331002647 35.608
1456459 12.68 9.67 2.85 4355 68.06 331002647 35.608
1489333 12.92 9.83 2.94 4453 68.06 331002647 35.608
1555959 13.39 10.1 3.13 4652 68.06 331002647 35.608
1598080 13.87 10.38 3.35 4778 68.06 331002647 35.608
1655907 14.48 10.71 3.61 4951 68.06 331002647 35.608
1657703 15.14 11.08 3.91 4957 68.06 331002647 35.608
1667631 15.81 11.45 4.21 4986 68.06 331002647 35.608
1662106 4970 68.06 331002647 35.608
1716311 16.51 11.86 4.49 5132 68.06 331002647 35.608
1644551 16.83 12.04 4.63 4917 68.06 331002647 35.608
1621071 17.26 12.27 4.83 4847 68.06 331002647 35.608
1596355 17.82 12.55 5.09 4773 68.06 331002647 35.608
1521088 18.33 12.8 5.35 4548 68.06 331002647 35.608
1458040 18.86 13.05 5.64 4360 68.06 331002647 35.608
1446445 19.19 13.2 5.81 4325 68.06 331002647 35.608
1401674 19.44 13.32 5.94 4191 331002647 35.608
1454731 19.87 13.53 6.16 4350 331002647 35.608
1505193 20.41 13.78 6.45 4501 331002647 35.608
1552717 21.07 14.11 6.76 4643 331002647 35.608
1645240 21.77 14.48 7.09 4919 331002647 35.608
1735053 22.5 14.88 7.41 5188 331002647 35.608

Comparison between UK govt. website and worldwide data
website:

Comparison between Daily Vaccination of Israel, UK and
USA:

Comparison between total vaccination of Israel, UK and US:

Comparison between new vaccination of UK, US and Israel:

Percentage of vaccination of Israel, UK and US:

Statistical Techniques:
In data analysis, statistical techniques are needed to make ensure that selected raw data are
effectively interpreted as well as apparent key relationships are relevant and also, not merely
chances of occurrences. In this regard following is conversion of selected raw data into significant
information through applying Mean, Median and Mode, as follows:

Data Manipulation

Conclusion
From above analysis, ratios and charts this has been articulated that vaccination program in
UK has reported continuous progress along with incremental trends in overall vaccinated people
with first and second dose. Moreover, in both USA and Israel vaccinations of people shown up
lining trend in terms of total people vaccinated. But comparative analysis of with respect to
country’s population shows that Israel is most efficient among other two in terms of vaccination
because Israel has vaccinated around more than three forth of its population.

References
Books and Journals:
Martínez-Rojas, M., Marín, N. and Vila, M.A., 2016. The role of information technologies to address
data handling in construction project management. Journal of Computing in Civil
Engineering, 30(4), p.04015064.
Xiao, J. and Bulut, O., 2020. Evaluating the performances of missing data handling methods in ability
estimation from sparse data. Educational and Psychological Measurement, 80(5), pp.932-954.
Cook, T.M. and Roberts, J.V., 2021. Impact of vaccination by priority group on UK deaths, hospital
admissions and intensive care admissions from COVID‐19. Anaesthesia.
Enders, C.K., 2017. Multiple imputation as a flexible tool for missing data handling in clinical
research. Behaviour research and therapy, 98, pp.4-18.
Online:
World data of Vaccination. 2021. [Online]. Available through: <https://ourworldindata.org/covid-
vaccinations>
UK Vaccination Data. 2021. [Online]. Available through:
<https://coronavirus.data.gov.uk/details/vaccinations>