Worldometers.com (Worldometer, 2021) is a website which tracks daily vital statistics on COVID cases worldwide. A new excel spreadsheet, found on blackboard with the case 3 assignment, contains COVID data for the top 20 countries (as at September 2nd 2021) in the world based on the total number of cases. Included in the data is a table showing summary statistics for the top 20 countries including; 1. Percent of the Population with a Case 2. Percent of Total Cases Recovered 3. Percent of Deaths in the Population 4. Average Active Cases Per Million 5. Average Deaths per Million 6. Average Tested per Population As Epidemiologists, each group has been tasked to statistically prove if the three countries you worked .n for Cases 1 and 2 differ on these summary statistics. In particular, your manager is interested in; 1. Differences in Proportions from the Top 20 countries from the first 3 summary statistics on the prior page. 2. Differences in Averages from the top 20 countries from summary statistics 4, 5 and 6 on the prior page. 3. Dependency by Country on total cases, total recovered, and total deaths (i.e. do these statistical values depend on country for any of your 3 assigned countries and if so which countries). . 19 1.77 31,119 5 Country 6 USA 7 India 8 Brazil 9 Russia 10 UK 11 France 12 Turkey 13 Argentina 14 Iran 15 Colombia 16 Spain 17 Italy 18 Indonesia 19 Germany 20 Mexico 21 Poland 22 South Africa 23 Ukraine Total Cases New Cases Total Deaths New Deaths Per Million 40,513,018 177,568 662,853 1,565 32,902,345 45,482 439,916 357 20,830,712 26,497 582,004 776 6,956,318 18,985 184,812 798 6,862,904 38,154 132,920 178 6,799,240 15,911 114,680 103 6,435,773 23,496 57,283 283 5,195,601 4,653 112,195 190 5,055,512 30,279 108,988 595 4,913,031 1,949 125,097 81 4,871,444 9,561 84,640 168 4,553,241 6,761 129,352 34 4,109,093 8,955 134,356 680 3,983,983 13,950 92,794 37 3,369,747 17,337 260,503 1,177 2,889,424 402 75,367 7 2,796,405 9,202 82,914 418 2,290,848 2,477 53,877 44 2,152,118 1,108 198,364 35 2,020,258 16,395 33,680 148 Total Recovered New Recovered Active Cases Per Million Serious, Critical Total Tests Per Population Population 4.70 31,199,835 61,899 8,650,330 25,956 25,646 588,561,720 333,273,117 0.26 32,056,085 34,988 406,344 291 8,944 524,868,734 0.38 1,395,864,796 3.62 19,801,725 25,852 446,983 2,086 8,318 56,897,224 0.27 214,326,515 5.47 6,218,048 18,669 553,458 3,791 2,300 179,500,000 1.23 146,007,717 2.61 5,533,227 1,196,757 17,521 1,030 271,963,982 3.98 68,303,189 1.57 6,310,859 26,320 373,701 5,710 2,270 126,641,689 1.94 65,442,555 3.31 5,872,385 20,004 506,105 5,926 633 77,045,381 0.90 85,399,787 4.16 4,884,418 6,319 198,988 4,356 2,497 22,307,283 0.49 45,680,639 6.98 4,269,508 32,193 677,016 7,942 7,831 28,213,229 0.33 85,249,030 1.57 4,742,640 1,931 45,294 879 542 24,268,743 0.47 51,516,791 3.59 4,399,864 18,514 386,940 8,272 1,491 60,618,810 1.30 46,775,978 0.56 4,286,991 6,372 136,898 555 84,632,503 1.40 60,357,722 2.46 3,798,099 21,208 176,638 638 32,644,851 0.12 276,904,286 0.44 3,750,700 6,100 140,489 1,671 1,169 68,329,706 0.81 84,097,444 9.02 2,715,043 14,311 394,201 3,020 4,798 9,803,728 0.08 130,516,103 0.19 2,657,177 93 156,880 4,150 56 19,819,235 0.52 37,798,076 6.95 2,568,465 7,860 145,026 2,410 546 16,593,467 0.28 60,182,391 1.01 2,209,754 889 27,217 627 177 12,031,985 0.28 43,425,933 1.04 N/A N/A N/A 1,237 16,840,906 0.50 33,508,377 1.33 1,839,991 10,662 146,587 1,317 3,050 18,874,753 0.17 111,284,985 2,268 24. Peru 25 Philippines 26 27 Top 20 Totals 28 345,303 3,375,915,431 14,765,852 73,090 2,240,457,929 7,674 149,114,814 469,122 3,666,595 169,501,015 Summary Statistics for Top 20 Countries Listed by Total Cases Percent of Population Percent of Total Percent of Deaths With a Case Cases Recovered in the Population Average Active Cases Average Deaths Average Tested Per Million Per Million Per Population 5201.63 0.86 5.02% 87.97% 0.109% Standard Deviations 3.04 2.531360313 6442 107142 0.919622738