PA8 Solution

Cases - cumulative Cases - newly
Cases -
Name WHO Region total per 100000 reported in last
cumulative total
population 7 days
United States of America Americas 30,888,765 9,332 475,641
India South-East Asia 13,689,453 992 1,003,404
Brazil Americas 13,482,023 6,343 497,067
France Europe 4,987,689 7,669 228,766
Russian Federation Europe 4,657,883 3,192 60,015
The United Kingdom Europe 4,373,347 6,442 17,013
Turkey Europe 3,903,573 4,628 373,972
Italy Europe 3,779,594 6,337 100,650
Spain Europe 3,336,637 7,049 20,031
Germany Europe 3,022,323 3,634 121,555
Poland Europe 2,599,850 6,849 143,141
Colombia Americas 2,536,198 4,984 89,979
Argentina Americas 2,532,562 5,604 139,070
Mexico Americas 2,280,213 1,769 29,755
Iran (Islamic Republic of) Eastern Mediterranean 2,093,452 2,492 147,488
Ukraine Europe 1,872,785 4,282 103,621
Peru Americas 1,647,694 4,997 65,327
Czechia Europe 1,585,037 14,822 29,792
Indonesia South-East Asia 1,571,824 575 33,857
South Africa Africa 1,559,113 2,629 6,697
Netherlands Europe 1,357,340 7,797 50,102
Chile Americas 1,082,920 5,665 50,308
Canada Americas 1,060,157 2,809 52,051
Romania Europe 1,008,490 5,218 30,504
Iraq Eastern Mediterranean 932,899 2,319 52,908
Belgium Europe 927,229 8,047 21,476
Philippines Western Pacific 876,225 800 72,838
Sweden Europe 857,401 8,302 25,524
Israel Europe 836,261 9,662 1,905
Portugal Europe 827,765 8,040 4,430
Hungary Europe 728,078 7,453 36,335
Pakistan Eastern Mediterranean 725,602 328 33,371
Bangladesh South-East Asia 691,957 420 47,518
Jordan Eastern Mediterranean 669,300 6,560 29,856
Serbia Europe 645,173 9,314 23,798
Switzerland Europe 620,278 7,167 12,316
Austria Europe 575,714 6,468 18,035
Japan Western Pacific 508,802 402 21,257
Morocco Eastern Mediterranean 502,277 1,361 3,948
Lebanon Eastern Mediterranean 497,854 7,294 17,352
United Arab Emirates Eastern Mediterranean 485,675 4,911 13,527
Saudi Arabia Eastern Mediterranean 399,277 1,147 5,900
Bulgaria Europe 375,115 5,396 18,256
Slovakia Europe 371,168 6,801 5,435
Malaysia Western Pacific 362,173 1,119 10,144
Panama Americas 358,611 8,311 2,234
Ecuador Americas 347,070 1,967 10,293
Belarus Europe 336,881 3,565 8,591
Kazakhstan Europe 325,234 1,732 15,362
occupied Palestinian territ Eastern Mediterranean 299,636 5,874 17,066
Greece Europe 297,086 2,772 19,809
Croatia Europe 294,874 7,266 13,975
Georgia Europe 290,129 7,273 5,171
Azerbaijan Europe 287,144 2,832 15,310
Bolivia (Plurinational State Americas 282,095 2,417 7,161
Nepal South-East Asia 280,524 963 2,314
Tunisia Eastern Mediterranean 272,940 2,309 11,763
Dominican Republic Americas 258,039 2,379 3,604
Kuwait Eastern Mediterranean 248,729 5,824 10,180
Republic of Moldova Europe 241,820 5,995 6,030
Ireland Europe 241,330 4,861 2,864
Denmark Europe 238,306 4,093 4,509
Paraguay Americas 235,292 3,299 14,085
Ethiopia Africa 230,944 201 13,617
Lithuania Europe 227,889 8,156 6,989
Slovenia Europe 226,787 10,821 6,357
Costa Rica Americas 223,917 4,396 5,109
Egypt Eastern Mediterranean 211,307 206 5,575
Armenia Europe 204,053 6,886 6,180
Guatemala Americas 203,309 1,135 7,629
Honduras Americas 195,780 1,977 5,149
Qatar Eastern Mediterranean 190,998 6,629 6,664
Bosnia and Herzegovina Europe 184,698 5,630 8,285
Venezuela (Bolivarian Repub Americas 174,887 615 8,764
Oman Eastern Mediterranean 173,029 3,388 8,755
Libya Eastern Mediterranean 168,676 2,455 5,234
Nigeria Africa 163,793 79 463
Bahrain Eastern Mediterranean 157,729 9,270 7,938
Kenya Africa 146,156 272 6,708
Uruguay Americas 144,642 4,164 26,885
Myanmar South-East Asia 142,596 262 85
North Macedonia Europe 142,034 6,817 6,867
Albania Europe 128,518 4,466 1,723
Algeria Africa 118,645 271 906
Puerto Rico Americas 115,299 4,030 5,466
Estonia Europe 115,080 8,659 4,400
Republic of Korea Western Pacific 110,688 216 4,458
Latvia Europe 107,818 5,652 3,594
Norway Europe 103,620 1,930 4,946
China Western Pacific 103,136 7 187
Kosovo[1] Europe 98,298 5,474 4,174
Sri Lanka South-East Asia 95,394 445 1,799
Montenegro Europe 94,417 15,033 1,110
Ghana Africa 91,260 294 314
Kyrgyzstan Europe 90,599 1,389 1,322
Zambia Africa 90,064 490 1,055
Cuba Americas 87,385 772 6,775
Uzbekistan Europe 85,291 255 1,356
Finland Europe 82,278 1,489 2,541
Mozambique Africa 68,792 220 565
El Salvador Americas 66,489 1,025 998
Luxembourg Europe 63,880 10,203 1,466
Singapore Western Pacific 60,678 1,037 183
Afghanistan Eastern Mediterranean 57,364 147 585
Cameroon Africa 57,337 216 3,417
Cyprus Europe 52,033 5,860 3,755
Namibia Africa 45,787 1,802 901
Côte d’Ivoire Africa 45,227 171 386
Botswana Africa 43,444 1,847 1,734
Jamaica Americas 42,763 1,444 1,750
Uganda Africa 41,174 90 158
Senegal Africa 39,465 236 372
Zimbabwe Africa 37,307 251 373
Thailand South-East Asia 34,575 50 5,004
Malawi Africa 33,859 177 186
Sudan Eastern Mediterranean 31,833 73 -
Malta Europe 29,661 5,764 382
Australia Western Pacific 29,419 115 62
Democratic Republic of th Africa 28,542 32 187
Madagascar Africa 28,541 103 2,832
Maldives South-East Asia 25,701 4,755 793
Angola Africa 23,549 72 832
Rwanda Africa 23,535 182 851
Guinea Africa 21,032 160 522
Gabon Africa 20,636 927 773
Syrian Arab Republic Eastern Mediterranean 20,331 116 805
Mayotte Africa 19,706 7,223 216
Cabo Verde Africa 19,110 3,437 1,171
French Polynesia Western Pacific 18,666 6,645 33
Réunion Africa 18,425 2,058 1,839
Eswatini Africa 18,394 1,585 1,040
Mauritania Africa 18,035 388 96
French Guiana Americas 17,549 5,875 417
Mongolia Western Pacific 15,718 479 4,898
Tajikistan Europe 13,714 144 -
Burkina Faso Africa 12,989 62 164
Haiti Americas 12,855 113 52
Andorra Europe 12,581 16,283 295
Somalia Eastern Mediterranean 12,566 79 658
Belize Americas 12,487 3,140 31
Guadeloupe Americas 12,304 3,075 414
Togo Africa 12,034 145 785
Mali Africa 12,002 59 1,501
Curaçao Americas 11,355 6,920 2,521
Guyana Americas 11,149 1,417 569
Lesotho Africa 10,709 500 2
South Sudan Africa 10,381 93 100
Congo Africa 10,084 183 -
Aruba Americas 10,050 9,413 547
Djibouti Eastern Mediterranean 9,975 1,010 1,044
Bahamas Americas 9,439 2,400 176
Suriname Americas 9,302 1,586 139
Martinique Americas 8,887 2,368 724
Papua New Guinea Western Pacific 8,821 99 1,415
Trinidad and Tobago Americas 8,404 601 226
Guam Western Pacific 7,631 4,521 18
Benin Africa 7,515 62 202
Equatorial Guinea Africa 7,219 515 160
Iceland Europe 6,267 1,721 26
Gambia Africa 5,602 232 97
Central African Republic Africa 5,465 113 152
Yemen Eastern Mediterranean 5,450 18 565
Nicaragua Americas 5,366 81 40
Niger Africa 5,074 21 32
San Marino Europe 4,962 14,621 98
Cambodia Western Pacific 4,696 28 1,872
Chad Africa 4,641 28 46
Seychelles Africa 4,563 4,640 233
Saint Lucia Americas 4,348 2,368 51
Gibraltar Europe 4,277 12,695 2
Sierra Leone Africa 4,008 50 19
Comoros Africa 3,859 444 64
Barbados Americas 3,730 1,298 51
Guinea-Bissau Africa 3,680 187 18
Eritrea Africa 3,466 98 126
Burundi Africa 3,262 27 292
Jersey Europe 3,230 2,996 1
United States Virgin Island Americas 2,988 2,861 49
Liechtenstein Europe 2,848 7,350 60
Viet Nam Western Pacific 2,707 3 70
Monaco Europe 2,377 6,057 44
Turks and Caicos Islands Americas 2,357 6,088 13
Sao Tome and Principe Africa 2,266 1,034 26
New Zealand Western Pacific 2,231 46 63
Sint Maarten Americas 2,185 5,095 34
Liberia Africa 2,066 41 5
Bermuda Americas 1,891 3,037 491
Saint Vincent and the GrenAmericas 1,806 1,628 42
Saint Martin Americas 1,703 4,405 16
Isle of Man Europe 1,575 1,852 4
Bonaire Americas 1,493 7,138 108
Antigua and Barbuda Americas 1,198 1,223 28
Mauritius Africa 1,176 92 64
Timor-Leste South-East Asia 1,074 81 308
Saint Barthélemy Americas 928 9,388 18
Bhutan South-East Asia 921 119 30
Guernsey Europe 821 1,274 -
Other Other 745 -
Faroe Islands Europe 661 1,353 -
Cayman Islands Americas 516 785 15
United Republic of TanzaniAfrica 509 1 -
Wallis and Futuna Western Pacific 446 3,966 17
Brunei Darussalam Western Pacific 219 50 5
British Virgin Islands Americas 178 589 24
Dominica Americas 165 229 -
Northern Mariana Islands Western Pacific 160 278 1
Grenada Americas 158 140 2
New Caledonia Western Pacific 121 42 -
Fiji Western Pacific 68 8 1
Falkland Islands (Malvinas)Americas 60 1,723 8
Lao People's Democratic ReWestern Pacific 52 1 3
Saint Kitts and Nevis Americas 44 83 -
Greenland Europe 31 55 -
Anguilla Americas 29 193 4
Holy See Europe 26 3,214 -
Saint Pierre and Miquelon Americas 25 431 1
Montserrat Americas 20 400 -
Sint Eustatius Americas 20 637 -
Solomon Islands Western Pacific 19 3 -
Saba Americas 6 310 -
Marshall Islands Western Pacific 4 7 -
Samoa Western Pacific 4 2 -
Vanuatu Western Pacific 3 1 -
American Samoa Western Pacific - - -
Cook Islands Western Pacific - - -
Democratic People's RepublSouth-East Asia - - -
Kiribati Western Pacific - - -
Micronesia (Federated StatWestern Pacific - - -
Nauru Western Pacific - - -
Niue Western Pacific - - -
Palau Western Pacific - - -
Pitcairn Islands Western Pacific - - -
Tokelau Western Pacific - - -
Tonga Western Pacific - - -
Turkmenistan Europe - - -
Tuvalu Western Pacific - - -
Global 136,291,755 1,746 4,762,299
Cases - newly reported Cases - newly Deaths - cumulative Deaths - newly
Deaths -
in last 7 days per reported in last total per 100000 reported in last 7
cumulative total
100000 population 24 hours population days
144 48,354 556,853 168.23 5084
73 161,736 171,058 12.4 5511
234 37,017 353,137 166.14 21704
352 7,556 98,505 151.45 2251
41 8,173 103,601 70.99 2495
25 3,568 127,100 187.23 238
443 54,562 34,182 40.53 1726
169 9,780 114,612 192.17 3286
42 - 76,179 160.94 110
146 10,810 78,746 94.68 1643
377 13,203 59,126 155.77 4061
177 17,483 65,889 129.49 1795
308 15,262 57,779 127.84 1580
23 1,793 209,338 162.36 5191
176 23,311 64,764 77.11 1432
237 11,680 37,758 86.34 2741
198 7,927 54,903 166.51 2026
279 3,853 28,038 262.19 869
12 4,829 42,656 15.59 841
11 655 53,356 89.96 361
288 6,757 16,791 96.46 163
263 6,421 24,483 128.07 806
138 7,618 23,315 61.77 240
158 2,323 25,248 130.62 1058
132 7,953 14,757 36.69 255
186 2 23,503 203.98 252
66 11,378 15,149 13.82 1714
247 - 13,621 131.89 15
22 189 6,304 72.83 54
43 271 16,916 164.3 37
372 2,837 23,980 245.46 1882
15 4,584 15,501 7.02 680
29 7,201 9,822 5.96 504
293 3,565 7,855 76.99 572
344 2,965 5,773 83.34 276
142 5 9,766 112.84 30
203 1,770 9,448 106.14 233
17 2,516 9,425 7.45 176
11 175 8,909 24.14 52
254 1,008 6,703 98.21 260
137 1,928 1,533 15.5 21
17 842 6,765 19.43 61
263 3,122 14,619 210.3 833
100 106 10,630 194.76 536
31 1,317 1,333 4.12 38
52 234 6,163 142.84 28
58 253 17,298 98.04 311
91 843 2,363 25.01 69
82 - 3,963 21.11 151
335 2,762 3,150 61.75 174
185 1,606 8,961 83.6 508
344 1,936 6,358 156.67 245
130 1,374 3,894 97.61 62
151 1,151 3,944 38.9 233
61 525 12,451 106.66 127
8 496 3,053 10.48 17
100 1,079 9,332 78.96 339
33 341 3,392 31.27 41
238 1,635 1,412 33.06 47
149 603 5,409 134.09 231
58 385 4,785 96.39 67
77 514 2,443 41.96 13
197 1,547 4,827 67.68 428
12 1,948 3,208 2.79 208
250 1,106 3,713 132.89 90
303 287 4,411 210.46 25
100 482 3,030 59.48 47
5 818 12,487 12.2 277
209 726 3,775 127.39 148
43 238 7,020 39.18 126
52 255 4,804 48.5 160
231 973 335 11.63 29
253 444 7,487 228.21 534
31 1,101 1,778 6.25 116
171 1,480 1,789 35.03 67
76 851 2,828 41.16 71
0 - 2,060 1 2
467 1,267 562 33.03 21
12 486 2,368 4.4 124
774 3,262 1,462 42.09 361
0 9 3,206 5.89 0
330 190 4,262 204.57 285
60 125 2,321 80.65 47
2 129 3,134 7.15 26
191 1,102 2,155 75.33 24
331 637 1,049 78.93 85
9 542 1,775 3.46 23
188 210 1,990 104.32 56
92 1,661 687 12.8 11
0 23 4,854 0.33 3
232 345 1,986 110.6 70
8 263 598 2.79 17
177 - 1,373 218.61 47
1 - 754 2.43 2
20 227 1,532 23.48 23
6 35 1,227 6.67 5
60 854 467 4.12 31
4 177 634 1.89 2
46 225 874 15.82 28
2 34 791 2.53 9
15 - 2,054 31.67 24
234 230 772 123.3 12
3 25 30 0.51 0
2 122 2,529 6.5 17
13 - 851 3.21 72
423 528 273 30.74 11
35 260 575 22.63 37
1 21 268 1.02 12
74 770 663 28.19 47
59 263 676 22.83 58
0 34 337 0.74 2
2 34 1,079 6.44 16
3 19 1,542 10.37 17
7 965 97 0.14 2
1 32 1,132 5.92 8
- - 2,063 4.7 0
74 47 402 78.12 3
0 14 909 3.56 0
0 - 745 0.83 0
10 478 506 1.83 47
147 84 67 12.39 0
3 92 554 1.69 11
7 109 316 2.44 5
4 83 136 1.04 6
35 - 127 5.71 8
5 105 1,385 7.91 62
79 63 167 61.21 5
211 105 184 33.09 11
12 14 141 50.19 0
205 917 135 15.08 20
90 1,018 669 57.66 0
2 13 450 9.68 1
140 - 94 31.47 1
149 704 25 0.76 13
- - 91 0.95 0
1 33 153 0.73 3
0 15 251 2.2 0
382 36 121 156.6 4
4 160 624 3.93 56
8 - 318 79.97 1
103 - 189 47.24 6
9 28 116 1.4 4
7 158 414 2.04 22
1,536 723 66 40.22 28
72 105 255 32.42 12
0 2 315 14.7 0
1 9 114 1.02 1
- - 137 2.48 0
512 154 92 86.17 6
106 99 100 10.12 20
45 - 189 48.06 0
24 24 182 31.02 5
193 - 59 15.72 5
16 219 69 0.77 2
16 22 146 10.43 1
11 4 136 80.58 0
2 - 93 0.77 0
11 - 106 7.56 2
7 9 29 7.96 0
4 - 168 6.95 2
3 - 74 1.53 1
2 89 1,069 3.58 113
1 - 179 2.7 1
0 - 189 0.78 1
289 6 86 253.4 1
11 181 33 0.2 11
0 5 167 1.02 1
237 35 24 24.4 2
28 1 64 34.85 3
6 - 94 279.01 0
0 3 79 0.99 0
7 - 146 16.79 0
18 11 44 15.31 1
1 - 66 3.35 0
4 19 10 0.28 0
2 108 6 0.05 0
1 - 69 64.01 0
47 17 26 24.9 0
155 - 54 139.37 0
0 11 35 0.04 0
112 3 31 78.99 1
34 - 17 43.91 0
12 - 35 15.97 0
1 4 26 0.54 0
79 11 27 62.96 0
0 - 85 1.68 0
788 118 16 25.69 2
38 16 10 9.01 0
41 - 13 33.63 0
5 - 29 34.1 0
516 18 14 66.94 3
29 1 30 30.63 2
5 - 12 0.94 0
23 28 2 0.15 2
182 - 1 10.12 0
4 3 1 0.13 0
- - 14 21.72 0
- 13 0
- - 1 2.05 0
23 - 2 3.04 0
- - 21 0.04 0
151 5 5 44.46 1
1 - 3 0.69 0
79 - 1 3.31 0
- - - 0 0
2 - 2 3.47 0
2 1 1 0.89 0
- - - 0 0
0 - 2 0.22 0
230 - - 0 0
0 1 - 0 0
- - - 0 0
- - - 0 0
27 4 - 0 0
- - - 0 0
17 - - 0 0
- - 1 20 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
- - - 0 0
61 567,849 2,941,128 37.6762868879117 82838
Deaths - newly Deaths - newly
Transmission
reported in last 7 days reported in last 24
Classification
per 100000 population hours
1.54 328 Community transmission
0.4 879 Clusters of cases
6 78 Community transmission
0 0 Clusters of cases
0 0 Sporadic cases
0 0 Sporadic cases
0 0 Pending
0.38 19 Sporadic cases
0 0 Sporadic cases
0 0 No cases
0 0 Sporadic cases
0 Not applicable
0 0 Sporadic cases
0 0 Sporadic cases
0 0 Pending
0 0 Sporadic cases
0 0 Pending
0 0 Sporadic cases
0 0 Sporadic cases
0 0 Sporadic cases
0 0 Sporadic cases
0 0 Sporadic cases
0 0 Sporadic cases
0 0 No cases
0 0 Sporadic cases
0 0 Sporadic cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
0 0 No cases
1.06116709412879 9521
A Define formulas to calculate the following stats:
Which is the maximum numbes of cumulative cases (Cases - cumulative total)
1 registered by country?
2 Maximum number of "Deaths - newly reported in last 7 days"
3 Min number of "Deaths - newly reported in last 24 hours"
4 "Cases - cumulative total" for Europe region
5 "Cases - newly reported in last 7 days" for Africa
6 "Deaths - cumulative total" for Western Pacific
7 How many countries have Community transmission
8 How many countries have Sporadic cases
How many countries have over 1000 newly reported deaths in last 24 hours
9 (Deaths - newly reported in last 24 hours)
10 What is the average value for "Cases - newly reported in last 24 hours" for
countries with Clusters of cases
B Calculate the total number of cumulative cases for the following regions
Americas
South-East Asia
Europe
Eastern Mediterranean
Africa
Western Pacific
Other
C Create a 3D column chart that displays the cumulative cases for the above regions
Cumulative cases per region

60,000,000
50,000,000
40,000,000
30,000,000
20,000,000
10,000,000
-
s pe ca c r
ica s ia ro
a n
ri cifi he
er tA ne Af Pa
t
as Eu rr a O
Am E it e er
n
h- ed
t
out M es
S n W
er
a st
E
10,000,000
-
s pe n ca c r
ica s ia ro
a ri cifi he
r tA ne Af a Ot
e
as Eu rr a P
Am E it e er
n
h- ed
t
out M es
S n W
er
a st
E
136,291,755
82,838
0
47,891,858
52,299
33,952
147
19
4,548.37
58,401,105
16,534,019
47,891,858
8,166,899
3,184,442
2,112,687
745

PA8 Solution

Uploaded by

Copyright:

Available Formats

PA8 Solution

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

PA8 Solution

Uploaded by

Copyright:

Available Formats

Cases - cumulative Cases - newly

Cumulative cases per region

You might also like