|
Development Data File on the 10 Countries of the Nile
| Country | GNP per capita (US$) | Population without safe water (%) | Population Growth Rate (%) | Annual Freshwater Withdrawals per capita in m³ | Life Expectancy at Birth (years) | Infant Mortality (per 1,000 live births) | Daily Calories Intake per capita | | Burundi | 140 | 48 | 2.3 | 20 | 42.7 | 106 | 1,685 | | D.R. of Congo | 110 | 32 | 2.9 | 18,101 | 51.2 | 128 | 1,755 | | Egypt | 1,290 | 13 | 1.5 | 920 | 66.7 | 51 | 3,287 | | Eritrea | 200 | 32 | 2.6 | N/A | 51.1 | 70 | 1,622 | | Ethiopia | 100 | 75 | 2.5 | 50 | 43.4 | 110 | 1,858 | | Kenya | 350 | 56 | 1.5 | 87 | 51.3 | 75 | 1,976 | | Rwanda | 210 | 21 | 2.8 | 134 | 40.6 | 105 | 2,056 | | Sudan | 290 | 27 | 2 | 669 | 55.4 | 73 | 2,395 | | Tanzania | 220 | 34 | 2.3 | 40 | 47.9 | 91 | 1,995 | | Uganda | 310 | 54 | 3.1 | 20 | 40.7 | 84 | 2,085 |
|
Use the data to see whether there is any relationship (or 'correlation')
between the following pairs of development indicators: |
- GNP per capita and population growth
- GNP per capita and annual freshwater withdrawals per capita
- Population without safe water and infant mortality
- Population without safe water and life expectancy
- Daily calorie intake per capita and annual freshwater withdrawals per capita
|
|
You could print out this page and use a statistical test
like Spearmans Rank or construct scatter graphs for the different
pairs of development indicators by hand. Alternatively, you can
use an Excel spreadsheet (Excel version 5.0/95) of the data and
get the computer to do the statistical correlations and scatter
graphs for you, using the Chart Wizard and Correl function.
|
|
Click here for an Excel spreadsheet version of the data
|
|
|
Click here for help on how to use the spreadsheet, Chart Wizard and Correl. |
|
|
Data Analysis
For each of the pairs of development indicators:
- What type of correlation would you expect and why?
- Describe the correlation that is shown by your scatter graph or statistical test result.
- Are there any countries that are exceptions to the overall correlation pattern? Why do you think this is?
- What happens to the results of your scatter graph or statistical test result if you remove the countries that have significantly different data to the rest (anomalies)?
|
|
