Econometrics STATA regression

anissasonthalia
question.xlsx

Sheet1

country fiscal_4 totalcases infectionrate medage hospitalbeds_avg gdppercapita_2018 democracy_2018 presidental
Afghan 0.5 996 0.0000268 17.299999 0.5 563.82566 -1 1
Albania 2.53466 562 0.0001961 36.200001 2.9 5079.4011 9 0
Algeria -8 2629 0.0000623 27.5 4764.3756 2 0
Angola 0.043703 24 7.79E-07 16.4 3229.6197 -2 1
Argentina 1.2 2930 0.0000659 30.799999 4.8666667 10043.509 9 1
Armenia 0.178286 1339 0.0004536 33.900002 4.05 4406.7064 7 0
Australia 10.8 6612 0.0002647 37.400002 3.8 56842.306 10 0
Austria 13.7847 14710 0.0016639 43.200001 7.65 50019.87 10 0
Azerbaijan 3.01 1398 0.0001406 30.299999 4.65 5768.9924 -7 0
Bahamas 0.6 60 0.0001556 32.5 2.9 27261.214 0
Bahrain 5.54 1873 0.0011934 31.200001 2.0666667 21438.41 -10
Bangladesh 1.99073 2456 0.0000152 25.6 0.6 1203.2163 -6 0
Barbados 1.4 75 0.0002617 38.5 6.0666667 16018.041 0
Belarus 0 4779 0.0005039 39.599998 11.15 6744.4987 -7 1
Belgium 18.6 38496 0.003367 41.299999 6.2666667 47166.484 8 0
Belize 1 18 0.000047 23.5 1.1 4248.9991 0
Benin 0.1 37 3.22E-06 18.200001 897.19878 7 1
Bhutan 0 5 6.63E-06 26.299999 1.7 3128.0009 7 0
Bolivia 0.979953 564 0.0000497 24.1 1.1 2559.5113 7 1
Bosnia 3.64 1269 0.0003818 41 3.5 6032.2462 0
Botswana 1.1 20 8.87E-06 24.4 8031.0138 8 0
Brazil 7 38654 0.0001845 31.299999 2.2666667 11026.241 8 1
Brunei 0.206017 138 0.0003217 30 2.7 31436.868
Bulgaria 2.4 915 0.0001302 43.5 6.7 8651.0948 9 0
Burkina Faso 0 576 0.0000292 17 712.03609 6 0
Burundi 0.9 6 5.37E-07 17.6 0.8 210.80423 -1 1
Cabo Verde 1.2 61 0.0001122 23.799999 3759.5532 10 0
Cambodia 0.114286 122 7.51E-06 24 0.7 1205.0409 -4 0
Cameroon 0.44 1016 0.0000403 18.299999 1500.7039 -4 1
Canada 8.4 34777 0.0009385 40.5 2.7 51391.708 10 0
CentralAfrican 1.9 12 2.57E-06 17.799999 378.99528 6 1
Chad 1.13636 33 2.13E-06 16.1 813.34248 -2 1
Chile 5.5 10088 0.0005386 33.700001 2.2 15130.154 10 1
China 3.8 83817 0.0000602 37 4.2 7752.5595 -7
Colombia 1.5 3792 0.0000764 30.1 1.5 7691.7456 7 1
Congo, DR 0.5 332 3.95E-06 16.799999 418.73862 -3 1
Congo, R 0.061176 160 0.0000305 18.9 2651.7007 -4 1
Costa Rica 0.48589 660 0.000132 31.4 1.1333333 9889.7435 10 1
Cote Ivory 2.6 847 0.0000338 18.299999 1692.5445 4 1
Croatia 0.3 1871 0.0004577 42.599998 5.8966667 15889.604 9 0
Cyprus 8.6 767 0.0006449 34.900002 3.45 31507.987 10 0
Czech 2.3 6787 0.0006385 41.400002 6.6 23358.873 9 0
Denmark 6.80833 7384 0.0012745 41.599998 3.1 63873.464 10 0
Djibouti 0 846 0.0008822 23.700001 1.4 3 1
Dominican Republic 0.75 4680 0.0004404 26.1 1.6 7697.7236 7 1
Ecuador 0.501052 9468 0.0005542 26.6 1.5 5185.0915 5 1
Egypt 1.8 3144 0.0000319 24.700001 0.86666667 2907.3176 -4 0
El Salvador 1.34321 201 0.0000313 25.799999 1.1666667 3511.4538 8 1
Equit. Guinea 0.3 79 0.0000604 22.200001 10254.993 -6 1
Eritrea 0 39 18.9 -7
Estonia 11.3 1528 0.0011558 41.599998 5.25 19954.13 9 0
Eswatini 0.14 22 0.0000194 20.4 4773.9174 -9
Ethiopia 1.75768 108 9.89E-07 18.6 570.30568 1 0
Fiji 8.7 17 0.0000192 27.6 4795.1945 4 0
Finland 11.3 3783 0.0006859 42.5 5.1 48749.083 10 0
France 9.3 112606 0.0016813 41.200001 6.5 43663.585 9 0
Gabon 5.33516 109 0.0000514 22.6 9042.4599 3 1
Gambia 0.564016 10 4.39E-06 17 786.37325 4 1
Georgia 4 394 0.0001057 38 2.55 4721.3029 7 0
Germany 10.7077 141672 0.0017088 45.900002 8.25 47477.838 10 0
Ghana 0.162155 1042 0.000035 20.4 1807.0635 8 1
Greece 9.2 2235 0.0002083 43.299999 4.4 23558.084 10 0
Guatemala 3.4 289 0.0000168 21.299999 0.6 3159.9675 8 1
Guinea 2.3 579 0.0000466 18.4 896.82804 4 1
Guinea Bissau 0.035471 50 0.0000267 18.9 622.07983 6 0
Guyana 0 65 0.0000834 24.6 1.6 3992.2263 7 1
Haiti 1.6 47 4.23E-06 23 0.7 730.29671 5 1
Honduras 0.556053 477 0.0000498 23 0.7 2219.3197 7 1
Hong Kong 10 43.200001 38781.785
Hungary 1.28628 1984 0.000203 41.700001 7 16647.747 10 0
Iceland 7.8 1771 0.005021 36 3.2333333 52103.17 0
India 1.1 17265 0.0000128 26.700001 2100.8008 9 0
Indoensia 5.3 6575 0.0000246 28 0.9 4284.6525 9 1
Iran 9.6 82211 0.001005 29.5 1.0333333 -7 1
Iraq 0.236099 1539 0.00004 19.4 1.3333333 5477.6961 6 0
Ireland 6.57778 15251 0.0031334 36.900002 2.8 76880.808 10 0
Israel 6.1 13491 0.0015188 30.200001 3.1 34745.767 6 0
Italy 5.7 178972 0.002962 45.900002 3.4 35431.857 10 0
Jamaica 1.1 196 0.0000668 29.4 1.7 4855.2621 9 0
Japan 21.1 10751 0.000085 46.299999 13.4 48919.799 10 0
Jordan 0 417 0.0000419 22.1 1.8333333 3266.747 -3
Kazakhstan 4.50261 1735 0.000095 29.299999 6.85 11165.544 -6 1
Kenya 0.4 270 5.25E-06 19 1202.133 9 1
Kosovo 2.57974 510 0.0002764 4161.3239 8 0
Kuwait 1.4 1915 0.0004629 33.400002 2.1333333 33112.13 -7 0
Kyrgyzstan 0.1 568 0.0000898 25.299999 4.55 1087.2041 8 0
Laos 0.005847 19 2.69E-06 22.700001 1.5 1785.5768 -7 0
Latvia 10.3 727 0.0003772 42.5 5.85 16268.953 8 0
Lebanon 0 673 0.0000983 28.5 3.1 6249.7667 6 0
Lesotho 2.32202 21.299999 1411.6765 8 0
Liberia 0.046555 91 0.0000189 18.6 541.27132 7 1
Libya 1 49 7.34E-06 27.200001 3.7 7536.7543
Lithuania 9.3 1326 0.0004733 42.700001 7.35 17708.528 10 0
Luxembourg 18.6 3550 0.0058393 39.299999 5.0666667 110742.32 10 0
Madagascar 2.34435 121 4.61E-06 18.700001 490.09731 6 0
Malawi 0.25 17 9.37E-07 17.4 516.75406 6 1
Malaysia 2.9 5389 0.0001709 27.700001 1.9 12120.083 7 0
Maldives 2.8 52 0.0001008 27.9 8033.3256 1
Mali 0.5 224 0.0000117 16 777.8606 5 0
Malta 22.1442 427 0.0008811 40.900002 4.7333333 28594.3 0
Mauritania 1.1 7 1.59E-06 19.700001 1334.4604 -2 0
Mauritius 1.38 328 0.0002592 35.599998 10578.617 10 0
Mexico 0.896389 8261 0.0000655 27.5 1.55 10403.54 8 1
Moldova 0 2472 0.0009135 35.599998 6 2668.6577 9 0
Mongolia 0.04 32 0.0000101 27.1 7 4210.0423 10 0
Montenegro 1.11984 308 0.000495 37.700001 4 8244.1275 9 0
Morocco 2.7 2855 0.0000792 27.9 0.96666667 3361.2238 -4
Mozambique 0.1 39 1.32E-06 17.200001 591.43928 5 0
Myanmar 0.100286 111 2.07E-06 27.700001 0.9 1571.9072 8 0
N. Macedonia 1.2 1207 0.0005795 37.400002 4.4 5394.2885 9 0
Namibia 4.25 16 6.54E-06 21 6044.5284 6 0
Nepal 0 31 1.10E-06 23.200001 0.3 817.44689 7 0
Netherlands 11.8 32655 0.0018951 42.099998 55022.918 10 0
New Zealand 7.7 1105 0.0002283 37.299999 2.8 37997.354 10 0
Nicaragua 0 12 1.86E-06 25.200001 0.9 1860.4385 6 1
Niger 0.02 648 0.0000289 14.9 403.48529 5 0
Nigeria 1.22445 627 3.20E-06 17.9 2396.3109 7 1
Norway 4.6 7068 0.0013306 39.200001 3.95 92077.574 10 0
Oman -5 1266 0.0002621 29 1.6666667 15796.773 -8
Pakistan 2.55116 8418 0.0000397 22.5 0.6 1197.8427 7 0
Panama 3.5 4467 0.0010695 28.4 2.3 11723.931 9 1
Papua N. Guineia 6.91059 7 8.13E-07 21.700001 2416.9331 5 0
Paraguay 6.5 206 0.0000296 24.9 5396.4808 9 1
Peru 8.98 15628 0.0004885 27.5 1.5333333 6453.5605 9 1
Philippines 1.25 6259 0.0000587 24.1 3021.9869 8 1
Poland 9 9287 0.0002446 39.700001 6.5 16659.332 10 0
Portugal 8 20206 0.0019648 43.900002 3.4 23994.662 10 0
Qatar 13 5448 0.0019585 31.299999 1.2666667 63260.558 -10
Romania 2.3 8746 0.0004493 41.299999 6.25 11532.063 9 0
Russia 2.1 42853 0.0002966 38.700001 8.3 11729.089 4 0
Rwanda 1.5 147 0.0000119 19.4 824.51885 -3 1
San Marino 0 461 0.0136451 3.8 0
Saudi Arabia 1.84029 9362 0.0002778 29.799999 2.3333333 20819.745 -10
Senegal 7.5 367 0.0000231 18.299999 1546.5202 7 0
Serbia 6 6318 0.0009048 40 5.7 6886.5003 8 0
Seychelles 0 11 0.0001137 34.599998 14385.302 1
Sierra Leone 0.183733 35 4.58E-06 18.299999 472.82544 7 1
Singapore 13 6588 0.0011684 40 2.1 58247.873 -2 0
Slovak 5.3 1161 0.0002132 39.200001 5.85 20599.147 10 0
Sloven 13.2 1330 0.0006413 43 4.55 26768.393 10 0
South Africa 0.2 3158 0.0000547 26.1 7433.6154 9 0
South Korea 0.8 10674 0.0002068 40.799999 10.3 26761.941 8 1
Spain 5.9 195944 0.0041871 43.200001 3 32949.582 10 0
SriLanka 0.21 295 0.0000136 32.299999 3.6 3936.4502 6 0
Sudan 0.414958 66 1.58E-06 18.9 0.8 1855.6263 -4 0
Suriname 0.06194 10 0.0000174 28.4 8040.9401 5 1
Sweden 11.25 14385 0.0014137 40.900002 2.6 57921.379 10 0
Switzerland 9.22846 27658 0.0032488 42.200001 4.75 79214.355 10 1
Tajikistan 0 22.4 4.8 1073.0218 -3 1
Tanzania 0 170 3.02E-06 17.299999 959.35469 3 1
Thailand 8.9 2765 0.0000398 37.799999 6361.625 -3 0
Togo 2 84 0.0000106 18.9 676.1734 -2 1
Tonga 5.3 21.299999 4054.9407
Trinidad Tobago 3.25 114 0.000082 33.900002 2.8 15161.068 10 0
Tunisia 2 879 0.000076 31.1 2.1333333 4401.0572 7 0
Turkey 2 86306 0.0010484 29.9 2.7 15068.982 -4 1
Turkmenistan 0 25.6 7.4 7647.9358 -8 1
UAE 2 6781 0.0007041 33.400002 1.15 40782.444 -8
UK 5 120067 0.0018066 40.200001 2.8 43324.593 8 0
Uganda 0.239611 55 1.29E-06 15.8 710.08195 -1 1
Ukraine 0.182845 5710 0.000128 40.299999 8.85 3110.1946 4 0
United States 13.9724 759687 0.0023254 37.599998 2.9 54579.017 8 1
Uruguay 0.7 592 0.0001716 34.900002 2.6 14617.464 10 1
Uzbekistan 1.5 1565 0.0000475 26.299999 4.1 2366.2852 -9 1
Vietnam 4.2 276 2.89E-06 30.4 2.55 1964.476 -7
Yemen 0 1 3.51E-08 19.200001 0.7 667.94544
Zambia 0.97 61 3.52E-06 17.1 1672.3454 6 1
Zimbabwe 0.20625 25 1.73E-06 19 1322.3441 4 1