Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An Analysis of the spread Coronavirus (COVID-19) Pandemic across countries Compilation of the COVID-19 epidemic data commenced on the 31st of December 2019. First identified

An Analysis of the spread Coronavirus (COVID-19) Pandemic across countries

Compilation of the COVID-19 epidemic data commenced on the 31st of December 2019. First identified in Wuhan, China, and by April 2020, had spread to more than 200 countries worldwide with more than 3 million confirmed positive cases and about 235,000 deaths worldwide. In September 2021, worldwide, the number of confirmed positive cases has surpassed 231 million and the number of deaths has exceeded 4.74 million. In December 2020, a number of COVID19 vaccinations completed their trials and were approved by several governments of countries to be used for their citizens. The number of worldwide confirmed COVID-19 positive cases and number of deaths as reported on the 26 th of September 2021 by country (for countries which have had more than 1000 confirmed COVID19 cases) is given in 5COVID19WORLD.xlsx. A Using the data in worksheet Cases&Deaths of 5COVID19WORLD.xlsx answer the following questions.

a. Identify the top 15 countries by ranking the total number of confirmed COVID-19 cases and draw a bar chart. Comment on the chart.

b. Use an appropriate chart to show the share of the number of confirmed cases in the top 15 countries in the world total (combine the rest of the countries as Other).

c. As the population sizes are different, to compare the number of confirmed COVID-19 positive cases across countries, considering the number of confirmed cases per 10,000 persons would provide a better comparison across countries. For the top 15 countries identified in part a, calculate the total number of confirmed cases per 10,000 persons. Sort the data from largest to smallest and draw a bar chart of number of confirmed cases per 10,000 over countries for the top 15 countries. Comment on the chart and compare it with the bar chart in part a.

d. Identify the top 15 countries by ranking the total number of COVID-19 deaths and draw a bar chart. Comment on the chart.

e. Use an appropriate chart to show the share of the number of deaths in the top 15 countries in the world total (combine the rest of the countries as Other).

f. As the population sizes are different, to compare the number of COVID-19 related deaths across countries, considering the number of deaths per 10,000 persons would provide a better comparison across countries. For the top 15 countries identified in part d, calculate the total number of deaths per 10,000 persons. Sort the data from largest to smallest and draw a bar chart of number of deaths per 10,000 over countries for the top 15 countries. Comment on the chart and compare it with the bar chart in part d.

g. Obtain the proportion (in percentage) of number of COVID-19 related deaths per number of COVID-19 cases for each country. Identify the top 15 countries with the highest percentage among all countries and present them in a bar chart. Compare your results with the results in part f.

