Final Project

Overview

Data Exploration

We will load the data as the first step in the data exploration.

head(df)
##   CountryName Year water_score sanitation_score child_mortality
## 1 Afghanistan   10       50.05            33.56           16.65
## 2 Afghanistan   11       52.62            34.67           15.39
## 3 Afghanistan   12       55.20            35.79           14.65
## 4 Afghanistan   13       57.79            36.93           14.42
## 5 Afghanistan   14       60.38            38.07           14.64
## 6 Afghanistan   15       62.98            39.22           15.13
## [1] "Dimension of training set:   Number of rows: 2106, Number of cols: 5"
## [1] "Structure of training data set:"
## 'data.frame':    2106 obs. of  5 variables:
##  $ CountryName     : chr  "Afghanistan" "Afghanistan" "Afghanistan" "Afghanistan" ...
##  $ Year            : chr  "10" "11" "12" "13" ...
##  $ water_score     : num  50 52.6 55.2 57.8 60.4 ...
##  $ sanitation_score: num  33.6 34.7 35.8 36.9 38.1 ...
##  $ child_mortality : num  16.6 15.4 14.6 14.4 14.6 ...

Checking for NA.

## [1] TRUE

There are NA in our data, We will impute NA using mice().

Rechecking for NA after imputation.

}

We observe that NA were removed.

Here, We’ll further explore the data. First, We’ll look at min, 1st quartile, median, mean, 2nd quartile, max etc.

CountryName Year water_score sanitation_score child_mortality
Length:2106 Length:2106 Min. : 18.14 Min. : 5.69 Min. : 0.390
Class :character Class :character 1st Qu.: 82.97 1st Qu.: 59.22 1st Qu.: 1.210
Mode :character Mode :character Median : 96.26 Median : 90.91 Median : 2.875
NA NA Mean : 87.74 Mean : 76.63 Mean : 8.803
NA NA 3rd Qu.: 99.52 3rd Qu.: 98.31 3rd Qu.: 9.405
NA NA Max. :100.00 Max. :100.00 Max. :68.810

Boxplots

First look at the boxplots.

Histograms

We will see how the data is distributed (numeric fields) using histrogram.

Correlations

Now, we’ll look at the correlation matrix of the variables.

Building Models

Now, we are ready to build models. We will build model using df_imputed and compare the models. Then we will use the best model to predict child mortality.

We split df_imputed into training and test in 80/20 ratio and named as df_imputed_trn and df_imputed_tst.

Linear Regression model

First Linear Regression model

