Comparing Data: Covid-19 Vaccination in UK, Israel, and United States

The study summarizes the comparison of Covid-19 vaccination data between the UK, Israel, and the United States. It analyzes the progress of vaccination using statistical techniques and visual presentations.

COMPARING DATA

TABLE OF CONTENT
Summary
Raw Data Presentation
Statistical Techniques
Data Manipulation
Visual Presentation
Conclusion

SUMMARY
The study summarise many different aspect that is related to data handling on the basis
of given case study and data of Covid-19 vaccination that is obtained from the different
cities. The prime objective this study is to study the period between 1 Jan 2021 till 28th
feb 2021, published in 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
helps in to achive effective analysis of progress of vaccination in UK in the comparison of Israel
and United State.

RAW DATA PRESENTATION
Data Sampling: In this study of sample has been selected from the data published on
following sources:
1. https://coronavirus.data.gov.uk/details/vaccinations, and
2. https://ourworldindata.org/covid-vaccinations
From first source data of entire UK vaccinations during period 1st Jan 2021 to 28th Feb
2021, has been selected as sample. On the other hand form the second source, Israel and
United States’ vaccination data has been selected as given in case study for the same period.

CONTINUE..
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

CONTINUED..
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

CONTINUED..
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

CONTINUED..
(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

CONTINUED..
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

STATISTICAL TECHNIQUES:
In this kind of data analysis, statistical techniques are required to make that selected raw data
are effectively interpreted as well as key relationships are relevant and also, not merely
chances of occurrences. In this regard following is conversion of selected raw data into
important information through application of Mean, Median and Mode, as follows:
UK:
newPeopleVaccinatedFirstDoseByPublishDate newPeopleVaccinatedSecondDoseByPublishDate
Mean 362300.7273 Mean 13290.96364
Median 363508 Median 4775
Mode #N/A Mode #N/A
cumPeopleVaccinatedFirstDoseByPublishDate cumPeopleVaccinatedSecondDoseByPublishDate
Mean 12019784.55 Mean 580717.7679
Median 12154512 Median 512150
Mode #N/A Mode #N/A

STATISTICAL TECHNIQUES:
ISRAEL:
total_vaccinations people_vaccinated people_fully_vaccinated new_vaccinations new_vaccinations_smoothed
Mean 4610502 Mean 3055282 Mean 1638535 Mean 120747.3 Mean 123896.5
Median 4840266 Median 3051207 Median 1865913 Median 122307 Median 121265
Mode #N/A Mode #N/A Mode 2 Mode #N/A Mode #N/A

CONTINUED..
total_vaccinations_per_hundred people_vaccinated_per_hundred people_fully_vaccinated_per_hundred new_vaccinations_smoothed_per_million stringency_index population population_density
Mean 53.26695 Mean 35.29881 Mean 18.93054 Mean 14314.14 Mean 77.0422 Mean 8655541 Mean 402.606
Median 55.92 Median 35.25 Median 21.555 Median 14010 Median 85.19 Median 8655541 Median 402.606
Mode #N/A Mode #N/A Mode 0 Mode 8120 Mode 85.19 Mode 8655541 Mode 402.606

STATISTICAL TECHNIQUES:
USA:
total_vaccinations people_vaccinated people_fully_vaccinated new_vaccinations new_vaccinations_smoothed total_vaccinations_per_hundred
Mean 35216990 Mean 26735673.86 Mean 10303207.07 Mean 1361070 Mean 1128759.797 Mean 10.52980392
Median 32780860 Median 26797896 Median 8732182.5 Median 1377744 Median 1276364 Median 9.8
Mode #N/A Mode #N/A Mode #N/A Mode #N/A Mode #N/A Mode #N/A
people_vaccinated_per_hundred people_fully_vaccinated_per_hundred new_vaccinations_smoothed_per_million stringency_index population population_density
Mean 7.9948 Mean 3.080238095 Mean 3375.068 Mean 70.36377358 Mean 331002647 Mean 35.608
Median 8.015 Median 2.615 Median 3816 Median 71.76 Median 331002647 Median 35.608
Mode #N/A Mode #N/A Mode #N/A Mode 71.76 Mode 331002647 Mode 35.608

DATA MANIPULATION
UK:
newPeopleVaccinatedFirstDoseByPublishDate newPeopleVaccinatedSecondDoseByPublishDate
Standard Deviation 114737.7276 Standard Deviation 16863.17666
Sample Variance 13164746134 Sample Variance 284366727.2
Kurtosis -0.893476447 Kurtosis 3.616425868
Skewness -0.092781336 Skewness 1.973571446
Range 456670 Range 69388
Minimum 141719 Minimum 818
Maximum 598389 Maximum 70206
Sum 19926540 Sum 731003
Count 55 Count 55

CONTINUED..
cumPeopleVaccinatedFirstDoseByPublishDate cumPeopleVaccinatedSecondDoseByPublishDate
Standard Deviation 6247239.459 Standard Deviation 174136.3
Sample Variance 3.9028E+13 Sample Variance 3.03E+10
Kurtosis -1.346628996 Kurtosis 2.256501
Skewness -0.000390364 Skewness 1.704574
Range 19926540 Range 731003
Minimum 2286572 Minimum 391399
Maximum 22213112 Maximum 1122402
Sum 673107935 Sum 32520195
Count 56 Count 56

DATA MANIPULATION
ISRAEL:
total_vaccinations people_vaccinated people_fully_vaccinated new_vaccinations new_vaccinations_smoothed total_vaccinations_per_hundred
Standard Deviation 2210461 Standard Deviation 1043140 Standard Deviation 1148314 Standard Deviation 52638.97 Standard Deviation 30610.59 Standard Deviation 25.53761
Sample Variance 4.89E+12 Sample Variance 1.09E+12 Sample Variance 1.32E+12 Sample Variance 2.77E+09 Sample Variance 9.37E+08 Sample Variance 652.1697
Kurtosis -1.34084 Kurtosis -1.10782 Kurtosis -1.36658 Kurtosis -0.69617 Kurtosis -0.18862 Kurtosis -1.34087
Skewness -0.03202 Skewness -0.05541 Skewness -0.15187 Skewness 0.31999 Skewness 0.340385 Skewness -0.03207
Range 7051938 Range 3664359 Range 3387577 Range 195394 Range 116317 Range 81.47
Minimum 1069799 Minimum 1069799 Minimum 2 Minimum 37835 Minimum 68455 Minimum 12.36
Maximum 8121737 Maximum 4734158 Maximum 3387579 Maximum 233229 Maximum 184772 Maximum 93.83
Sum 2.72E+08 Sum 1.8E+08 Sum 91757983 Sum 7124093 Sum 7309894 Sum 3142.75
Count 59 Count 59 Count 56 Count 59 Count 59 Count 59
people_vaccinated_per_hundred people_fully_vaccinated_per_hundred new_vaccinations_smoothed_per_million stringency_index population population_density
Standard Deviation 12.05162 Standard Deviation 13.26739 Standard Deviation 3536.477 Standard Deviation 10.9472 Standard Deviation 0 Standard Deviation 1.72E-13
Sample Variance 145.2416 Sample Variance 176.0237 Sample Variance 12506668 Sample Variance 119.8412 Sample Variance 0 Sample Variance 2.96E-26
Kurtosis -1.10791 Kurtosis -1.3666 Kurtosis -0.18866 Kurtosis -1.35313 Kurtosis #DIV/0! Kurtosis -2.07143
Skewness -0.05537 Skewness -0.15189 Skewness 0.340389 Skewness -0.68572 Skewness #DIV/0! Skewness 1.026278
Range 42.34 Range 39.14 Range 13438 Range 29.63 Range 0 Range 0
Minimum 12.36 Minimum 0 Minimum 7909 Minimum 57.41 Minimum 8655541 Minimum 402.606
Maximum 54.7 Maximum 39.14 Maximum 21347 Maximum 87.04 Maximum 8655541 Maximum 402.606
Sum 2082.63 Sum 1060.11 Sum 844534 Sum 4545.49 Sum 5.11E+08 Sum 23753.75
Count 59 Count 56 Count 59 Count 59 Count 59 Count 59

DATA MANIPULATION
USA:
total_vaccinations people_vaccinated people_fully_vaccinated new_vaccinations new_vaccinations_smoothed total_vaccinations_per_hundred
Standard Deviation 21605201 Standard Deviation 13920237.26 Standard Deviation7115840.713 Standard Deviation 565355.6 Standard Deviation 450196.2244 Standard Deviation 6.460098603
Sample Variance 4.67E+14 Sample Variance 1.93773E+14 Sample Variance5.06352E+13 Sample Variance 3.2E+11 Sample Variance 2.02677E+11 Sample Variance 41.73287396
Kurtosis -1.18626 Kurtosis -1.217683423 Kurtosis -1.033337037 Kurtosis -0.78688 Kurtosis -1.041959037 Kurtosis -1.186077088
Skewness 0.210363 Skewness -0.069870225 Skewness 0.524256086 Skewness 0.090768 Skewness -0.510695223 Skewness 0.210421876
Range 71010247 Range 45546424 Range 23437834 Range 2156614 Range 1432724 Range 21.24
Minimum 4225756 Minimum 4225756 Minimum 1342086 Minimum 273209 Minimum 302329 Minimum 1.26
Maximum 75236003 Maximum 49772180 Maximum 24779920 Maximum 2429823 Maximum 1735053 Maximum 22.5
Sum 1.8E+09 Sum 1336783693 Sum 432734697 Sum 62609236 Sum 66596828 Sum 537.02
Count 51 Count 50 Count 42 Count 46 Count 59 Count 51
people_vaccinated_per_hundred people_fully_vaccinated_per_hundred new_vaccinations_smoothed_per_million stringency_index population population_density
Standard Deviation 4.162046 Standard Deviation 2.12789887 Standard Deviation 1346.12 Standard Deviation 1.810648233 Standard Deviation 0 Standard Deviation2.87E-14
Sample Variance 17.32263 Sample Variance 4.5279536 Sample Variance 1812038 Sample Variance 3.278447025 Sample Variance 0 Sample Variance8.22E-28
Kurtosis -1.21725 Kurtosis -1.032419277 Kurtosis -1.04194 Kurtosis -1.798032086 Kurtosis #DIV/0! Kurtosis -2.07143
Skewness -0.06987 Skewness 0.524479072 Skewness -0.51078 Skewness -0.520883757 Skewness #DIV/0! Skewness 1.026278
Range 13.62 Range 7.01 Range 4284 Range 3.7 Range 0 Range 0
Minimum 1.26 Minimum 0.4 Minimum 904 Minimum 68.06 Minimum 331002647 Minimum 35.608
Maximum 14.88 Maximum 7.41 Maximum 5188 Maximum 71.76 Maximum 331002647 Maximum 35.608
Sum 399.74 Sum 129.37 Sum 199129 Sum 3729.28 Sum 19529156173 Sum 2100.872
Count 50 Count 42 Count 59 Count 53 Count 59 Count 59

DATA MANIPULATION
UK: KEY RATIOS:
Date
new People
Vaccinated
FirstDose / Total
PeopleVaccinated
First Dose *100
new People
Vaccinated Second
Dose / Total
PeopleVaccinatedSeco
ndDose *100
28-Feb-21 0.91687233 2.412798964
27-Feb-21 2.028432592 3.431842961
26-Feb-21 2.56321395 4.262821764
25-Feb-21 2.532752481 4.798535943
24-Feb-21 2.401915061 4.511515331
23-Feb-21 1.790792492 3.933164451
22-Feb-21 1.073560264 2.872331157
21-Feb-21 0.799595347 1.4699075
20-Feb-21 1.903518921 1.668378992
19-Feb-21 2.156296568 2.528414492
18-Feb-21 2.681123728 2.69118762
17-Feb-21 2.935563495 2.640119639
16-Feb-21 2.288850391 2.222075023
15-Feb-21 1.7716622 1.19652486
14-Feb-21 1.55529184 0.354872783
13-Feb-21 3.35516969 0.529276661
12-Feb-21 3.741220528 0.892741961
11-Feb-21 3.590550651 1.065282761
10-Feb-21 3.337081915 0.933173419
9-Feb-21 3.153642228 0.608407612
8-Feb-21 2.787177402 0.738005236
7-Feb-21 2.269300991 0.168168543
6-Feb-21 4.576006461 0.324787628
5-Feb-21 4.310108581 0.796773694
4-Feb-21 4.380256506 0.797639493
3-Feb-21 4.470869656 0.596664655
2-Feb-21 3.739530853 0.434101194
1-Feb-21 3.631785535 0.520736882
31-Jan-21 3.431856767 0.638596221
30-Jan-21 6.665557205 2.162902986
29-Jan-21 5.821213662 0.453341992
28-Jan-21 5.251670725 0.369887131
27-Jan-21 4.177983393 0.488787685
26-Jan-21 4.341753174 0.360640802
25-Jan-21 4.082061165 0.416555543
24-Jan-21 3.350523384 0.173865728
23-Jan-21 7.743509261 0.222075544
22-Jan-21 8.159347563 0.388590256
21-Jan-21 7.613731337 0.591264707
20-Jan-21 7.309267505 0.735072279
19-Jan-21 7.444302716 0.816065129
18-Jan-21 4.783131771 0.99919889
17-Jan-21 4.679555771 0.495024331
16-Jan-21 7.64723321 0.582142016
15-Jan-21 9.543956918 0.940457087
14-Jan-21 9.789777016 1.186055221
13-Jan-21 9.558564511 2.225002683
12-Jan-21 7.868006361 3.751471165
11-Jan-21 5.966159576 5.038734299

DATA MANIPULATION
ISRAEL: KEY RATIOS:
date
new_vaccinations_smoothed/popula
tion *100
1-Jan-21 0.091337336
2-Jan-21 0.098452989
3-Jan-21 0.101796467
4-Jan-21 0.105140247
5-Jan-21 0.102528485
6-Jan-21 0.108424208
7-Jan-21 0.114274917
8-Jan-21 0.126866961
9-Jan-21 0.139353266
10-Jan-21 0.165145507
11-Jan-21 0.190937748
12-Jan-21 0.193812347
13-Jan-21 0.214571698
14-Jan-21 0.225702727
15-Jan-21 0.241299279
16-Jan-21 0.245215562
17-Jan-21 0.249131542
18-Jan-21 0.253047825
19-Jan-21 0.275373327
20-Jan-21 0.269606001
21-Jan-21 0.276104136
22-Jan-21 0.294722719
23-Jan-21 0.319449711
24-Jan-21 0.339025083
25-Jan-21 0.340254379
26-Jan-21 0.338081284
27-Jan-21 0.350767588
28-Jan-21 0.373208496
29-Jan-21 0.378793043
30-Jan-21 0.390152771
31-Jan-21 0.400283506
1-Feb-21 0.409498538
2-Feb-21 0.398782612
3-Feb-21 0.398167813
4-Feb-21 0.388863053
5-Feb-21 0.385605376
6-Feb-21 0.408285859
7-Feb-21 0.435371443
8-Feb-21 0.440014306
9-Feb-21 0.449945949
10-Feb-21 0.470074489
11-Feb-21 0.482799764
12-Feb-21 0.500270017
13-Feb-21 0.500812611
14-Feb-21 0.503811983
15-Feb-21 0.502142812
16-Feb-21 0.518518814
17-Feb-21 0.496839229
18-Feb-21 0.48974563
19-Feb-21 0.482278621
20-Feb-21 0.459539527
21-Feb-21 0.440491946
22-Feb-21 0.436988953
23-Feb-21 0.423463079
24-Feb-21 0.439492256
25-Feb-21 0.454737451
26-Feb-21 0.46909504
27-Feb-21 0.497047385
28-Feb-21 0.524181005

VISUAL PRESENTATION:
UK:

CONTINUE:
ISRAEL:

CONTINUE:
US:

CONCLUSION
From above analysis, ratios and charts this has been concluded that vaccination process
in UK has been reported as continuous progress along with upward trends in overall
vaccinated people with first and second dose. Other than this, in both USA and Israel
vaccinations of people shown up lining trend in terms of total people vaccinated. But
comparative analysis with respect to country’s population shows that Israel is most
efficient and effective among other two nations in terms of vaccination because Israel
has vaccinated more than three forth of its population and this shows positive mark in
the study.

REFERENCES
Books and Journal:
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.
e performances of missing data handling methods in ability estimation from sparse
data. Educational and Psychological Measurement, 80(5), pp.932-954.
COnline:
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>

THANK YOU