Water Stressed Countries in Nile River Basin
And their dependancies ratios
Final Term Presentation
ABDELREHIM YEHYA
UCF ID: 5018350
CAP5738 -Fall 2020
12/3/2020
Term Project Objective
The objective of the research is to identify the level of water stress and the countries dependency
ratios on the Nile River, based on the published data using developed charts. It is an attempt
to raise awareness of the international community on the continued stumbling negotiations
between Egypt, Sudan and Ethiopia about GERD; the matter that would have negative repercussions
on the stability and development of the whole region, particularly Egypt.
Dependency ratios
The high dependency ratio aggravates the situation of a country. Having most of the resources produced outside the borders, putting Egypt and Sudan in a critical position; given the fact the lack of control of these resources.
Linear regression analysis for projections
##
## Call:
## lm(formula = Population ~ Year, data = egy_pop)
##
## Residuals:
## Min 1Q Median 3Q Max
## -4.5508 -3.7318 0.2409 2.9508 7.1247
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -2.441e+03 8.328e+01 -29.32 2.46e-15 ***
## Year 1.257e+00 4.176e-02 30.10 1.63e-15 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 3.848 on 16 degrees of freedom
## Multiple R-squared: 0.9826, Adjusted R-squared: 0.9816
## F-statistic: 906.2 on 1 and 16 DF, p-value: 1.625e-15
##
## Call:
## lm(formula = Population ~ Year, data = eth_pop)
##
## Residuals:
## Min 1Q Median 3Q Max
## -11.558 -8.108 1.309 6.109 14.691
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -3.022e+03 1.813e+02 -16.66 1.56e-11 ***
## Year 1.548e+00 9.092e-02 17.03 1.13e-11 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 8.379 on 16 degrees of freedom
## Multiple R-squared: 0.9477, Adjusted R-squared: 0.9444
## F-statistic: 290 on 1 and 16 DF, p-value: 1.125e-11
##
## Call:
## lm(formula = Population ~ Year, data = sud_pop)
##
## Residuals:
## Min 1Q Median 3Q Max
## -2.9864 -1.9235 -0.0628 1.5352 4.7121
##
## Coefficients:
## Estimate Std. Error t value Pr(>|t|)
## (Intercept) -1187.7398 49.4572 -24.02 5.60e-14 ***
## Year 0.6085 0.0248 24.54 4.01e-14 ***
## ---
## Signif. codes: 0 '***' 0.001 '**' 0.01 '*' 0.05 '.' 0.1 ' ' 1
##
## Residual standard error: 2.285 on 16 degrees of freedom
## Multiple R-squared: 0.9741, Adjusted R-squared: 0.9725
## F-statistic: 602 on 1 and 16 DF, p-value: 4.01e-14
Decay of Yearly Water Share per capita in Eastern Nile Basin countries
The eventual increase in countries population will become problematic as overpopulation will strain current water resources to their limits, cause an increase in water pollution, and lead to an increase in civil and international conflicts over existing water supplies.