## 
## Call:
## lm(formula = child_mortality ~ ., data = df_imputed_trn)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -7.0424 -0.4968  0.0464  0.5034  9.4188 
## 
## Coefficients:
##                                                   Estimate Std. Error t value
## (Intercept)                                       46.16441    1.43017  32.279
## CountryNameAlbania                                -1.44342    1.06670  -1.353
## CountryNameAlgeria                                 3.16460    1.01302   3.124
## CountryNameAmerican Samoa                         12.93274    1.22498  10.558
## CountryNameAndorra                                 3.17996    1.15117   2.762
## CountryNameAngola                                 11.39620    1.03932  10.965
## CountryNameAnguilla                                2.57214    1.05115   2.447
## CountryNameAntigua and Barbuda                     2.94802    1.11728   2.639
## CountryNameArgentina                               4.10545    1.09171   3.761
## CountryNameArmenia                                 4.24316    1.05065   4.039
## CountryNameAruba                                   3.11632    1.10004   2.833
## CountryNameAustralia                               2.26096    1.08573   2.082
## CountryNameAustria                                 2.15005    1.15084   1.868
## CountryNameAzerbaijan                             -1.74152    0.95698  -1.820
## CountryNameBahamas                                 5.27220    1.05774   4.984
## CountryNameBahrain                                 3.51886    1.07378   3.277
## CountryNameBangladesh                             12.29197    1.32995   9.242
## CountryNameBarbados                                2.45062    1.06324   2.305
## CountryNameBelarus                                 2.08777    1.04876   1.991
## CountryNameBelgium                                 2.36165    1.08587   2.175
## CountryNameBelize                                  2.78554    1.02781   2.710
## CountryNameBenin                                  29.64846    1.03846  28.550
## CountryNameBermuda                                 3.34360    1.09892   3.043
## CountryNameBhutan                                  9.48738    1.14124   8.313
## CountryNameBolivia                                29.71911    1.12884  26.327
## CountryNameBosnia Herzegovina                      1.99110    1.05874   1.881
## CountryNameBotswana                                2.48665    0.97998   2.537
## CountryNameBrazil                                  3.83445    1.08996   3.518
## CountryNameBritish Virgin Islands                  2.46513    1.14241   2.158
## CountryNameBrunei Darussalam                       2.88240    1.07697   2.676
## CountryNameBulgaria                                3.81775    1.09696   3.480
## CountryNameBurkina Faso                           19.32834    0.85699  22.554
## CountryNameBurundi                                28.76421    0.89555  32.119
## CountryNameCambodia                               -4.48182    0.92784  -4.830
## CountryNameCameroon                               24.02097    0.84869  28.303
## CountryNameCanada                                  1.90258    1.11300   1.709
## CountryNameCape Verde                              0.56377    0.96204   0.586
## CountryNameCaribbean Netherlands                   3.64136    1.00956   3.607
## CountryNameCayman Islands                          1.90007    1.04817   1.813
## CountryNameCentral African Republic               43.53932    0.86896  50.105
## CountryNameChad                                   37.17650    0.89233  41.662
## CountryNameChannel Islands                         1.32380    1.04429   1.268
## CountryNameChile                                   3.08820    1.09840   2.812
## CountryNameChina                                   2.39562    1.05943   2.261
## CountryNameColombia                                7.78458    1.04156   7.474
## CountryNameComoros                                18.40632    1.12495  16.362
## CountryNameCongo                                  11.15562    1.03240  10.805
## CountryNameCongo, Democratic Republic             17.94977    0.94785  18.937
## CountryNameCook Islands                            2.63898    1.08112   2.441
## CountryNameCosta Rica                              4.07334    1.09046   3.735
## CountryNameCote d'Ivoire                          22.14130    1.00073  22.125
## CountryNameCroatia                                 2.61990    1.07787   2.431
## CountryNameCuba                                    0.99318    1.03146   0.963
## CountryNameCuracao                                 3.07952    1.11742   2.756
## CountryNameCyprus                                  2.43062    1.07289   2.265
## CountryNameCzech Republic                          2.21255    1.14799   1.927
## CountryNameDenmark                                 2.22304    1.07311   2.072
## CountryNameDjibouti                               22.19172    0.94645  23.447
## CountryNameDominica                                6.39090    1.09716   5.825
## CountryNameDominican Republic                      2.70587    1.06109   2.550
## CountryNameEast Timor                             -0.18420    0.87550  -0.210
## CountryNameEcuador                                 2.19458    1.06386   2.063
## CountryNameEgypt                                   6.34271    1.10005   5.766
## CountryNameEl Salvador                             0.59117    0.99504   0.594
## CountryNameEquatorial Guinea                      16.63860    1.24080  13.410
## CountryNameEritrea                               -23.45549    1.19881 -19.566
## CountryNameEstonia                                 2.40472    1.08210   2.222
## CountryNameEthiopia                               -3.36035    0.92669  -3.626
## CountryNameFalkland Islands (Malvinas)             1.14414    1.05941   1.080
## CountryNameFaroe Islands                           4.50252    1.11571   4.036
## CountryNameFederated States of Micronesia          6.35419    1.03786   6.122
## CountryNameFiji                                    2.56060    1.01646   2.519
## CountryNameFinland                                 2.35859    1.11871   2.108
## CountryNameFrance                                  2.56594    1.11772   2.296
## CountryNameFrench Guiana                           0.19791    1.03612   0.191
## CountryNameFrench Polynesia                        2.53623    1.11704   2.270
## CountryNameGabon                                  15.59891    1.16041  13.443
## CountryNameGambia                                 21.21213    0.96614  21.956
## CountryNameGeorgia                                 0.89485    1.02521   0.873
## CountryNameGermany                                 2.36209    1.09941   2.149
## CountryNameGhana                                  17.70880    1.21219  14.609
## CountryNameGibraltar                               3.17815    1.06615   2.981
## CountryNameGreece                                  2.20181    1.10095   2.000
## CountryNameGreenland                               3.22034    1.07277   3.002
## CountryNameGrenada                                 4.30032    1.04683   4.108
## CountryNameGuadeloupe                              2.06119    1.08049   1.908
## CountryNameGuam                                    3.71546    1.06626   3.485
## CountryNameGuatemala                               5.86391    1.04985   5.585
## CountryNameGuinea                                 26.11982    0.99571  26.232
## CountryNameGuinea-Bissau                          46.02977    0.99774  46.134
## CountryNameGuyana                                  7.63922    1.00912   7.570
## CountryNameHaiti                                  18.22806    0.85870  21.228
## CountryNameHoly See                                2.48704    0.93198   2.669
## CountryNameHonduras                               10.88773    1.03370  10.533
## CountryNameHong Kong                               2.93633    1.07984   2.719
## CountryNameHungary                                 2.48453    1.11857   2.221
## CountryNameIceland                                 2.37626    1.11891   2.124
## CountryNameIndia                                  10.38147    1.10543   9.391
## CountryNameIndonesia                               3.05906    0.97260   3.145
## CountryNameIran (Islamic Republic of)              2.14037    1.04665   2.045
## CountryNameIraq                                   -0.27102    0.96514  -0.281
## CountryNameIreland                                 1.96503    1.10425   1.780
## CountryNameIsle of Man                             4.85591    1.08082   4.493
## CountryNameIsrael                                  2.40553    1.07378   2.240
## CountryNameItaly                                   2.08686    1.10118   1.895
## CountryNameJamaica                                 1.58108    1.04665   1.511
## CountryNameJapan                                   1.85180    1.06494   1.739
## CountryNameJordan                                  3.91497    1.08550   3.607
## CountryNameKazakstan                              -0.18248    1.01825  -0.179
## CountryNameKenya                                  -0.43585    0.86390  -0.505
## CountryNameKiribati                                0.39095    0.86698   0.451
## CountryNameKorea, Dem. People's Rep. of            8.87416    1.12583   7.882
## CountryNameKorea, Republic of                      2.17900    1.08030   2.017
## CountryNameKosovo                                  4.48969    1.10367   4.068
## CountryNameKuwait                                  3.96934    1.08470   3.659
## CountryNameKyrgyzstan                             -1.99956    1.02041  -1.960
## CountryNameLao People's Dem. Rep.                  4.96867    0.92179   5.390
## CountryNameLatvia                                  2.64882    1.08109   2.450
## CountryNameLebanon                                -1.07993    1.01279  -1.066
## CountryNameLesotho                                10.31671    0.90897  11.350
## CountryNameLiberia                                11.79449    1.05332  11.197
## CountryNameLibyan Arab Jamahiriya                  4.33725    1.12633   3.851
## CountryNameLiechtenstein                           2.88762    1.10203   2.620
## CountryNameLithuania                               1.49302    1.03651   1.440
## CountryNameLuxembourg                              2.30113    1.11904   2.056
## CountryNameMacau                                   2.69823    1.08499   2.487
## CountryNameMadagascar                             -1.70234    0.89026  -1.912
## CountryNameMalawi                                  6.24476    0.86747   7.199
## CountryNameMalaysia                                1.26019    1.06077   1.188
## CountryNameMaldives                                2.17622    1.12906   1.927
## CountryNameMali                                   40.11134    0.95889  41.831
## CountryNameMalta                                   2.32746    1.12403   2.071
## CountryNameMarshall Islands                       -4.90491    1.05072  -4.668
## CountryNameMartinique                              2.60609    1.09910   2.371
## CountryNameMauritania                             14.91161    0.90553  16.467
## CountryNameMauritius                               4.60339    1.24500   3.697
## CountryNameMayotte                                 3.04967    1.12441   2.712
## CountryNameMexico                                  5.64165    1.09155   5.168
## CountryNameMonaco                                  3.20956    1.10217   2.912
## CountryNameMongolia                                0.14226    0.95130   0.150
## CountryNameMontenegro                              3.51984    1.06994   3.290
## CountryNameMontserrat                              3.28030    1.06018   3.094
## CountryNameMorocco                                -2.48517    0.98960  -2.511
## CountryNameMozambique                             14.28326    0.89946  15.880
## CountryNameMyanmar                                -1.33255    0.90139  -1.478
## CountryNameNamibia                                 4.19093    1.02841   4.075
## CountryNameNauru                                   8.30285    1.16814   7.108
## CountryNameNepal                                   5.84024    1.13823   5.131
## CountryNameNetherlands                             2.38389    1.08370   2.200
## CountryNameNew Caledonia                           2.73448    1.07360   2.547
## CountryNameNew Zealand                             2.58475    1.08681   2.378
## CountryNameNicaragua                              -2.67250    0.92578  -2.887
## CountryNameNiger                                  35.87868    0.89920  39.901
## CountryNameNigeria                                34.93399    0.95518  36.573
## CountryNameNiue                                    2.11115    1.08348   1.948
## CountryNameNorthern Mariana Islands                9.45663    1.09743   8.617
## CountryNameNorway                                  2.34965    1.09707   2.142
## CountryNameOman                                   -2.73834    1.05046  -2.607
## CountryNamePakistan                               16.85619    1.06666  15.803
## CountryNamePalau                                   2.26868    1.09374   2.074
## CountryNamePalestinian Territory, Occupied        -1.23660    1.01784  -1.215
## CountryNamePanama                                  4.97094    1.07425   4.627
## CountryNamePapua New Guinea                      -12.14931    0.99029 -12.268
## CountryNameParaguay                                7.25772    1.08783   6.672
## CountryNamePeru                                    7.70926    0.99212   7.771
## CountryNamePhilippines                             5.08722    1.00460   5.064
## CountryNamePoland                                  1.48799    1.06435   1.398
## CountryNamePortugal                                2.17019    1.07103   2.026
## CountryNamePuerto Rico                             1.43675    1.09344   1.314
## CountryNameQatar                                   2.99559    1.08661   2.757
## CountryNameRepublic of Moldova                    -1.61070    0.97233  -1.657
## CountryNameReunion                                 2.04579    1.06792   1.916
## CountryNameRomania                                 4.66725    1.10086   4.240
## CountryNameRussian Federation                      2.38625    1.02936   2.318
## CountryNameRwanda                                 -1.34313    0.99175  -1.354
## CountryNameSaint Helena                            1.84848    1.07650   1.717
## CountryNameSaint Kitts and Nevis                   2.99029    1.10773   2.699
## CountryNameSaint Lucia                             4.58360    1.05226   4.356
## CountryNameSaint Pierre and Miquelon              -0.08089    1.07646  -0.075
## CountryNameSamoa                                   2.68657    1.06180   2.530
## CountryNameSan Marino                              2.82591    1.08670   2.600
## CountryNameSao Tome and Principe                  14.37492    1.06816  13.458
## CountryNameSaudi Arabia                            3.73330    1.10060   3.392
## CountryNameSenegal                                 3.17041    0.88949   3.564
## CountryNameSerbia                                 -1.33877    1.03444  -1.294
## CountryNameSeychelles                              1.94275    1.04595   1.857
## CountryNameSierra Leone                           27.88821    0.94144  29.623
## CountryNameSingapore                               2.13722    1.08584   1.968
## CountryNameSint Maarten (Dutch part)               1.36532    1.11690   1.222
## CountryNameSlovakia                                1.66999    1.05569   1.582
## CountryNameSlovenia                                1.88898    1.11813   1.689
## CountryNameSolomon Islands                        -4.80669    0.90071  -5.337
## CountryNameSomalia                                28.56312    0.94538  30.213
## CountryNameSouth Africa                            5.46541    0.92015   5.940
## CountryNameSouth Sudan                            27.06242    0.87195  31.037
## CountryNameSpain                                   2.05848    1.12226   1.834
## CountryNameSri Lanka                              -1.61954    1.05166  -1.540
## CountryNameSt. Vincent and the Grenadines          4.46526    1.02902   4.339
## CountryNameSudan                                   9.31824    0.84148  11.074
## CountryNameSuriname                                6.09760    1.06959   5.701
## CountryNameSwaziland                               4.36227    0.91024   4.792
## CountryNameSweden                                  2.18070    1.10023   1.982
## CountryNameSwitzerland                             2.26785    1.10002   2.062
## CountryNameSyrian Arab Republic                    2.93271    1.04866   2.797
## CountryNameTaiwan                                  1.84080    1.12248   1.640
## CountryNameTajikistan                             -2.86902    1.09826  -2.612
## CountryNameThailand                                2.68327    1.09627   2.448
## CountryNameThe former Yugoslav Rep. of Macedonia   1.67514    1.08355   1.546
## CountryNameTogo                                   16.60592    0.93555  17.750
## CountryNameTokelau                                 5.96128    1.07556   5.542
## CountryNameTonga                                   5.95811    1.09323   5.450
## CountryNameTrinidad and Tobago                     6.72111    1.06546   6.308
## CountryNameTunisia                                 0.44151    1.09035   0.405
## CountryNameTurkey                                  6.91632    1.08258   6.389
## CountryNameTurkmenistan                            7.49060    1.02168   7.332
## CountryNameTurks and Caicos Islands                2.06332    1.05542   1.955
## CountryNameTuvalu                                  4.08975    1.10684   3.695
## CountryNameUganda                                  6.51169    0.95267   6.835
## CountryNameUkraine                                 2.24706    1.09411   2.054
## CountryNameUnited Arab Emirates                    2.32529    1.08369   2.146
## CountryNameUnited Kingdom                          2.69895    1.11821   2.414
## CountryNameUnited Rep. of Tanzania                -1.49409    0.84647  -1.765
## CountryNameUnited States                           2.18054    1.09450   1.992
## CountryNameUnited States Virgin Islands            3.34431    1.08133   3.093
## CountryNameUruguay                                 3.78143    1.07115   3.530
## CountryNameUzbekistan                              2.06692    1.05802   1.954
## CountryNameVanuatu                                 4.01565    1.05636   3.801
## CountryNameVenezuela                               2.70309    1.05663   2.558
## CountryNameViet Nam                                3.06108    1.00203   3.055
## CountryNameWallis and Futuna Islands               2.15852    1.08049   1.998
## CountryNameWestern Sahara                          6.95698    1.03695   6.709
## CountryNameYemen                                   2.24062    0.86433   2.592
## CountryNameZambia                                 10.96667    0.84999  12.902
## CountryNameZimbabwe                                9.36887    0.88246  10.617
## Year11                                            -0.49062    0.14608  -3.359
## Year12                                            -0.77505    0.14264  -5.434
## Year13                                            -1.00756    0.14355  -7.019
## Year14                                            -1.16751    0.14489  -8.058
## Year15                                            -1.42159    0.14483  -9.816
## Year16                                            -1.57733    0.14578 -10.820
## Year17                                            -1.74245    0.14577 -11.953
## Year18                                            -1.78803    0.14602 -12.245
## water_score                                       -0.54687    0.02912 -18.780
## sanitation_score                                   0.07988    0.01713   4.664
##                                                  Pr(>|t|)    
## (Intercept)                                       < 2e-16 ***
## CountryNameAlbania                               0.176213    
## CountryNameAlgeria                               0.001820 ** 
## CountryNameAmerican Samoa                         < 2e-16 ***
## CountryNameAndorra                               0.005811 ** 
## CountryNameAngola                                 < 2e-16 ***
## CountryNameAnguilla                              0.014524 *  
## CountryNameAntigua and Barbuda                   0.008415 ** 
## CountryNameArgentina                             0.000176 ***
## CountryNameArmenia                               5.66e-05 ***
## CountryNameAruba                                 0.004677 ** 
## CountryNameAustralia                             0.037479 *  
## CountryNameAustria                               0.061931 .  
## CountryNameAzerbaijan                            0.068995 .  
## CountryNameBahamas                               6.97e-07 ***
## CountryNameBahrain                               0.001074 ** 
## CountryNameBangladesh                             < 2e-16 ***
## CountryNameBarbados                              0.021316 *  
## CountryNameBelarus                               0.046703 *  
## CountryNameBelgium                               0.029800 *  
## CountryNameBelize                                0.006804 ** 
## CountryNameBenin                                  < 2e-16 ***
## CountryNameBermuda                               0.002388 ** 
## CountryNameBhutan                                 < 2e-16 ***
## CountryNameBolivia                                < 2e-16 ***
## CountryNameBosnia Herzegovina                    0.060222 .  
## CountryNameBotswana                              0.011271 *  
## CountryNameBrazil                                0.000448 ***
## CountryNameBritish Virgin Islands                0.031106 *  
## CountryNameBrunei Darussalam                     0.007526 ** 
## CountryNameBulgaria                              0.000516 ***
## CountryNameBurkina Faso                           < 2e-16 ***
## CountryNameBurundi                                < 2e-16 ***
## CountryNameCambodia                              1.51e-06 ***
## CountryNameCameroon                               < 2e-16 ***
## CountryNameCanada                                0.087590 .  
## CountryNameCape Verde                            0.557959    
## CountryNameCaribbean Netherlands                 0.000320 ***
## CountryNameCayman Islands                        0.070078 .  
## CountryNameCentral African Republic               < 2e-16 ***
## CountryNameChad                                   < 2e-16 ***
## CountryNameChannel Islands                       0.205124    
## CountryNameChile                                 0.004997 ** 
## CountryNameChina                                 0.023893 *  
## CountryNameColombia                              1.34e-13 ***
## CountryNameComoros                                < 2e-16 ***
## CountryNameCongo                                  < 2e-16 ***
## CountryNameCongo, Democratic Republic             < 2e-16 ***
## CountryNameCook Islands                          0.014767 *  
## CountryNameCosta Rica                            0.000195 ***
## CountryNameCote d'Ivoire                          < 2e-16 ***
## CountryNameCroatia                               0.015194 *  
## CountryNameCuba                                  0.335767    
## CountryNameCuracao                               0.005926 ** 
## CountryNameCyprus                                0.023631 *  
## CountryNameCzech Republic                        0.054135 .  
## CountryNameDenmark                               0.038482 *  
## CountryNameDjibouti                               < 2e-16 ***
## CountryNameDominica                              7.03e-09 ***
## CountryNameDominican Republic                    0.010872 *  
## CountryNameEast Timor                            0.833392    
## CountryNameEcuador                               0.039306 *  
## CountryNameEgypt                                 9.92e-09 ***
## CountryNameEl Salvador                           0.552526    
## CountryNameEquatorial Guinea                      < 2e-16 ***
## CountryNameEritrea                                < 2e-16 ***
## CountryNameEstonia                               0.026419 *  
## CountryNameEthiopia                              0.000298 ***
## CountryNameFalkland Islands (Malvinas)           0.280335    
## CountryNameFaroe Islands                         5.73e-05 ***
## CountryNameFederated States of Micronesia        1.19e-09 ***
## CountryNameFiji                                  0.011872 *  
## CountryNameFinland                               0.035176 *  
## CountryNameFrance                                0.021836 *  
## CountryNameFrench Guiana                         0.848541    
## CountryNameFrench Polynesia                      0.023325 *  
## CountryNameGabon                                  < 2e-16 ***
## CountryNameGambia                                 < 2e-16 ***
## CountryNameGeorgia                               0.382890    
## CountryNameGermany                               0.031839 *  
## CountryNameGhana                                  < 2e-16 ***
## CountryNameGibraltar                             0.002922 ** 
## CountryNameGreece                                0.045696 *  
## CountryNameGreenland                             0.002729 ** 
## CountryNameGrenada                               4.22e-05 ***
## CountryNameGuadeloupe                            0.056634 .  
## CountryNameGuam                                  0.000508 ***
## CountryNameGuatemala                             2.78e-08 ***
## CountryNameGuinea                                 < 2e-16 ***
## CountryNameGuinea-Bissau                          < 2e-16 ***
## CountryNameGuyana                                6.61e-14 ***
## CountryNameHaiti                                  < 2e-16 ***
## CountryNameHoly See                              0.007703 ** 
## CountryNameHonduras                               < 2e-16 ***
## CountryNameHong Kong                             0.006622 ** 
## CountryNameHungary                               0.026494 *  
## CountryNameIceland                               0.033862 *  
## CountryNameIndia                                  < 2e-16 ***
## CountryNameIndonesia                             0.001693 ** 
## CountryNameIran (Islamic Republic of)            0.041038 *  
## CountryNameIraq                                  0.778900    
## CountryNameIreland                               0.075365 .  
## CountryNameIsle of Man                           7.59e-06 ***
## CountryNameIsrael                                0.025226 *  
## CountryNameItaly                                 0.058277 .  
## CountryNameJamaica                               0.131108    
## CountryNameJapan                                 0.082269 .  
## CountryNameJordan                                0.000321 ***
## CountryNameKazakstan                             0.857799    
## CountryNameKenya                                 0.613974    
## CountryNameKiribati                              0.652107    
## CountryNameKorea, Dem. People's Rep. of          6.29e-15 ***
## CountryNameKorea, Republic of                    0.043877 *  
## CountryNameKosovo                                5.00e-05 ***
## CountryNameKuwait                                0.000262 ***
## CountryNameKyrgyzstan                            0.050238 .  
## CountryNameLao People's Dem. Rep.                8.21e-08 ***
## CountryNameLatvia                                0.014399 *  
## CountryNameLebanon                               0.286468    
## CountryNameLesotho                                < 2e-16 ***
## CountryNameLiberia                                < 2e-16 ***
## CountryNameLibyan Arab Jamahiriya                0.000123 ***
## CountryNameLiechtenstein                         0.008878 ** 
## CountryNameLithuania                             0.149966    
## CountryNameLuxembourg                            0.039929 *  
## CountryNameMacau                                 0.012999 *  
## CountryNameMadagascar                            0.056049 .  
## CountryNameMalawi                                9.74e-13 ***
## CountryNameMalaysia                              0.235030    
## CountryNameMaldives                              0.054118 .  
## CountryNameMali                                   < 2e-16 ***
## CountryNameMalta                                 0.038569 *  
## CountryNameMarshall Islands                      3.32e-06 ***
## CountryNameMartinique                            0.017865 *  
## CountryNameMauritania                             < 2e-16 ***
## CountryNameMauritius                             0.000226 ***
## CountryNameMayotte                               0.006763 ** 
## CountryNameMexico                                2.69e-07 ***
## CountryNameMonaco                                0.003646 ** 
## CountryNameMongolia                              0.881143    
## CountryNameMontenegro                            0.001027 ** 
## CountryNameMontserrat                            0.002012 ** 
## CountryNameMorocco                               0.012138 *  
## CountryNameMozambique                             < 2e-16 ***
## CountryNameMyanmar                               0.139537    
## CountryNameNamibia                               4.85e-05 ***
## CountryNameNauru                                 1.85e-12 ***
## CountryNameNepal                                 3.27e-07 ***
## CountryNameNetherlands                           0.027981 *  
## CountryNameNew Caledonia                         0.010968 *  
## CountryNameNew Zealand                           0.017523 *  
## CountryNameNicaragua                             0.003950 ** 
## CountryNameNiger                                  < 2e-16 ***
## CountryNameNigeria                                < 2e-16 ***
## CountryNameNiue                                  0.051551 .  
## CountryNameNorthern Mariana Islands               < 2e-16 ***
## CountryNameNorway                                0.032380 *  
## CountryNameOman                                  0.009234 ** 
## CountryNamePakistan                               < 2e-16 ***
## CountryNamePalau                                 0.038233 *  
## CountryNamePalestinian Territory, Occupied       0.224592    
## CountryNamePanama                                4.04e-06 ***
## CountryNamePapua New Guinea                       < 2e-16 ***
## CountryNameParaguay                              3.59e-11 ***
## CountryNamePeru                                  1.47e-14 ***
## CountryNamePhilippines                           4.64e-07 ***
## CountryNamePoland                                0.162321    
## CountryNamePortugal                              0.042922 *  
## CountryNamePuerto Rico                           0.189065    
## CountryNameQatar                                 0.005910 ** 
## CountryNameRepublic of Moldova                   0.097832 .  
## CountryNameReunion                               0.055603 .  
## CountryNameRomania                               2.38e-05 ***
## CountryNameRussian Federation                    0.020579 *  
## CountryNameRwanda                                0.175848    
## CountryNameSaint Helena                          0.086173 .  
## CountryNameSaint Kitts and Nevis                 0.007026 ** 
## CountryNameSaint Lucia                           1.42e-05 ***
## CountryNameSaint Pierre and Miquelon             0.940110    
## CountryNameSamoa                                 0.011505 *  
## CountryNameSan Marino                            0.009405 ** 
## CountryNameSao Tome and Principe                  < 2e-16 ***
## CountryNameSaudi Arabia                          0.000712 ***
## CountryNameSenegal                               0.000377 ***
## CountryNameSerbia                                0.195807    
## CountryNameSeychelles                            0.063457 .  
## CountryNameSierra Leone                           < 2e-16 ***
## CountryNameSingapore                             0.049228 *  
## CountryNameSint Maarten (Dutch part)             0.221750    
## CountryNameSlovakia                              0.113893    
## CountryNameSlovenia                              0.091356 .  
## CountryNameSolomon Islands                       1.10e-07 ***
## CountryNameSomalia                                < 2e-16 ***
## CountryNameSouth Africa                          3.57e-09 ***
## CountryNameSouth Sudan                            < 2e-16 ***
## CountryNameSpain                                 0.066826 .  
## CountryNameSri Lanka                             0.123782    
## CountryNameSt. Vincent and the Grenadines        1.53e-05 ***
## CountryNameSudan                                  < 2e-16 ***
## CountryNameSuriname                              1.44e-08 ***
## CountryNameSwaziland                             1.82e-06 ***
## CountryNameSweden                                0.047664 *  
## CountryNameSwitzerland                           0.039420 *  
## CountryNameSyrian Arab Republic                  0.005233 ** 
## CountryNameTaiwan                                0.101234    
## CountryNameTajikistan                            0.009086 ** 
## CountryNameThailand                              0.014499 *  
## CountryNameThe former Yugoslav Rep. of Macedonia 0.122331    
## CountryNameTogo                                   < 2e-16 ***
## CountryNameTokelau                               3.54e-08 ***
## CountryNameTonga                                 5.92e-08 ***
## CountryNameTrinidad and Tobago                   3.75e-10 ***
## CountryNameTunisia                               0.685591    
## CountryNameTurkey                                2.25e-10 ***
## CountryNameTurkmenistan                          3.77e-13 ***
## CountryNameTurks and Caicos Islands              0.050778 .  
## CountryNameTuvalu                                0.000228 ***
## CountryNameUganda                                1.20e-11 ***
## CountryNameUkraine                               0.040176 *  
## CountryNameUnited Arab Emirates                  0.032063 *  
## CountryNameUnited Kingdom                        0.015918 *  
## CountryNameUnited Rep. of Tanzania               0.077762 .  
## CountryNameUnited States                         0.046529 *  
## CountryNameUnited States Virgin Islands          0.002021 ** 
## CountryNameUruguay                               0.000428 ***
## CountryNameUzbekistan                            0.050944 .  
## CountryNameVanuatu                               0.000150 ***
## CountryNameVenezuela                             0.010622 *  
## CountryNameViet Nam                              0.002293 ** 
## CountryNameWallis and Futuna Islands             0.045934 *  
## CountryNameWestern Sahara                        2.80e-11 ***
## CountryNameYemen                                 0.009629 ** 
## CountryNameZambia                                 < 2e-16 ***
## CountryNameZimbabwe                               < 2e-16 ***
## Year11                                           0.000804 ***
## Year12                                           6.47e-08 ***
## Year13                                           3.43e-12 ***
## Year14                                           1.61e-15 ***
## Year15                                            < 2e-16 ***
## Year16                                            < 2e-16 ***
## Year17                                            < 2e-16 ***
## Year18                                            < 2e-16 ***
## water_score                                       < 2e-16 ***
## sanitation_score                                 3.39e-06 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.37 on 1443 degrees of freedom
## Multiple R-squared:  0.9906, Adjusted R-squared:  0.989 
## F-statistic: 624.5 on 243 and 1443 DF,  p-value: < 2.2e-16

Here we note the following important metrics.

R-squared: 0.9851

Adjusted R-squared: 0.9826

Linear Regression model

In Second Linear Regression model, we’ll do stepwise AIC.

## 
## Call:
## lm(formula = child_mortality ~ CountryName + Year + water_score + 
##     sanitation_score, data = df_imputed_trn)
## 
## Residuals:
##     Min      1Q  Median      3Q     Max 
## -7.0424 -0.4968  0.0464  0.5034  9.4188 
## 
## Coefficients:
##                                                   Estimate Std. Error t value
## (Intercept)                                       46.16441    1.43017  32.279
## CountryNameAlbania                                -1.44342    1.06670  -1.353
## CountryNameAlgeria                                 3.16460    1.01302   3.124
## CountryNameAmerican Samoa                         12.93274    1.22498  10.558
## CountryNameAndorra                                 3.17996    1.15117   2.762
## CountryNameAngola                                 11.39620    1.03932  10.965
## CountryNameAnguilla                                2.57214    1.05115   2.447
## CountryNameAntigua and Barbuda                     2.94802    1.11728   2.639
## CountryNameArgentina                               4.10545    1.09171   3.761
## CountryNameArmenia                                 4.24316    1.05065   4.039
## CountryNameAruba                                   3.11632    1.10004   2.833
## CountryNameAustralia                               2.26096    1.08573   2.082
## CountryNameAustria                                 2.15005    1.15084   1.868
## CountryNameAzerbaijan                             -1.74152    0.95698  -1.820
## CountryNameBahamas                                 5.27220    1.05774   4.984
## CountryNameBahrain                                 3.51886    1.07378   3.277
## CountryNameBangladesh                             12.29197    1.32995   9.242
## CountryNameBarbados                                2.45062    1.06324   2.305
## CountryNameBelarus                                 2.08777    1.04876   1.991
## CountryNameBelgium                                 2.36165    1.08587   2.175
## CountryNameBelize                                  2.78554    1.02781   2.710
## CountryNameBenin                                  29.64846    1.03846  28.550
## CountryNameBermuda                                 3.34360    1.09892   3.043
## CountryNameBhutan                                  9.48738    1.14124   8.313
## CountryNameBolivia                                29.71911    1.12884  26.327
## CountryNameBosnia Herzegovina                      1.99110    1.05874   1.881
## CountryNameBotswana                                2.48665    0.97998   2.537
## CountryNameBrazil                                  3.83445    1.08996   3.518
## CountryNameBritish Virgin Islands                  2.46513    1.14241   2.158
## CountryNameBrunei Darussalam                       2.88240    1.07697   2.676
## CountryNameBulgaria                                3.81775    1.09696   3.480
## CountryNameBurkina Faso                           19.32834    0.85699  22.554
## CountryNameBurundi                                28.76421    0.89555  32.119
## CountryNameCambodia                               -4.48182    0.92784  -4.830
## CountryNameCameroon                               24.02097    0.84869  28.303
## CountryNameCanada                                  1.90258    1.11300   1.709
## CountryNameCape Verde                              0.56377    0.96204   0.586
## CountryNameCaribbean Netherlands                   3.64136    1.00956   3.607
## CountryNameCayman Islands                          1.90007    1.04817   1.813
## CountryNameCentral African Republic               43.53932    0.86896  50.105
## CountryNameChad                                   37.17650    0.89233  41.662
## CountryNameChannel Islands                         1.32380    1.04429   1.268
## CountryNameChile                                   3.08820    1.09840   2.812
## CountryNameChina                                   2.39562    1.05943   2.261
## CountryNameColombia                                7.78458    1.04156   7.474
## CountryNameComoros                                18.40632    1.12495  16.362
## CountryNameCongo                                  11.15562    1.03240  10.805
## CountryNameCongo, Democratic Republic             17.94977    0.94785  18.937
## CountryNameCook Islands                            2.63898    1.08112   2.441
## CountryNameCosta Rica                              4.07334    1.09046   3.735
## CountryNameCote d'Ivoire                          22.14130    1.00073  22.125
## CountryNameCroatia                                 2.61990    1.07787   2.431
## CountryNameCuba                                    0.99318    1.03146   0.963
## CountryNameCuracao                                 3.07952    1.11742   2.756
## CountryNameCyprus                                  2.43062    1.07289   2.265
## CountryNameCzech Republic                          2.21255    1.14799   1.927
## CountryNameDenmark                                 2.22304    1.07311   2.072
## CountryNameDjibouti                               22.19172    0.94645  23.447
## CountryNameDominica                                6.39090    1.09716   5.825
## CountryNameDominican Republic                      2.70587    1.06109   2.550
## CountryNameEast Timor                             -0.18420    0.87550  -0.210
## CountryNameEcuador                                 2.19458    1.06386   2.063
## CountryNameEgypt                                   6.34271    1.10005   5.766
## CountryNameEl Salvador                             0.59117    0.99504   0.594
## CountryNameEquatorial Guinea                      16.63860    1.24080  13.410
## CountryNameEritrea                               -23.45549    1.19881 -19.566
## CountryNameEstonia                                 2.40472    1.08210   2.222
## CountryNameEthiopia                               -3.36035    0.92669  -3.626
## CountryNameFalkland Islands (Malvinas)             1.14414    1.05941   1.080
## CountryNameFaroe Islands                           4.50252    1.11571   4.036
## CountryNameFederated States of Micronesia          6.35419    1.03786   6.122
## CountryNameFiji                                    2.56060    1.01646   2.519
## CountryNameFinland                                 2.35859    1.11871   2.108
## CountryNameFrance                                  2.56594    1.11772   2.296
## CountryNameFrench Guiana                           0.19791    1.03612   0.191
## CountryNameFrench Polynesia                        2.53623    1.11704   2.270
## CountryNameGabon                                  15.59891    1.16041  13.443
## CountryNameGambia                                 21.21213    0.96614  21.956
## CountryNameGeorgia                                 0.89485    1.02521   0.873
## CountryNameGermany                                 2.36209    1.09941   2.149
## CountryNameGhana                                  17.70880    1.21219  14.609
## CountryNameGibraltar                               3.17815    1.06615   2.981
## CountryNameGreece                                  2.20181    1.10095   2.000
## CountryNameGreenland                               3.22034    1.07277   3.002
## CountryNameGrenada                                 4.30032    1.04683   4.108
## CountryNameGuadeloupe                              2.06119    1.08049   1.908
## CountryNameGuam                                    3.71546    1.06626   3.485
## CountryNameGuatemala                               5.86391    1.04985   5.585
## CountryNameGuinea                                 26.11982    0.99571  26.232
## CountryNameGuinea-Bissau                          46.02977    0.99774  46.134
## CountryNameGuyana                                  7.63922    1.00912   7.570
## CountryNameHaiti                                  18.22806    0.85870  21.228
## CountryNameHoly See                                2.48704    0.93198   2.669
## CountryNameHonduras                               10.88773    1.03370  10.533
## CountryNameHong Kong                               2.93633    1.07984   2.719
## CountryNameHungary                                 2.48453    1.11857   2.221
## CountryNameIceland                                 2.37626    1.11891   2.124
## CountryNameIndia                                  10.38147    1.10543   9.391
## CountryNameIndonesia                               3.05906    0.97260   3.145
## CountryNameIran (Islamic Republic of)              2.14037    1.04665   2.045
## CountryNameIraq                                   -0.27102    0.96514  -0.281
## CountryNameIreland                                 1.96503    1.10425   1.780
## CountryNameIsle of Man                             4.85591    1.08082   4.493
## CountryNameIsrael                                  2.40553    1.07378   2.240
## CountryNameItaly                                   2.08686    1.10118   1.895
## CountryNameJamaica                                 1.58108    1.04665   1.511
## CountryNameJapan                                   1.85180    1.06494   1.739
## CountryNameJordan                                  3.91497    1.08550   3.607
## CountryNameKazakstan                              -0.18248    1.01825  -0.179
## CountryNameKenya                                  -0.43585    0.86390  -0.505
## CountryNameKiribati                                0.39095    0.86698   0.451
## CountryNameKorea, Dem. People's Rep. of            8.87416    1.12583   7.882
## CountryNameKorea, Republic of                      2.17900    1.08030   2.017
## CountryNameKosovo                                  4.48969    1.10367   4.068
## CountryNameKuwait                                  3.96934    1.08470   3.659
## CountryNameKyrgyzstan                             -1.99956    1.02041  -1.960
## CountryNameLao People's Dem. Rep.                  4.96867    0.92179   5.390
## CountryNameLatvia                                  2.64882    1.08109   2.450
## CountryNameLebanon                                -1.07993    1.01279  -1.066
## CountryNameLesotho                                10.31671    0.90897  11.350
## CountryNameLiberia                                11.79449    1.05332  11.197
## CountryNameLibyan Arab Jamahiriya                  4.33725    1.12633   3.851
## CountryNameLiechtenstein                           2.88762    1.10203   2.620
## CountryNameLithuania                               1.49302    1.03651   1.440
## CountryNameLuxembourg                              2.30113    1.11904   2.056
## CountryNameMacau                                   2.69823    1.08499   2.487
## CountryNameMadagascar                             -1.70234    0.89026  -1.912
## CountryNameMalawi                                  6.24476    0.86747   7.199
## CountryNameMalaysia                                1.26019    1.06077   1.188
## CountryNameMaldives                                2.17622    1.12906   1.927
## CountryNameMali                                   40.11134    0.95889  41.831
## CountryNameMalta                                   2.32746    1.12403   2.071
## CountryNameMarshall Islands                       -4.90491    1.05072  -4.668
## CountryNameMartinique                              2.60609    1.09910   2.371
## CountryNameMauritania                             14.91161    0.90553  16.467
## CountryNameMauritius                               4.60339    1.24500   3.697
## CountryNameMayotte                                 3.04967    1.12441   2.712
## CountryNameMexico                                  5.64165    1.09155   5.168
## CountryNameMonaco                                  3.20956    1.10217   2.912
## CountryNameMongolia                                0.14226    0.95130   0.150
## CountryNameMontenegro                              3.51984    1.06994   3.290
## CountryNameMontserrat                              3.28030    1.06018   3.094
## CountryNameMorocco                                -2.48517    0.98960  -2.511
## CountryNameMozambique                             14.28326    0.89946  15.880
## CountryNameMyanmar                                -1.33255    0.90139  -1.478
## CountryNameNamibia                                 4.19093    1.02841   4.075
## CountryNameNauru                                   8.30285    1.16814   7.108
## CountryNameNepal                                   5.84024    1.13823   5.131
## CountryNameNetherlands                             2.38389    1.08370   2.200
## CountryNameNew Caledonia                           2.73448    1.07360   2.547
## CountryNameNew Zealand                             2.58475    1.08681   2.378
## CountryNameNicaragua                              -2.67250    0.92578  -2.887
## CountryNameNiger                                  35.87868    0.89920  39.901
## CountryNameNigeria                                34.93399    0.95518  36.573
## CountryNameNiue                                    2.11115    1.08348   1.948
## CountryNameNorthern Mariana Islands                9.45663    1.09743   8.617
## CountryNameNorway                                  2.34965    1.09707   2.142
## CountryNameOman                                   -2.73834    1.05046  -2.607
## CountryNamePakistan                               16.85619    1.06666  15.803
## CountryNamePalau                                   2.26868    1.09374   2.074
## CountryNamePalestinian Territory, Occupied        -1.23660    1.01784  -1.215
## CountryNamePanama                                  4.97094    1.07425   4.627
## CountryNamePapua New Guinea                      -12.14931    0.99029 -12.268
## CountryNameParaguay                                7.25772    1.08783   6.672
## CountryNamePeru                                    7.70926    0.99212   7.771
## CountryNamePhilippines                             5.08722    1.00460   5.064
## CountryNamePoland                                  1.48799    1.06435   1.398
## CountryNamePortugal                                2.17019    1.07103   2.026
## CountryNamePuerto Rico                             1.43675    1.09344   1.314
## CountryNameQatar                                   2.99559    1.08661   2.757
## CountryNameRepublic of Moldova                    -1.61070    0.97233  -1.657
## CountryNameReunion                                 2.04579    1.06792   1.916
## CountryNameRomania                                 4.66725    1.10086   4.240
## CountryNameRussian Federation                      2.38625    1.02936   2.318
## CountryNameRwanda                                 -1.34313    0.99175  -1.354
## CountryNameSaint Helena                            1.84848    1.07650   1.717
## CountryNameSaint Kitts and Nevis                   2.99029    1.10773   2.699
## CountryNameSaint Lucia                             4.58360    1.05226   4.356
## CountryNameSaint Pierre and Miquelon              -0.08089    1.07646  -0.075
## CountryNameSamoa                                   2.68657    1.06180   2.530
## CountryNameSan Marino                              2.82591    1.08670   2.600
## CountryNameSao Tome and Principe                  14.37492    1.06816  13.458
## CountryNameSaudi Arabia                            3.73330    1.10060   3.392
## CountryNameSenegal                                 3.17041    0.88949   3.564
## CountryNameSerbia                                 -1.33877    1.03444  -1.294
## CountryNameSeychelles                              1.94275    1.04595   1.857
## CountryNameSierra Leone                           27.88821    0.94144  29.623
## CountryNameSingapore                               2.13722    1.08584   1.968
## CountryNameSint Maarten (Dutch part)               1.36532    1.11690   1.222
## CountryNameSlovakia                                1.66999    1.05569   1.582
## CountryNameSlovenia                                1.88898    1.11813   1.689
## CountryNameSolomon Islands                        -4.80669    0.90071  -5.337
## CountryNameSomalia                                28.56312    0.94538  30.213
## CountryNameSouth Africa                            5.46541    0.92015   5.940
## CountryNameSouth Sudan                            27.06242    0.87195  31.037
## CountryNameSpain                                   2.05848    1.12226   1.834
## CountryNameSri Lanka                              -1.61954    1.05166  -1.540
## CountryNameSt. Vincent and the Grenadines          4.46526    1.02902   4.339
## CountryNameSudan                                   9.31824    0.84148  11.074
## CountryNameSuriname                                6.09760    1.06959   5.701
## CountryNameSwaziland                               4.36227    0.91024   4.792
## CountryNameSweden                                  2.18070    1.10023   1.982
## CountryNameSwitzerland                             2.26785    1.10002   2.062
## CountryNameSyrian Arab Republic                    2.93271    1.04866   2.797
## CountryNameTaiwan                                  1.84080    1.12248   1.640
## CountryNameTajikistan                             -2.86902    1.09826  -2.612
## CountryNameThailand                                2.68327    1.09627   2.448
## CountryNameThe former Yugoslav Rep. of Macedonia   1.67514    1.08355   1.546
## CountryNameTogo                                   16.60592    0.93555  17.750
## CountryNameTokelau                                 5.96128    1.07556   5.542
## CountryNameTonga                                   5.95811    1.09323   5.450
## CountryNameTrinidad and Tobago                     6.72111    1.06546   6.308
## CountryNameTunisia                                 0.44151    1.09035   0.405
## CountryNameTurkey                                  6.91632    1.08258   6.389
## CountryNameTurkmenistan                            7.49060    1.02168   7.332
## CountryNameTurks and Caicos Islands                2.06332    1.05542   1.955
## CountryNameTuvalu                                  4.08975    1.10684   3.695
## CountryNameUganda                                  6.51169    0.95267   6.835
## CountryNameUkraine                                 2.24706    1.09411   2.054
## CountryNameUnited Arab Emirates                    2.32529    1.08369   2.146
## CountryNameUnited Kingdom                          2.69895    1.11821   2.414
## CountryNameUnited Rep. of Tanzania                -1.49409    0.84647  -1.765
## CountryNameUnited States                           2.18054    1.09450   1.992
## CountryNameUnited States Virgin Islands            3.34431    1.08133   3.093
## CountryNameUruguay                                 3.78143    1.07115   3.530
## CountryNameUzbekistan                              2.06692    1.05802   1.954
## CountryNameVanuatu                                 4.01565    1.05636   3.801
## CountryNameVenezuela                               2.70309    1.05663   2.558
## CountryNameViet Nam                                3.06108    1.00203   3.055
## CountryNameWallis and Futuna Islands               2.15852    1.08049   1.998
## CountryNameWestern Sahara                          6.95698    1.03695   6.709
## CountryNameYemen                                   2.24062    0.86433   2.592
## CountryNameZambia                                 10.96667    0.84999  12.902
## CountryNameZimbabwe                                9.36887    0.88246  10.617
## Year11                                            -0.49062    0.14608  -3.359
## Year12                                            -0.77505    0.14264  -5.434
## Year13                                            -1.00756    0.14355  -7.019
## Year14                                            -1.16751    0.14489  -8.058
## Year15                                            -1.42159    0.14483  -9.816
## Year16                                            -1.57733    0.14578 -10.820
## Year17                                            -1.74245    0.14577 -11.953
## Year18                                            -1.78803    0.14602 -12.245
## water_score                                       -0.54687    0.02912 -18.780
## sanitation_score                                   0.07988    0.01713   4.664
##                                                  Pr(>|t|)    
## (Intercept)                                       < 2e-16 ***
## CountryNameAlbania                               0.176213    
## CountryNameAlgeria                               0.001820 ** 
## CountryNameAmerican Samoa                         < 2e-16 ***
## CountryNameAndorra                               0.005811 ** 
## CountryNameAngola                                 < 2e-16 ***
## CountryNameAnguilla                              0.014524 *  
## CountryNameAntigua and Barbuda                   0.008415 ** 
## CountryNameArgentina                             0.000176 ***
## CountryNameArmenia                               5.66e-05 ***
## CountryNameAruba                                 0.004677 ** 
## CountryNameAustralia                             0.037479 *  
## CountryNameAustria                               0.061931 .  
## CountryNameAzerbaijan                            0.068995 .  
## CountryNameBahamas                               6.97e-07 ***
## CountryNameBahrain                               0.001074 ** 
## CountryNameBangladesh                             < 2e-16 ***
## CountryNameBarbados                              0.021316 *  
## CountryNameBelarus                               0.046703 *  
## CountryNameBelgium                               0.029800 *  
## CountryNameBelize                                0.006804 ** 
## CountryNameBenin                                  < 2e-16 ***
## CountryNameBermuda                               0.002388 ** 
## CountryNameBhutan                                 < 2e-16 ***
## CountryNameBolivia                                < 2e-16 ***
## CountryNameBosnia Herzegovina                    0.060222 .  
## CountryNameBotswana                              0.011271 *  
## CountryNameBrazil                                0.000448 ***
## CountryNameBritish Virgin Islands                0.031106 *  
## CountryNameBrunei Darussalam                     0.007526 ** 
## CountryNameBulgaria                              0.000516 ***
## CountryNameBurkina Faso                           < 2e-16 ***
## CountryNameBurundi                                < 2e-16 ***
## CountryNameCambodia                              1.51e-06 ***
## CountryNameCameroon                               < 2e-16 ***
## CountryNameCanada                                0.087590 .  
## CountryNameCape Verde                            0.557959    
## CountryNameCaribbean Netherlands                 0.000320 ***
## CountryNameCayman Islands                        0.070078 .  
## CountryNameCentral African Republic               < 2e-16 ***
## CountryNameChad                                   < 2e-16 ***
## CountryNameChannel Islands                       0.205124    
## CountryNameChile                                 0.004997 ** 
## CountryNameChina                                 0.023893 *  
## CountryNameColombia                              1.34e-13 ***
## CountryNameComoros                                < 2e-16 ***
## CountryNameCongo                                  < 2e-16 ***
## CountryNameCongo, Democratic Republic             < 2e-16 ***
## CountryNameCook Islands                          0.014767 *  
## CountryNameCosta Rica                            0.000195 ***
## CountryNameCote d'Ivoire                          < 2e-16 ***
## CountryNameCroatia                               0.015194 *  
## CountryNameCuba                                  0.335767    
## CountryNameCuracao                               0.005926 ** 
## CountryNameCyprus                                0.023631 *  
## CountryNameCzech Republic                        0.054135 .  
## CountryNameDenmark                               0.038482 *  
## CountryNameDjibouti                               < 2e-16 ***
## CountryNameDominica                              7.03e-09 ***
## CountryNameDominican Republic                    0.010872 *  
## CountryNameEast Timor                            0.833392    
## CountryNameEcuador                               0.039306 *  
## CountryNameEgypt                                 9.92e-09 ***
## CountryNameEl Salvador                           0.552526    
## CountryNameEquatorial Guinea                      < 2e-16 ***
## CountryNameEritrea                                < 2e-16 ***
## CountryNameEstonia                               0.026419 *  
## CountryNameEthiopia                              0.000298 ***
## CountryNameFalkland Islands (Malvinas)           0.280335    
## CountryNameFaroe Islands                         5.73e-05 ***
## CountryNameFederated States of Micronesia        1.19e-09 ***
## CountryNameFiji                                  0.011872 *  
## CountryNameFinland                               0.035176 *  
## CountryNameFrance                                0.021836 *  
## CountryNameFrench Guiana                         0.848541    
## CountryNameFrench Polynesia                      0.023325 *  
## CountryNameGabon                                  < 2e-16 ***
## CountryNameGambia                                 < 2e-16 ***
## CountryNameGeorgia                               0.382890    
## CountryNameGermany                               0.031839 *  
## CountryNameGhana                                  < 2e-16 ***
## CountryNameGibraltar                             0.002922 ** 
## CountryNameGreece                                0.045696 *  
## CountryNameGreenland                             0.002729 ** 
## CountryNameGrenada                               4.22e-05 ***
## CountryNameGuadeloupe                            0.056634 .  
## CountryNameGuam                                  0.000508 ***
## CountryNameGuatemala                             2.78e-08 ***
## CountryNameGuinea                                 < 2e-16 ***
## CountryNameGuinea-Bissau                          < 2e-16 ***
## CountryNameGuyana                                6.61e-14 ***
## CountryNameHaiti                                  < 2e-16 ***
## CountryNameHoly See                              0.007703 ** 
## CountryNameHonduras                               < 2e-16 ***
## CountryNameHong Kong                             0.006622 ** 
## CountryNameHungary                               0.026494 *  
## CountryNameIceland                               0.033862 *  
## CountryNameIndia                                  < 2e-16 ***
## CountryNameIndonesia                             0.001693 ** 
## CountryNameIran (Islamic Republic of)            0.041038 *  
## CountryNameIraq                                  0.778900    
## CountryNameIreland                               0.075365 .  
## CountryNameIsle of Man                           7.59e-06 ***
## CountryNameIsrael                                0.025226 *  
## CountryNameItaly                                 0.058277 .  
## CountryNameJamaica                               0.131108    
## CountryNameJapan                                 0.082269 .  
## CountryNameJordan                                0.000321 ***
## CountryNameKazakstan                             0.857799    
## CountryNameKenya                                 0.613974    
## CountryNameKiribati                              0.652107    
## CountryNameKorea, Dem. People's Rep. of          6.29e-15 ***
## CountryNameKorea, Republic of                    0.043877 *  
## CountryNameKosovo                                5.00e-05 ***
## CountryNameKuwait                                0.000262 ***
## CountryNameKyrgyzstan                            0.050238 .  
## CountryNameLao People's Dem. Rep.                8.21e-08 ***
## CountryNameLatvia                                0.014399 *  
## CountryNameLebanon                               0.286468    
## CountryNameLesotho                                < 2e-16 ***
## CountryNameLiberia                                < 2e-16 ***
## CountryNameLibyan Arab Jamahiriya                0.000123 ***
## CountryNameLiechtenstein                         0.008878 ** 
## CountryNameLithuania                             0.149966    
## CountryNameLuxembourg                            0.039929 *  
## CountryNameMacau                                 0.012999 *  
## CountryNameMadagascar                            0.056049 .  
## CountryNameMalawi                                9.74e-13 ***
## CountryNameMalaysia                              0.235030    
## CountryNameMaldives                              0.054118 .  
## CountryNameMali                                   < 2e-16 ***
## CountryNameMalta                                 0.038569 *  
## CountryNameMarshall Islands                      3.32e-06 ***
## CountryNameMartinique                            0.017865 *  
## CountryNameMauritania                             < 2e-16 ***
## CountryNameMauritius                             0.000226 ***
## CountryNameMayotte                               0.006763 ** 
## CountryNameMexico                                2.69e-07 ***
## CountryNameMonaco                                0.003646 ** 
## CountryNameMongolia                              0.881143    
## CountryNameMontenegro                            0.001027 ** 
## CountryNameMontserrat                            0.002012 ** 
## CountryNameMorocco                               0.012138 *  
## CountryNameMozambique                             < 2e-16 ***
## CountryNameMyanmar                               0.139537    
## CountryNameNamibia                               4.85e-05 ***
## CountryNameNauru                                 1.85e-12 ***
## CountryNameNepal                                 3.27e-07 ***
## CountryNameNetherlands                           0.027981 *  
## CountryNameNew Caledonia                         0.010968 *  
## CountryNameNew Zealand                           0.017523 *  
## CountryNameNicaragua                             0.003950 ** 
## CountryNameNiger                                  < 2e-16 ***
## CountryNameNigeria                                < 2e-16 ***
## CountryNameNiue                                  0.051551 .  
## CountryNameNorthern Mariana Islands               < 2e-16 ***
## CountryNameNorway                                0.032380 *  
## CountryNameOman                                  0.009234 ** 
## CountryNamePakistan                               < 2e-16 ***
## CountryNamePalau                                 0.038233 *  
## CountryNamePalestinian Territory, Occupied       0.224592    
## CountryNamePanama                                4.04e-06 ***
## CountryNamePapua New Guinea                       < 2e-16 ***
## CountryNameParaguay                              3.59e-11 ***
## CountryNamePeru                                  1.47e-14 ***
## CountryNamePhilippines                           4.64e-07 ***
## CountryNamePoland                                0.162321    
## CountryNamePortugal                              0.042922 *  
## CountryNamePuerto Rico                           0.189065    
## CountryNameQatar                                 0.005910 ** 
## CountryNameRepublic of Moldova                   0.097832 .  
## CountryNameReunion                               0.055603 .  
## CountryNameRomania                               2.38e-05 ***
## CountryNameRussian Federation                    0.020579 *  
## CountryNameRwanda                                0.175848    
## CountryNameSaint Helena                          0.086173 .  
## CountryNameSaint Kitts and Nevis                 0.007026 ** 
## CountryNameSaint Lucia                           1.42e-05 ***
## CountryNameSaint Pierre and Miquelon             0.940110    
## CountryNameSamoa                                 0.011505 *  
## CountryNameSan Marino                            0.009405 ** 
## CountryNameSao Tome and Principe                  < 2e-16 ***
## CountryNameSaudi Arabia                          0.000712 ***
## CountryNameSenegal                               0.000377 ***
## CountryNameSerbia                                0.195807    
## CountryNameSeychelles                            0.063457 .  
## CountryNameSierra Leone                           < 2e-16 ***
## CountryNameSingapore                             0.049228 *  
## CountryNameSint Maarten (Dutch part)             0.221750    
## CountryNameSlovakia                              0.113893    
## CountryNameSlovenia                              0.091356 .  
## CountryNameSolomon Islands                       1.10e-07 ***
## CountryNameSomalia                                < 2e-16 ***
## CountryNameSouth Africa                          3.57e-09 ***
## CountryNameSouth Sudan                            < 2e-16 ***
## CountryNameSpain                                 0.066826 .  
## CountryNameSri Lanka                             0.123782    
## CountryNameSt. Vincent and the Grenadines        1.53e-05 ***
## CountryNameSudan                                  < 2e-16 ***
## CountryNameSuriname                              1.44e-08 ***
## CountryNameSwaziland                             1.82e-06 ***
## CountryNameSweden                                0.047664 *  
## CountryNameSwitzerland                           0.039420 *  
## CountryNameSyrian Arab Republic                  0.005233 ** 
## CountryNameTaiwan                                0.101234    
## CountryNameTajikistan                            0.009086 ** 
## CountryNameThailand                              0.014499 *  
## CountryNameThe former Yugoslav Rep. of Macedonia 0.122331    
## CountryNameTogo                                   < 2e-16 ***
## CountryNameTokelau                               3.54e-08 ***
## CountryNameTonga                                 5.92e-08 ***
## CountryNameTrinidad and Tobago                   3.75e-10 ***
## CountryNameTunisia                               0.685591    
## CountryNameTurkey                                2.25e-10 ***
## CountryNameTurkmenistan                          3.77e-13 ***
## CountryNameTurks and Caicos Islands              0.050778 .  
## CountryNameTuvalu                                0.000228 ***
## CountryNameUganda                                1.20e-11 ***
## CountryNameUkraine                               0.040176 *  
## CountryNameUnited Arab Emirates                  0.032063 *  
## CountryNameUnited Kingdom                        0.015918 *  
## CountryNameUnited Rep. of Tanzania               0.077762 .  
## CountryNameUnited States                         0.046529 *  
## CountryNameUnited States Virgin Islands          0.002021 ** 
## CountryNameUruguay                               0.000428 ***
## CountryNameUzbekistan                            0.050944 .  
## CountryNameVanuatu                               0.000150 ***
## CountryNameVenezuela                             0.010622 *  
## CountryNameViet Nam                              0.002293 ** 
## CountryNameWallis and Futuna Islands             0.045934 *  
## CountryNameWestern Sahara                        2.80e-11 ***
## CountryNameYemen                                 0.009629 ** 
## CountryNameZambia                                 < 2e-16 ***
## CountryNameZimbabwe                               < 2e-16 ***
## Year11                                           0.000804 ***
## Year12                                           6.47e-08 ***
## Year13                                           3.43e-12 ***
## Year14                                           1.61e-15 ***
## Year15                                            < 2e-16 ***
## Year16                                            < 2e-16 ***
## Year17                                            < 2e-16 ***
## Year18                                            < 2e-16 ***
## water_score                                       < 2e-16 ***
## sanitation_score                                 3.39e-06 ***
## ---
## Signif. codes:  0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
## 
## Residual standard error: 1.37 on 1443 degrees of freedom
## Multiple R-squared:  0.9906, Adjusted R-squared:  0.989 
## F-statistic: 624.5 on 243 and 1443 DF,  p-value: < 2.2e-16

Here we note the following important metrics.

R-squared: 0.9851

Adjusted R-squared: 0.9826