UNU-INWEH Global Water Security Assessment
Isaiah Omondi
2026-06-03
Created on Wed Jun 3 16:50:16 2026
Data Processing
Importing dataset
Component 1 - Water Availability
## [1] "code"
## [2] "countryc1"
## [3] "Total renewable water resources per capita"
## [4] "Interannual variability"
## [5] "Water Independence"| Total (N=186) |
|
|---|---|
| Total renewable water resources per capita | |
| Mean (SD) | 16900 (45500) |
| Median [Min, Max] | 3450 [0, 447000] |
| Interannual variability | |
| Mean (SD) | 1.77 (0.893) |
| Median [Min, Max] | 1.50 [0.600, 4.90] |
| Water Independence | |
| Mean (SD) | 35.6 (30.7) |
| Median [Min, Max] | 29.8 [0.300, 100] |
## code countryc1
## Length:186 Length:186
## Class :character Class :character
## Mode :character Mode :character
##
##
##
##
## Total renewable water resources per capita Interannual variability
## Min. : 0 Min. :0.600
## 1st Qu.: 1283 1st Qu.:1.100
## Median : 3447 Median :1.500
## Mean : 16910 Mean :1.771
## 3rd Qu.: 14416 3rd Qu.:2.400
## Max. :446950 Max. :4.900
## NA's :1 NA's :25
## Water Independence
## Min. : 0.30
## 1st Qu.: 7.30
## Median : 29.80
## Mean : 35.61
## 3rd Qu.: 60.90
## Max. :100.00
## NA's :63## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
Component 2 - Ambient Water Quality
## code countryc2
## Length:186 Length:186
## Class :character Class :character
## Mode :character Mode :character
##
##
##
##
## Proportion of water bodies with good ambient water quality
## Min. : 4.50
## 1st Qu.: 50.00
## Median : 69.61
## Mean : 64.10
## 3rd Qu.: 83.80
## Max. :100.00
## NA's :68
Component 3 - Drinking water Access
## code countryc3
## Length:186 Length:186
## Class :character Class :character
## Mode :character Mode :character
##
##
##
##
## Proportion of HH using safely managed drinking water services
## Min. : 6.00
## 1st Qu.:41.00
## Median :66.50
## Mean :62.93
## 3rd Qu.:89.00
## Max. :99.00
## NA's :78
## Proportion using Basic drinking water services
## Min. :36.00
## 1st Qu.:86.00
## Median :96.00
## Mean :89.42
## 3rd Qu.:99.50
## Max. :99.50
## NA's :2
Component 4 - Sanitation and Hygiene
## code countryc4
## Length:186 Length:186
## Class :character Class :character
## Mode :character Mode :character
##
##
##
##
## Proportion using safely managed sanitation services
## Min. : 0.00
## 1st Qu.:27.75
## Median :56.50
## Mean :56.10
## 3rd Qu.:84.25
## Max. :99.00
## NA's :62
## Proportion having Basic sanitation access
## Min. :10.00
## 1st Qu.:63.75
## Median :92.00
## Mean :78.66
## 3rd Qu.:99.00
## Max. :99.50
## NA's :2
## Proportion having basic hygiene access
## Min. : 0.00
## 1st Qu.:23.50
## Median :58.00
## Mean :55.64
## 3rd Qu.:86.00
## Max. :99.00
## NA's :91
Component 5 - WASH-Related Health
## code countryc5 Number of Diarrhoae Deaths
## Length:186 Length:186 Min. : 0.10
## Class :character Class :character 1st Qu.: 1.05
## Mode :character Mode :character Median : 3.00
## Mean : 15.38
## 3rd Qu.: 22.75
## Max. :175.80
## NA's :3
Component 6 - Health of Water-Dependent Ecosystem
## code countryc6
## Length:186 Length:186
## Class :character Class :character
## Mode :character Mode :character
##
##
##
##
## % Change in extent of water-related ecosystems over time
## Min. :-58.052
## 1st Qu.: 1.439
## Median : 9.302
## Mean : 16.236
## 3rd Qu.: 17.602
## Max. :299.552
## NA's :6
Component 7 - Water Productivity
## code countryc7 Water use efficiency
## Length:186 Length:186 Min. : 0.60
## Class :character Class :character 1st Qu.: 6.95
## Mode :character Mode :character Median : 14.65
## Mean : 50.66
## 3rd Qu.: 50.12
## Max. :1362.00
## NA's :18
Component 8 - Water Governance & Enabling Environment
## code countryc8 Degree of IWRM Implementation
## Length:186 Length:186 Min. : 12.00
## Class :character Class :character 1st Qu.: 40.00
## Mode :character Mode :character Median : 55.50
## Mean : 56.70
## 3rd Qu.: 70.25
## Max. :100.00
## NA's :2
## WGI_Voice & Accountability WGI_\r\nGovernment Effectiveness
## Min. :16.77 Min. : 9.09
## 1st Qu.:38.64 1st Qu.:37.37
## Median :54.63 Median :49.45
## Mean :53.53 Mean :51.06
## 3rd Qu.:65.81 3rd Qu.:63.44
## Max. :90.62 Max. :95.67
## NA's :1 NA's :1
## WGI_Political Stability WGI_Regulatory Quality WGI_Rule of Law
## Min. :18.91 Min. :22.76 Min. :19.01
## 1st Qu.:54.22 1st Qu.:42.90 1st Qu.:40.69
## Median :64.71 Median :52.64 Median :52.64
## Mean :63.35 Mean :53.49 Mean :54.25
## 3rd Qu.:76.12 3rd Qu.:62.62 3rd Qu.:66.89
## Max. :91.51 Max. :88.49 Max. :91.75
## NA's :1 NA's :1 NA's :1
## WGI_Control of Corruption
## Min. : 6.06
## 1st Qu.:28.89
## Median :41.90
## Mean :45.55
## 3rd Qu.:60.52
## Max. :94.16
## NA's :1
Component 9 - Water and Climate disasters
## code countryc9 Total Number of deaths_flood
## Length:186 Length:186 Min. : 0.0
## Class :character Class :character 1st Qu.: 4.0
## Mode :character Mode :character Median : 18.5
## Mean : 284.3
## 3rd Qu.: 138.0
## Max. :8073.0
## NA's :42
## Total number of people affected_flood Flood frequency
## Min. : 0 Min. : 1.000
## 1st Qu.: 19223 1st Qu.: 2.000
## Median : 204880 Median : 5.000
## Mean : 3620305 Mean : 7.819
## 3rd Qu.: 2390508 3rd Qu.: 9.000
## Max. :42149278 Max. :84.000
## NA's :42 NA's :42
## Proportion of population exposed to drought (%) Total Number of deaths_drought
## Min. : 0.57 Min. : 10.0
## 1st Qu.: 25.00 1st Qu.: 241.0
## Median : 60.66 Median : 472.0
## Mean : 55.83 Mean : 982.3
## 3rd Qu.: 93.39 3rd Qu.:1468.5
## Max. :100.00 Max. :2465.0
## NA's :92 NA's :183
## Total number of people affected_drought Drought frequency
## Min. : 10300 Min. :1.000
## 1st Qu.: 653787 1st Qu.:1.000
## Median : 2185846 Median :1.000
## Mean : 5876288 Mean :1.417
## 3rd Qu.: 8020173 3rd Qu.:1.250
## Max. :30900000 Max. :5.000
## NA's :142 NA's :138## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
Component 10 - Water Resource Vulnerability
## code countryc10 Water Resource Vulnerability Index
## Length:186 Length:186 Min. :0.00000
## Class :character Class :character 1st Qu.:0.06725
## Mode :character Mode :character Median :0.13800
## Mean :0.15947
## 3rd Qu.:0.21725
## Max. :0.57200
## NA's :26
## GDP per Capita Future Climate Change Projections
## Min. : 219.4 Min. :0.000
## 1st Qu.: 2466.7 1st Qu.:2.325
## Median : 7122.8 Median :3.600
## Mean : 17523.8 Mean :3.819
## 3rd Qu.: 23920.0 3rd Qu.:5.000
## Max. :137781.7 Max. :8.800
## NA's :2## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## `stat_bin()` using `bins = 30`. Pick better value `binwidth`.
## code countryc1
## Length:186 Length:186
## Class :character Class :character
## Mode :character Mode :character
##
##
##
##
## Total renewable water resources per capita Interannual variability
## Min. : 0 Min. :0.600
## 1st Qu.: 1283 1st Qu.:1.100
## Median : 3447 Median :1.500
## Mean : 16910 Mean :1.771
## 3rd Qu.: 14416 3rd Qu.:2.400
## Max. :446950 Max. :4.900
## NA's :1 NA's :25
## Water Independence countryc2
## Min. : 0.30 Length:186
## 1st Qu.: 7.30 Class :character
## Median : 29.80 Mode :character
## Mean : 35.61
## 3rd Qu.: 60.90
## Max. :100.00
## NA's :63
## Proportion of water bodies with good ambient water quality
## Min. : 4.50
## 1st Qu.: 50.00
## Median : 69.61
## Mean : 64.10
## 3rd Qu.: 83.80
## Max. :100.00
## NA's :68Interannual variability - Islands
During normalization, look out for reverse coded variables Normalization will depend on the distribution of the indicator Always drop extreme values and then test for normality. e.g. Total renewable water resources