我用Excel 统计了一个各国新冠感染人数比例

Georgia 23.50%
Czechia 23.05%
San Marino 22.49%
Slovenia 22.32%
Lithuania 19.49%
St. Barth 19.10%
UK 18.63%
Aruba 18.35%
Estonia 18.18%
Netherlands 18.13%
Belgium 17.91%
Croatia 17.58%
Maldives 17.22%
USA 16.55%
French Polynesia 16.37%
Luxembourg 15.98%
Liechtenstein 15.95%
Isle of Man 15.84%
Bahrain 15.72%
French Guiana 15.60%
Slovakia 15.41%
Ireland 15.31%
Channel Islands 15.20%
Switzerland 14.94%
Serbia 14.94%
Latvia 14.91%
France 14.87%
Israel 14.80%
Austria 14.08%
Guadeloupe 14.00%
Denmark 13.52%
Spain 13.46%
Portugal 13.38%
Cyprus 13.26%
Cayman Islands 13.19%
Hungary 13.06%
Martinique 12.93%
Sweden 12.90%
Monaco 12.82%
Caribbean Netherlands 12.67%
Curaçao 12.54%
Argentina 12.24%
Sint Maarten 11.92%
Malta 11.84%
Uruguay 11.79%
Faeroe Islands 11.73%
Armenia 11.61%
Mongolia 11.60%
Greece 11.31%
Panama 11.18%
British Virgin Islands 11.13%
Costa Rica 11.05%
Turkey 11.02%
Anguilla 11.01%
Poland 10.87%
Bulgaria 10.83%
North Macedonia 10.78%
Saint Martin 10.72%
Lebanon 10.67%
Brazil 10.37%
Bermuda 10.37%
Jordan 10.25%
Colombia 9.96%
Italy 9.91%
Barbados 9.83%
Kuwait 9.55%
Romania 9.50%
Dominica 9.43%
Moldova 9.35%
Chile 9.32%
Botswana 9.06%
Bosnia and Herzegovina 8.96%
Qatar 8.92%
Suriname 8.79%
Cuba 8.53%
Germany 8.48%
Réunion 8.47%
Ukraine 8.46%
Malaysia 8.35%
Palestine 8.33%
Turks and Caicos 8.31%
Belize 7.95%
Mayotte 7.88%
Iceland 7.85%
UAE 7.54%
Belarus 7.40%
Saint Lucia 7.34%
Albania 7.29%
Iran 7.24%
Cabo Verde 7.21%
Russia 7.19%
Norway 7.13%
Peru 6.81%
Trinidad and Tobago 6.49%
Paraguay 6.43%
Bahamas 6.14%
Tunisia 6.05%
Azerbaijan 6.00%
Fiji 5.89%
Oman 5.76%
South Africa 5.70%
Namibia 5.65%
Canada 5.60%
Eswatini 5.59%
Libya 5.54%
Grenada 5.46%
Saint Kitts and Nevis 5.43%
St. Vincent Grenadines 5.25%
Kazakhstan 5.17%
Iraq 5.04%
Guyana 4.97%
Bolivia 4.97%
Singapore 4.71%
Finland 4.69%
Greenland 4.59%
New Caledonia 4.42%
Antigua and Barbuda 4.32%
Wallis and Futuna 4.15%
Dominican Republic 3.79%
Honduras 3.74%
Brunei 3.49%
Guatemala 3.41%
Vatican City 3.36%
Thailand 3.17%
Jamaica 3.14%
Ecuador 3.03%
Mexico 3.03%
Nepal 2.77%
Kyrgyzstan 2.76%
Sri Lanka 2.73%
Morocco 2.56%
Philippines 2.54%
India 2.49%
Falkland Islands 2.29%
El Salvador 1.87%
Mauritius 1.84%
Gabon 1.78%
Vietnam 1.76%
Saint Pierre Miquelon 1.74%
Sao Tome and Principe 1.72%
Venezuela 1.57%
Saudi Arabia 1.56%
Indonesia 1.53%
Australia 1.52%
Laos 1.49%
Timor-Leste 1.46%
Zimbabwe 1.39%
Japan 1.38%
Djibouti 1.35%
Zambia 1.33%
Lesotho 1.31%
S. Korea 1.23%
Myanmar 0.97%
Bangladesh 0.95%
Equatorial Guinea 0.93%
Montserrat 0.92%
Mauritania 0.85%
Rwanda 0.82%
Comoros 0.73%
Cambodia 0.71%
Uzbekistan 0.58%
Pakistan 0.57%
Mozambique 0.57%
Kenya 0.53%
Algeria 0.48%
Ghana 0.44%
Senegal 0.43%
Gambia 0.40%
Cameroon 0.40%
Papua New Guinea 0.39%
Afghanistan 0.39%
Malawi 0.37%
Egypt 0.37%
Togo 0.35%
Congo 0.35%
Ethiopia 0.35%
Bhutan 0.34%
Guinea-Bissau 0.32%
Uganda 0.29%
New Zealand 0.28%
Syria 0.28%
Nicaragua 0.26%
Ivory Coast 0.25%
CAR 0.25%
Angola 0.23%
Guinea 0.23%
Haiti 0.22%
Eritrea 0.22%
Burundi 0.22%
Benin 0.20%
Madagascar 0.17%
Tajikistan 0.17%
Hong Kong 0.17%
Somalia 0.14%
South Sudan 0.13%
Liberia 0.12%
Nigeria 0.11%
Sudan 0.10%
Mali 0.10%

美国还算好，比欧洲最烂的强。印度就更低了。

为什么费这时间？ 这个网站早就提供了， 还是动态的， 每天都刷新。
https://www.worldometers.info/coronavirus/

sort by "Tot Cases/1M pop", for example, 200,000/1M = 20%

用excel的是不是傻逼？

不会用其他工具？

你难道没用excel 统计一个新冠检测人数比例？！

【 在 motrin (motrin) 的大作中提到: 】
: Georgia 23.50%
: Czechia 23.05%
: San Marino 22.49%
: Slovenia 22.32%
: Lithuania 19.49%
: St. Barth 19.10%
: UK 18.63%
: Aruba 18.35%
: Estonia 18.18%
: Netherlands 18.13%
: ...................

Excel 功能强大， 工作上经常用到它， 尤其是报表。

没看到CHINA,

算湖北14万，那就是0.01%，其它可忽略。

感觉区域群免在20-30%这个数量级上。

为什么墨西哥只有3%，美国15%？