h. Based on your analysis above in parts c, f and g, in your opinion, comment on which countries have been successful and which countries are of concern in dealing with the COVID-19 pandemic with respect to number of cases and deaths.

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. X Calibri 11 A A e IA === == Paste B I UPR - A Kha Unde Cipboard 5 Font Algement F fx A B C D E F 1 Number of doses of COVID-19 vaccinations and population by county as at 26 September 2021 Confirmed COVID-19 cases 2 No Country COVID-19 deaths 7199 Population* 32,890,171 3 154960 4 2629 2,829,741 5 44,700,000 6 7 16/354 202574 15167 54795 2902 5249840 257620 5767 130 1487 64 114849 8 78,015 32,097,671 99,337 45,808,74/ 2,963,300 25,871,119 9 7 Argentina 10 8 Armenia 11 9 Australia 97559 5239 1231 10961 12 10 Austria 734302 8,950,544 13 11 Azerbaijan 479814 10,139,196 14 12 Bahamas 20603 393,450 15 13 Bahrain 274745 1,501,635 16 14 Bangladesh 1550371 6433 522 1389 27393 64 4081 25554 171,421,212 17 15 Barbados 288,000 18 16 Belarus 7401 528229 1233/23 9,349,645 19 17 Belgium 11,5/2,034 20 18 Belize 19600 402 430,191 21 19 Renin 22958 154 12,506,347 22 20 Bhutan 2599 756,129 11,797,257 23 21 Bolivia 498790 24 22 Bosnia and Herzegovina 230801 3,320,954 25 23 Botswana 2,410,338 213,728,559 26 24 Brazil 27 25 Brunei 176427 21343304 5960 492365 14131 453,600 6,875,040 28 26 Bulgaria 29 27 Burkina Faso 21,510,181 Cases & Deaths + Ready Accessibility: Good to go J188 GUAWNH 1 Afghanistan 2 Albania Algeria Andorra Angola Antigua and Barbuda Vaccinations S 3 18698 10422 2360 594200 33 20449 180 Search (Alt+0) 9 Wrap Text General $%9 Number G Cases per 10,000 Deaths per 10,000 persons persons 47.11 2.19 591.41 9.29 45.32 1.29 1944.11 16.66 17.07 0.46 292.14 6.44 1146.03 25.07 869.37 17.68 37.71 0.48 820.40 12.25 473.23 6.34 523.65 13.27 1829.64 9.25 90.44 1.60 256.98 2.22 564.97 4.36 1066.12 22.08 455.61 9.34 18.36 0.12 34.37 0.04 422.80 15.85 694.98 31.38 731.96 9.79 998.62 27.80 131.39 0.73 716.16 29.74 6.57 0.08 Merge & Center Y 08 5 H D E Conditional Format as Cell Formatting Table Styles Styles J H Deaths per confirmed case (%) 4.65 1.57 2.85 0.86 2.71 2.21 2.19 2.03 1.26 1.49 1.34 2.53 0.51 1.77 0.86 0.77 2.07 2.05 0.67 0.12 3.75 4.52 1.34 2.78 0.55 4.15 1.27 an I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P [IK] 0 " Comments 0 IN Sensitivity Sensitivity + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. Calibri 11 A A === e X IA Kha Paste I UPR - A Unde Cipboard Font Aignment J188 A B 29 27 Burkina Faso 30 28 Burundi 31 29 Cambodia 32 30 Cameroon 33 31 Canada 34 32 Cabo Verde 3.5 33 Central African Republic 36 34 Chad 37 35 Chile 38 36 China 39 37 Colombia 40 38 Comoros 41 39 Costa Rica 42 40 Croatia 43 41 Cuba 44 42 Cyprus 45 43 Czechia 46 44 Democratic Republic of the 47 45 Denmark 48 46 Djibouti 49 47 Dominica 50 48 Dominican Republic 51 49 Timor-Leste 52 50 Ecuador 53 51 Egypt 54 52 52 El Salvador 55 53 Equatorial Guinea 56 54 Eritrea 57 55 Estonia 58 56 Eswatini CHA Cases & Deaths Accessibility: Good to go Ready fx 14131 16356 108257 85414 1608019 37400 11371 5031 1650985 96081 4950253 4112 521182 399054 84/494 117967 1688953 56617 358352 12253 3197 356934 19350 507858 300945 102024 11806 6694 153071 45/42 Vaccinations + D 180 38 2218 1368 2/690 334 100 174 37432 4636 126102 147 6189 8580 /163 552 30452 1083 2642 162 13 4035 113 32720 1/149 3174 142 42 1343 1212 CAZA E 21,510,181 12,574,571 15,552,211 24,348,251 38,418,261 563,198 5,633,412 16,818,391 19,678,363 1411.//8./24 51,049,498 758,316 5,163,038 4,036,355 11,181,595 888,005 10,694,480 92,378,000 5,850,189 9/6,107 72,000 10,535,535 1,317,780 17,823,116 102,366,818 6,825,935 1,505,588 3,601,000 1,330,068 1,172,000 KARANG DAN Search (Alt+0) Wrap Text Merge & Center F 6.57 13.01 69.61 35.08 418.56 664.06 20.18 2.99 838.98 0.68 969.70 54.23 1009.45 988.65 757.94 1328.45 1579.28 6.13 612.55 125.53 444.03 338.79 146.84 284.94 29.40 149.47 78.41 18.59 1150.85 390.29 na Y F General $%9 Number 0.08 0.03 1.43 0.56 7.21 5.93 0.18 0.10 19.02 0.03 24.70 1.94 11.99 21.26 6.41 6.22 28.47 0.12 4.52 1.66 1.81 3.83 0.86 18.36 1.68 4.65 0.94 0.12 10.10 10.34 G 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles J 1.27 0.23 2.05 1.60 1./2 0.89 0.88 3.46 2.27 4.83 2.55 3.57 1.19 2.15 0.85 0.47 1.80 1.91 0.74 1.32 0.41 1.13 0.58 6.44 5.70 3.11 1.20 0.63 0.88 2.65 I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. Calibri 11 A A e X IA Kha === == Paste I UPR - A Unde Cipboard Font Algement B J188 A 58 56 Eswatini 59 57 Ethiopia 60 58 58 Fiji 61 59 Finland 62 60 France 63 61 Gabon 64 62 Gambia 65 63 Georgia 66 64 Germany 67 65 65 Ghana 68 66 Greece 69 67 Grenada 70 68 Guatemala 71 69 Guinea 72 70 Guinea-Bissau 73 71 Guyana 74 72 Haiti 75 73 Honduras 76 74 |HongKong 77 75 Hungary 78 76 Iceland 79 77 India 80 78 Indonesia 81 79 Iran 82 80 Iraq 83 81 Israel 84 82 Italy 85 86 84 Jamaica 87 85 85 Japan A Ready 83 Ivory Coast fx Cases & Deaths Accessibility: Good to go C 45742 340845 50701 138578 70806/5 29126 9911 605360 4199029 126621 644869 4766 548604 30348 6099 30907 21486 363017 12185 8200/8 11632 33652745 4206253 5519728 1991628 1262945 4657215 59778 82349 1693690 (+) Vaccinations D E 1,172,000 117,876,000 1212 5.369 590 1066 11/15/ 898,402 5,509,132 178 335 67,445,000 2,233,272 2,487,000 8787 3,728,573 93398 83,121,363 30,792,608 10,718,565 1146 14655 105 13331 377 135 113.000 17,109,746 12,907,395 1,646,077 754 743,699 607 11,743,017 9679 9,450,711 213 7,394,700 30151 9,730,772 33 371,580 446918 1,382,357,386 141381 271,350,000 119082 84,809,748 220/2 41.190,700 7649 130653 593 1824 1/4/5 9,407,020 59,126,079 27,087,732 2,734,093 125,210,000 Search (Alt+0) Wrap Text Merge & Center F 390.29 28.92 564.35 251.53 1049.84 130.42 39.85 1623.57 505.17 41.12 601.64 421.77 320.64 23.51 37.05 415.58 18.30 384.12 16.48 842.77 313.04 243.44 155.01 650.84 483.51 1342.56 787.68 22.07 301.19 135.27 Y F General $%9 Number G 10.34 0.46 6.57 1.93 1/.3/ 0.80 1.35 23.57 11.24 0.37 13.67 9.29 7.79 0.29 0.82 10.14 0.52 10.24 0.29 30.99 0.89 3.23 5.21 14.04 5.36 8.13 22.10 0.22 6.67 1.40 acc 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles J 2.65 1.58 1.16 0.77 1.65 0.61 3.38 1.45 2.22 0.91 2.27 2.20 2.43 1.24 2.21 2.44 2.83 2.67 1.75 3.68 0.28 1.33 3.36 2.16 1.11 0.61 2.81 0.99 2.21 1.03 I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. Calibri 11 A A === e X IA Kha Paste I UPR - A == Undu Cipboard Font Algement B J188 A 87 85 85 Japan 88 86 Jordan 89 87 Kazakhstan 90 88 Kenya 91 89 Kosovo 92 90 Kuwait 94 92 Laus 95 93 Latvia 96 94 Lebanon 97 95 Lesotho 98 96 Liberia 99 97 Libya 100 98 Liechtenstein 101 99 Lithuania 102 100 Luxembourg 103 101 Madagascar 104 102 Malawi 105 103 Malaysia 106 104 Maldives 107 105 Mali 108 106 Malta 109 107 Mauritania 110 108 Mauritius 111 109 Mexico 112 110 Moldova 113 111 Monaco 114 112 Mongolia 115 113 Montenegro 116 114 Morocco Cases & Deaths Rearly Accessibility: Good to go fx 91 Kyrgyzstan C 1693690 818796 952385 248392 159/93 411447 178202 21527 154219 621/35 14395 5792 335991 3439 324329 77762 42898 61497 2185131 84290 15153 37077 35819 15161 3619115 288377 3303 294775 129285 9285/1 Traini Vaccinations + D 17475 10669 15503 5096 2931 2445 2599 16 2682 8277 403 283 4588 60 4896 835 958 2275 25159 231 547 457 768 71 2/4/03 6679 33 1206 1892 14132 E 125,210,000 11,041,804 19,008,344 47,561,296 1,/82,115 4,670,713 6,663,000 7,337,783 1,882,200 6,769,000 2,159,000 4,661,010 6,959,000 39,062 2,786,006 634,730 26,923,353 18,898,441 32,717,600 383,135 20,856,000 514,564 4,271,197 1,266,030 126,014,024 2,597,100 38,350 3,399,424 621,306 36,379,353 AAAAAAAA Search (Alt+0) Wrap Text Merge & Center F 135.27 741.54 501.04 52.22 896.65 880.91 267.45 29.34 819.36 918.50 66.67 12.43 482.82 880.40 1164.14 1225.12 15.93 32.54 667.88 2200.01 7.27 720.55 83.86 119.75 287.20 1110.38 861.28 867.13 2080.86 255.25 innel Y F General $%9 Number 1.40 9.66 B.16 1.07 16.45 5.23 3.90 0.02 14.25 12.23 1.87 0.61 6.59 15.36 17,57 13.16 0.36 1.20 7.69 6.03 0.26 8.88 1.80 0.56 21.80 25.72 8.60 3.55 30.45 3.88 G 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles I J 1.03 1.30 1.63 2.05 1.83 0.59 1.46 0.07 1.74 1.33 2.80 4.89 1.37 1.74 1.51 1.07 2.23 3.70 1.15 0.2/ 3.61 1.23 2.14 0.47 7.59 2.32 1.00 0.41 1.46 1.52 SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. X Calibri 11 A A === e IA Paste I UPR - A == Kha Undu Cipboard Font Aignment fx J188 A B 116 114 Morocco 117 115 Mozambique 118 116 Myanmar 119 117 Namibia 120 118 Nepal 121 119 Netherlands 122 120 New Zealand 123 121 Nicaragua 124 122 Niger 125 123 Nigeria 126 124 North Macedonia 127 125 Norway 128 126 Oran 129 127 Palestine 130 128 Pakistan 131 129 Panama 132 130 Papua New Guinea 133 131 Paraguay 134 132 Peru 135 133 Philippines 136 134 Poland 137 135 Portugal 138 136 Qatar 139 137 Republic of Ireland 140 138 Republic of the Congo 141 139 Romania 142 140 Russia 143 141 Rwanda 144 142 Saint Kitts and Nevis 145 143 Saint Lucia A ReacyAccessbity: Good to go C 928571 150494 456620 127227 790662 2032868 4184 13730 5974 204201 189551 186554 303551 395677 1238668 465993 19278 459779 2172261 24/01/5 2902591 1066346 236231 383218 14113 1187773 7291097 96727 1800 11053 (+) Cases & Deaths Vaccinations D 14132 1909 17465 3492 1108/ 18555 27 203 201 26/3 6577 850 4093 4018 27566 7201 225 16142 199228 3/405 75571 17952 604 5209 191 36230 199450 1248 10 183 E 36,379,353 30,832,244 55,294,979 2,550,226 30,378,055 17,640,731 5,130,528 6,595,674 24,112,753 211,401,000 2,068,808 5,402,171 4,513,666 5,227,193 225,200,000 4,278,500 9,122,994 7,353,038 33,035,304 110,8/6,031 38,162,000 10,347,892 2,799,202 5,011,500 5,657,000 19,186,201 146,171,015 12,955,768 54,000 178,696 Search (Alt+0) Wrap Text Merge & Center F 255.25 48.81 82.58 498.89 260.27 1152.37 8.16 20.82 2.48 9.66 916.23 345.33 672.52 756.96 55.00 1089.15 21.13 625.29 657.56 222.7/9 760.60 1030.50 843.92 764.68 24.95 619.08 498.81 74.66 333.33 618.54 ann an Y F General $%9 Number 3.88 0.62 3.16 13.69 3.65 10.52 0.05 0.31 0.08 0.13 31.79 1.57 9.07 7.69 1.22 16.83 0.25 21.95 60.31 3.37 19.80 17.35 2.16 10.39 0.34 18.88 13.64 0.96 1.85 10.24 G 08 R H E H D Conditional Format as Cell Formatting Table Styles Styles I J 1.52 1.27 3.82 2.74 1.40 0.91 0.65 1.48 3.36 1.31 3.47 0.46 1.35 1.02 2.23 1.55 1.17 3.51 9.17 1.51 2.60 1.68 0.26 1.36 1.35 3.05 2.74 1.29 0.56 1.66 AZA I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. X Calibri 11 A A === e Paste IA Kha I UPR - A Cipboard Font Algement J188 fx A B 145 143 Saint Lucia 145 144 Saint Vincent and the Grena 147 145 San Marino 148 146 Sao Tome and Principe 149 147 Saudi Arabia 150 148 Senegal 151 149 Serbia 152 150 Seychelles 153 151 Sierra Leone 154 152 Singapore 155 153 Slovakia 156 154 Slovenia 157 155 Somalia 158 156 South Africa 159 15/ South Korea 160 158 South Sudan 161 159 Spain 162 160 Sri Lanka 163 161 Sudan 164 162 Suriname 165 163 Sweden 166 164 Switzerland 167 165 Syria 168 166 Taiwan 169 167 Tajikistan 170 168 Tanzania 171 169 Thailand 172 170 Togo 173 171 Trinidad and Tobago 174 1/2 Tunisia Cases & Deaths ReacyAccessbity: Good to go Unda 11053 3247 5427 3338 546882 73728 905677 21281 6393 85953 407799 289225 19723 2895976 3011/2 11926 4946601 512531 38077 39908 1149407 833385 32580 16181 1/484 1367 1549285 25163 49822 704914 maincoal Vaccinations (+) D 183 17 90 49 8694 1855 8008 110 121 76 12596 4531 1103 87001 2450 128 86229 12609 2894 845 14821 11043 2198 841 125 50 16143 222 1451 24/32 E 178,696 110,696 33,599 214,610 35,013,414 17,223,497 6,871,547 98,963 8,297,882 5,685,807 5,459,781 2,108,977 16.360.000 60,142,978 51,6/1,569 13,249,924 47,394,223 21,919,000 43,821,310 598,000 10,416,585 8,680,890 18,276,000 23,470,633 9,504,000 59,441,988 66,698,630 7,886,000 1,366,725 11,746,695 ACERCA Search (Alt+0) Wrap Text Merge & Center F 618.54 293.33 1615.23 155.54 156.19 42.81 1318.01 2150.40 7.70 151.17 746.91 1371.40 12.06 481.52 58.29 9.00 1043.71 233.83 8.69 667.36 1103.44 960.02 17.83 6.89 18.40 0.23 232.28 31.91 364.54 600.10 ana nal Y F General $%9 Number G 10.24 1.54 26.79 2.28 2.48 1.08 11.65 11.12 0.15 0.13 23.07 21.48 0.67 14.47 0.4/ 0.10 18.19 5.75 0.66 14.13 14.23 12.72 1.20 0.36 0.13 0.01 2.42 0.28 10.62 21.05 Zal 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles J 1.66 0.52 1.66 1.47 1.59 2.52 0.88 0.52 1.89 0.09 3.09 1.57 5.59 3.00 0.81 1.07 1.74 2.46 7.60 2.12 1.29 1.33 6.75 5.20 0.71 3.66 1.04 0.88 2.91 3.51 I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. X Calibri 11 A A ===. e Paste IA Kha I UPR - A == Undu Cipboard Font Aignment J188 A B 174 172 Tunisia 175 173 Turkey C 704914 7013609 123066 2495068 D 24732 62938 3143 59202 E 11,746,695 83,614,362 42,885,900 41,362,393 176 174 Uganda 177 175 Ukraine 178 176 United Arab Emirates 734596 9,503,738 179 177 United Kingdom 67,081,234 332,429,717 180 178 United States 181 179 Uruguay 7667290 42901255 388424 171588 362040 746678 2089 136465 687746 6052 1218 4395 18400 1682 3645 3,554,915 35,111,371 182 180 Uzbekistan 183 181 Venezuela 28,705,000 184 182 Vietnam 185 183 Yemen 8891 208829 97,580,000 30,491,000 18.400,556 186 184 Zambia 187 185 Zimbabwe 129505 4603 15,790,716 188 186 World [a] 231516829 4743196 7,898,304,000 189 187 190 188 191 189 192 190 193 191 194 192 195 193 196 197 198* Estimaed United Nations, 2021 199 a. Countries which do not report data for a column are not included in that column's world total. 200 201 202 203 Cases & Deaths Vaccinations + Accessibility: Good to go 4 Ready fx Search (Alt+0) Wrap Text Merge & Center F 600.10 838.80 28.70 603.22 772.95 1142.99 1290.54 1092.64 48.87 126.12 76.52 2.92 113.49 82.01 293.12 Y F General $%9 Number G 21.05 7.53 0.73 14.31 2.20 20.34 20.69 17.02 0.35 1.53 1.89 0.55 1.98 2.92 6.01 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles I J 3.51 0.90 2.55 2.37 0.28 1.78 1.60 1.56 0.71 1.21 2.46 18.92 1.75 3.55 2.05 SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. X Calibri 11 A A e IA === == Paste B I UPR - A Kha Unde Cipboard 5 Font Algement F fx A B C D E F 1 Number of doses of COVID-19 vaccinations and population by county as at 26 September 2021 Confirmed COVID-19 cases 2 No Country COVID-19 deaths 7199 Population* 32,890,171 3 154960 4 2629 2,829,741 5 44,700,000 6 7 16/354 202574 15167 54795 2902 5249840 257620 5767 130 1487 64 114849 8 78,015 32,097,671 99,337 45,808,74/ 2,963,300 25,871,119 9 7 Argentina 10 8 Armenia 11 9 Australia 97559 5239 1231 10961 12 10 Austria 734302 8,950,544 13 11 Azerbaijan 479814 10,139,196 14 12 Bahamas 20603 393,450 15 13 Bahrain 274745 1,501,635 16 14 Bangladesh 1550371 6433 522 1389 27393 64 4081 25554 171,421,212 17 15 Barbados 288,000 18 16 Belarus 7401 528229 1233/23 9,349,645 19 17 Belgium 11,5/2,034 20 18 Belize 19600 402 430,191 21 19 Renin 22958 154 12,506,347 22 20 Bhutan 2599 756,129 11,797,257 23 21 Bolivia 498790 24 22 Bosnia and Herzegovina 230801 3,320,954 25 23 Botswana 2,410,338 213,728,559 26 24 Brazil 27 25 Brunei 176427 21343304 5960 492365 14131 453,600 6,875,040 28 26 Bulgaria 29 27 Burkina Faso 21,510,181 Cases & Deaths + Ready Accessibility: Good to go J188 GUAWNH 1 Afghanistan 2 Albania Algeria Andorra Angola Antigua and Barbuda Vaccinations S 3 18698 10422 2360 594200 33 20449 180 Search (Alt+0) 9 Wrap Text General $%9 Number G Cases per 10,000 Deaths per 10,000 persons persons 47.11 2.19 591.41 9.29 45.32 1.29 1944.11 16.66 17.07 0.46 292.14 6.44 1146.03 25.07 869.37 17.68 37.71 0.48 820.40 12.25 473.23 6.34 523.65 13.27 1829.64 9.25 90.44 1.60 256.98 2.22 564.97 4.36 1066.12 22.08 455.61 9.34 18.36 0.12 34.37 0.04 422.80 15.85 694.98 31.38 731.96 9.79 998.62 27.80 131.39 0.73 716.16 29.74 6.57 0.08 Merge & Center Y 08 5 H D E Conditional Format as Cell Formatting Table Styles Styles J H Deaths per confirmed case (%) 4.65 1.57 2.85 0.86 2.71 2.21 2.19 2.03 1.26 1.49 1.34 2.53 0.51 1.77 0.86 0.77 2.07 2.05 0.67 0.12 3.75 4.52 1.34 2.78 0.55 4.15 1.27 an I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P [IK] 0 " Comments 0 IN Sensitivity Sensitivity + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. Calibri 11 A A === e X IA Kha Paste I UPR - A Unde Cipboard Font Aignment J188 A B 29 27 Burkina Faso 30 28 Burundi 31 29 Cambodia 32 30 Cameroon 33 31 Canada 34 32 Cabo Verde 3.5 33 Central African Republic 36 34 Chad 37 35 Chile 38 36 China 39 37 Colombia 40 38 Comoros 41 39 Costa Rica 42 40 Croatia 43 41 Cuba 44 42 Cyprus 45 43 Czechia 46 44 Democratic Republic of the 47 45 Denmark 48 46 Djibouti 49 47 Dominica 50 48 Dominican Republic 51 49 Timor-Leste 52 50 Ecuador 53 51 Egypt 54 52 52 El Salvador 55 53 Equatorial Guinea 56 54 Eritrea 57 55 Estonia 58 56 Eswatini CHA Cases & Deaths Accessibility: Good to go Ready fx 14131 16356 108257 85414 1608019 37400 11371 5031 1650985 96081 4950253 4112 521182 399054 84/494 117967 1688953 56617 358352 12253 3197 356934 19350 507858 300945 102024 11806 6694 153071 45/42 Vaccinations + D 180 38 2218 1368 2/690 334 100 174 37432 4636 126102 147 6189 8580 /163 552 30452 1083 2642 162 13 4035 113 32720 1/149 3174 142 42 1343 1212 CAZA E 21,510,181 12,574,571 15,552,211 24,348,251 38,418,261 563,198 5,633,412 16,818,391 19,678,363 1411.//8./24 51,049,498 758,316 5,163,038 4,036,355 11,181,595 888,005 10,694,480 92,378,000 5,850,189 9/6,107 72,000 10,535,535 1,317,780 17,823,116 102,366,818 6,825,935 1,505,588 3,601,000 1,330,068 1,172,000 KARANG DAN Search (Alt+0) Wrap Text Merge & Center F 6.57 13.01 69.61 35.08 418.56 664.06 20.18 2.99 838.98 0.68 969.70 54.23 1009.45 988.65 757.94 1328.45 1579.28 6.13 612.55 125.53 444.03 338.79 146.84 284.94 29.40 149.47 78.41 18.59 1150.85 390.29 na Y F General $%9 Number 0.08 0.03 1.43 0.56 7.21 5.93 0.18 0.10 19.02 0.03 24.70 1.94 11.99 21.26 6.41 6.22 28.47 0.12 4.52 1.66 1.81 3.83 0.86 18.36 1.68 4.65 0.94 0.12 10.10 10.34 G 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles J 1.27 0.23 2.05 1.60 1./2 0.89 0.88 3.46 2.27 4.83 2.55 3.57 1.19 2.15 0.85 0.47 1.80 1.91 0.74 1.32 0.41 1.13 0.58 6.44 5.70 3.11 1.20 0.63 0.88 2.65 I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. Calibri 11 A A e X IA Kha === == Paste I UPR - A Unde Cipboard Font Algement B J188 A 58 56 Eswatini 59 57 Ethiopia 60 58 58 Fiji 61 59 Finland 62 60 France 63 61 Gabon 64 62 Gambia 65 63 Georgia 66 64 Germany 67 65 65 Ghana 68 66 Greece 69 67 Grenada 70 68 Guatemala 71 69 Guinea 72 70 Guinea-Bissau 73 71 Guyana 74 72 Haiti 75 73 Honduras 76 74 |HongKong 77 75 Hungary 78 76 Iceland 79 77 India 80 78 Indonesia 81 79 Iran 82 80 Iraq 83 81 Israel 84 82 Italy 85 86 84 Jamaica 87 85 85 Japan A Ready 83 Ivory Coast fx Cases & Deaths Accessibility: Good to go C 45742 340845 50701 138578 70806/5 29126 9911 605360 4199029 126621 644869 4766 548604 30348 6099 30907 21486 363017 12185 8200/8 11632 33652745 4206253 5519728 1991628 1262945 4657215 59778 82349 1693690 (+) Vaccinations D E 1,172,000 117,876,000 1212 5.369 590 1066 11/15/ 898,402 5,509,132 178 335 67,445,000 2,233,272 2,487,000 8787 3,728,573 93398 83,121,363 30,792,608 10,718,565 1146 14655 105 13331 377 135 113.000 17,109,746 12,907,395 1,646,077 754 743,699 607 11,743,017 9679 9,450,711 213 7,394,700 30151 9,730,772 33 371,580 446918 1,382,357,386 141381 271,350,000 119082 84,809,748 220/2 41.190,700 7649 130653 593 1824 1/4/5 9,407,020 59,126,079 27,087,732 2,734,093 125,210,000 Search (Alt+0) Wrap Text Merge & Center F 390.29 28.92 564.35 251.53 1049.84 130.42 39.85 1623.57 505.17 41.12 601.64 421.77 320.64 23.51 37.05 415.58 18.30 384.12 16.48 842.77 313.04 243.44 155.01 650.84 483.51 1342.56 787.68 22.07 301.19 135.27 Y F General $%9 Number G 10.34 0.46 6.57 1.93 1/.3/ 0.80 1.35 23.57 11.24 0.37 13.67 9.29 7.79 0.29 0.82 10.14 0.52 10.24 0.29 30.99 0.89 3.23 5.21 14.04 5.36 8.13 22.10 0.22 6.67 1.40 acc 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles J 2.65 1.58 1.16 0.77 1.65 0.61 3.38 1.45 2.22 0.91 2.27 2.20 2.43 1.24 2.21 2.44 2.83 2.67 1.75 3.68 0.28 1.33 3.36 2.16 1.11 0.61 2.81 0.99 2.21 1.03 I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. Calibri 11 A A === e X IA Kha Paste I UPR - A == Undu Cipboard Font Algement B J188 A 87 85 85 Japan 88 86 Jordan 89 87 Kazakhstan 90 88 Kenya 91 89 Kosovo 92 90 Kuwait 94 92 Laus 95 93 Latvia 96 94 Lebanon 97 95 Lesotho 98 96 Liberia 99 97 Libya 100 98 Liechtenstein 101 99 Lithuania 102 100 Luxembourg 103 101 Madagascar 104 102 Malawi 105 103 Malaysia 106 104 Maldives 107 105 Mali 108 106 Malta 109 107 Mauritania 110 108 Mauritius 111 109 Mexico 112 110 Moldova 113 111 Monaco 114 112 Mongolia 115 113 Montenegro 116 114 Morocco Cases & Deaths Rearly Accessibility: Good to go fx 91 Kyrgyzstan C 1693690 818796 952385 248392 159/93 411447 178202 21527 154219 621/35 14395 5792 335991 3439 324329 77762 42898 61497 2185131 84290 15153 37077 35819 15161 3619115 288377 3303 294775 129285 9285/1 Traini Vaccinations + D 17475 10669 15503 5096 2931 2445 2599 16 2682 8277 403 283 4588 60 4896 835 958 2275 25159 231 547 457 768 71 2/4/03 6679 33 1206 1892 14132 E 125,210,000 11,041,804 19,008,344 47,561,296 1,/82,115 4,670,713 6,663,000 7,337,783 1,882,200 6,769,000 2,159,000 4,661,010 6,959,000 39,062 2,786,006 634,730 26,923,353 18,898,441 32,717,600 383,135 20,856,000 514,564 4,271,197 1,266,030 126,014,024 2,597,100 38,350 3,399,424 621,306 36,379,353 AAAAAAAA Search (Alt+0) Wrap Text Merge & Center F 135.27 741.54 501.04 52.22 896.65 880.91 267.45 29.34 819.36 918.50 66.67 12.43 482.82 880.40 1164.14 1225.12 15.93 32.54 667.88 2200.01 7.27 720.55 83.86 119.75 287.20 1110.38 861.28 867.13 2080.86 255.25 innel Y F General $%9 Number 1.40 9.66 B.16 1.07 16.45 5.23 3.90 0.02 14.25 12.23 1.87 0.61 6.59 15.36 17,57 13.16 0.36 1.20 7.69 6.03 0.26 8.88 1.80 0.56 21.80 25.72 8.60 3.55 30.45 3.88 G 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles I J 1.03 1.30 1.63 2.05 1.83 0.59 1.46 0.07 1.74 1.33 2.80 4.89 1.37 1.74 1.51 1.07 2.23 3.70 1.15 0.2/ 3.61 1.23 2.14 0.47 7.59 2.32 1.00 0.41 1.46 1.52 SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. X Calibri 11 A A === e IA Paste I UPR - A == Kha Undu Cipboard Font Aignment fx J188 A B 116 114 Morocco 117 115 Mozambique 118 116 Myanmar 119 117 Namibia 120 118 Nepal 121 119 Netherlands 122 120 New Zealand 123 121 Nicaragua 124 122 Niger 125 123 Nigeria 126 124 North Macedonia 127 125 Norway 128 126 Oran 129 127 Palestine 130 128 Pakistan 131 129 Panama 132 130 Papua New Guinea 133 131 Paraguay 134 132 Peru 135 133 Philippines 136 134 Poland 137 135 Portugal 138 136 Qatar 139 137 Republic of Ireland 140 138 Republic of the Congo 141 139 Romania 142 140 Russia 143 141 Rwanda 144 142 Saint Kitts and Nevis 145 143 Saint Lucia A ReacyAccessbity: Good to go C 928571 150494 456620 127227 790662 2032868 4184 13730 5974 204201 189551 186554 303551 395677 1238668 465993 19278 459779 2172261 24/01/5 2902591 1066346 236231 383218 14113 1187773 7291097 96727 1800 11053 (+) Cases & Deaths Vaccinations D 14132 1909 17465 3492 1108/ 18555 27 203 201 26/3 6577 850 4093 4018 27566 7201 225 16142 199228 3/405 75571 17952 604 5209 191 36230 199450 1248 10 183 E 36,379,353 30,832,244 55,294,979 2,550,226 30,378,055 17,640,731 5,130,528 6,595,674 24,112,753 211,401,000 2,068,808 5,402,171 4,513,666 5,227,193 225,200,000 4,278,500 9,122,994 7,353,038 33,035,304 110,8/6,031 38,162,000 10,347,892 2,799,202 5,011,500 5,657,000 19,186,201 146,171,015 12,955,768 54,000 178,696 Search (Alt+0) Wrap Text Merge & Center F 255.25 48.81 82.58 498.89 260.27 1152.37 8.16 20.82 2.48 9.66 916.23 345.33 672.52 756.96 55.00 1089.15 21.13 625.29 657.56 222.7/9 760.60 1030.50 843.92 764.68 24.95 619.08 498.81 74.66 333.33 618.54 ann an Y F General $%9 Number 3.88 0.62 3.16 13.69 3.65 10.52 0.05 0.31 0.08 0.13 31.79 1.57 9.07 7.69 1.22 16.83 0.25 21.95 60.31 3.37 19.80 17.35 2.16 10.39 0.34 18.88 13.64 0.96 1.85 10.24 G 08 R H E H D Conditional Format as Cell Formatting Table Styles Styles I J 1.52 1.27 3.82 2.74 1.40 0.91 0.65 1.48 3.36 1.31 3.47 0.46 1.35 1.02 2.23 1.55 1.17 3.51 9.17 1.51 2.60 1.68 0.26 1.36 1.35 3.05 2.74 1.29 0.56 1.66 AZA I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. X Calibri 11 A A === e Paste IA Kha I UPR - A Cipboard Font Algement J188 fx A B 145 143 Saint Lucia 145 144 Saint Vincent and the Grena 147 145 San Marino 148 146 Sao Tome and Principe 149 147 Saudi Arabia 150 148 Senegal 151 149 Serbia 152 150 Seychelles 153 151 Sierra Leone 154 152 Singapore 155 153 Slovakia 156 154 Slovenia 157 155 Somalia 158 156 South Africa 159 15/ South Korea 160 158 South Sudan 161 159 Spain 162 160 Sri Lanka 163 161 Sudan 164 162 Suriname 165 163 Sweden 166 164 Switzerland 167 165 Syria 168 166 Taiwan 169 167 Tajikistan 170 168 Tanzania 171 169 Thailand 172 170 Togo 173 171 Trinidad and Tobago 174 1/2 Tunisia Cases & Deaths ReacyAccessbity: Good to go Unda 11053 3247 5427 3338 546882 73728 905677 21281 6393 85953 407799 289225 19723 2895976 3011/2 11926 4946601 512531 38077 39908 1149407 833385 32580 16181 1/484 1367 1549285 25163 49822 704914 maincoal Vaccinations (+) D 183 17 90 49 8694 1855 8008 110 121 76 12596 4531 1103 87001 2450 128 86229 12609 2894 845 14821 11043 2198 841 125 50 16143 222 1451 24/32 E 178,696 110,696 33,599 214,610 35,013,414 17,223,497 6,871,547 98,963 8,297,882 5,685,807 5,459,781 2,108,977 16.360.000 60,142,978 51,6/1,569 13,249,924 47,394,223 21,919,000 43,821,310 598,000 10,416,585 8,680,890 18,276,000 23,470,633 9,504,000 59,441,988 66,698,630 7,886,000 1,366,725 11,746,695 ACERCA Search (Alt+0) Wrap Text Merge & Center F 618.54 293.33 1615.23 155.54 156.19 42.81 1318.01 2150.40 7.70 151.17 746.91 1371.40 12.06 481.52 58.29 9.00 1043.71 233.83 8.69 667.36 1103.44 960.02 17.83 6.89 18.40 0.23 232.28 31.91 364.54 600.10 ana nal Y F General $%9 Number G 10.24 1.54 26.79 2.28 2.48 1.08 11.65 11.12 0.15 0.13 23.07 21.48 0.67 14.47 0.4/ 0.10 18.19 5.75 0.66 14.13 14.23 12.72 1.20 0.36 0.13 0.01 2.42 0.28 10.62 21.05 Zal 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles J 1.66 0.52 1.66 1.47 1.59 2.52 0.88 0.52 1.89 0.09 3.09 1.57 5.59 3.00 0.81 1.07 1.74 2.46 7.60 2.12 1.29 1.33 6.75 5.20 0.71 3.66 1.04 0.88 2.91 3.51 I SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100% AutoSave off A SCOVID19WORLD (1) File Home Insert Page Layout Formulas Data Review View Help 5. X Calibri 11 A A ===. e Paste IA Kha I UPR - A == Undu Cipboard Font Aignment J188 A B 174 172 Tunisia 175 173 Turkey C 704914 7013609 123066 2495068 D 24732 62938 3143 59202 E 11,746,695 83,614,362 42,885,900 41,362,393 176 174 Uganda 177 175 Ukraine 178 176 United Arab Emirates 734596 9,503,738 179 177 United Kingdom 67,081,234 332,429,717 180 178 United States 181 179 Uruguay 7667290 42901255 388424 171588 362040 746678 2089 136465 687746 6052 1218 4395 18400 1682 3645 3,554,915 35,111,371 182 180 Uzbekistan 183 181 Venezuela 28,705,000 184 182 Vietnam 185 183 Yemen 8891 208829 97,580,000 30,491,000 18.400,556 186 184 Zambia 187 185 Zimbabwe 129505 4603 15,790,716 188 186 World [a] 231516829 4743196 7,898,304,000 189 187 190 188 191 189 192 190 193 191 194 192 195 193 196 197 198* Estimaed United Nations, 2021 199 a. Countries which do not report data for a column are not included in that column's world total. 200 201 202 203 Cases & Deaths Vaccinations + Accessibility: Good to go 4 Ready fx Search (Alt+0) Wrap Text Merge & Center F 600.10 838.80 28.70 603.22 772.95 1142.99 1290.54 1092.64 48.87 126.12 76.52 2.92 113.49 82.01 293.12 Y F General $%9 Number G 21.05 7.53 0.73 14.31 2.20 20.34 20.69 17.02 0.35 1.53 1.89 0.55 1.98 2.92 6.01 08 R H H D E Conditional Format as Cell Formatting Table Styles Styles I J 3.51 0.90 2.55 2.37 0.28 1.78 1.60 1.56 0.71 1.21 2.46 18.92 1.75 3.55 2.05 SI TIX Insert Delete Format Cells K L M WES Yash Gupta YG 40 Q Sort & Find & Analyze Data Filter Select Editing Analysis N P |||| 0 Comments 0 IN Sensitivity Sensitivity 0 + X Share RA 100%

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions