research assitant part 2
athena.
external_segments.xlsxSheet1
| Demographic Segment | Pop. Total 2008 | Pop. Total 2011 | % of Change | Crude Birth rate 2008 | Crude Birth rate 2011 | % of Change | Infant Mortality Rate 2008 | Infant Mortality Rate 2011 | % of Change | Pop. Density 2008 | Pop. Density 2011 | % of Change |
| Algeria | 34,428,028 | 35,980,193 | 5% | 21 | 20 | -5% | 29 | 26 | -10% | 14 | 15 | 7% |
| Angola | 18,037,964 | 19,618,432 | 9% | 43 | 41 | -5% | 102 | 96 | -6% | 14 | 15 | 7% |
| Benin | 8,355,980 | 9,099,922 | 9% | 40 | 39 | -3% | 73 | 68 | -7% | 76 | 80 | 5% |
| Burkina Feso | 15,515,258 | 16,967,845 | 9% | 44 | 43 | -2% | 85 | 82 | -4% | 57 | 60 | 5% |
| Cameroon | 18,758,778 | 20,030,362 | 7% | 37 | 36 | -3% | 82 | 79 | -4% | 40 | 41 | 3% |
| Chad | 10,653,762 | 11,525,496 | 8% | 46 | 44 | -4% | 99 | 97 | -2% | 8 | 9 | 13% |
| Congo | 3,836,339 | 4,139,748 | 8% | 36 | 35 | -3% | 65 | 64 | -2% | 11 | 12 | 9% |
| Cote de Ivorie | 18,987,007 | 20,152,894 | 6% | 35 | 34 | -3% | 85 | 81 | -5% | 60 | 62 | 3% |
| Demo. Of Congo | 62,474,901 | 67,757,577 | 8% | 45 | 43 | -4% | 114 | 111 | -3% | 28 | 29 | 4% |
| Egypt | 78,323,298 | 82,536,770 | 5% | 24 | 23 | -4% | 22 | 18 | -18% | 79 | 81 | 3% |
| Gabon | 1,450,310 | 1,534,262 | 6% | 27 | 27 | 0% | 53 | 49 | -8% | 6 | 6 | 0% |
| Ghana | 23,264,176 | 24,965,816 | 7% | 32 | 31 | -3% | 55 | 52 | -5% | 102 | 107 | 5% |
| Kenya | 38,455,418 | 41,609,728 | 8% | 38 | 37 | -3% | 53 | 48 | -9% | 68 | 71 | 4% |
| Mauritius | 1,268,565 | 1,286,051 | 1% | 13 | 12 | -8% | 13 | 13 | 0% | 625 | 631 | 1% |
| Morrocco | 31,321,453 | 32,272,974 | 3% | 20 | 19 | -5% | 32 | 28 | -13% | 70 | 72 | 3% |
| Mozambique | 22,332,900 | 23,929,708 | 7% | 39 | 37 | -5% | 82 | 72 | -12% | 28 | 30 | 7% |
| Nigeria | 150,665,730 | 162,470,737 | 8% | 40 | 40 | 0% | 86 | 78 | -9% | 165 | 174 | 5% |
| Senegal | 11,787,123 | 12,767,556 | 8% | 38 | 37 | -3% | 51 | 47 | -8% | 61 | 65 | 7% |
| South Africa | 48,793,022 | 50,586,757 | 4% | 22 | 21 | -5% | 45 | 35 | -22% | 40 | 41 | 3% |
| Tunisia | 10,328,900 | 10,673,800 | 3% | 18 | 18 | 0% | 16 | 14 | -13% | 66 | 68 | 3% |
| Zambia | 12,379,612 | 13,474,959 | 9% | 45 | 46 | 2% | 65 | 53 | -18% | 17 | 17 | 0% |
Sheet2
| Economic Segment | GDP per Cap.$ 2008 | GDP $ Per Capita2011 | % of Change | GNI per Capita 2008 | GNI 2011 | % | Inflation consumer prices 2008 | Inflation consumer prices 2011 | % of Change | Gross Savings% (GDP) 2008 | Gross Savings 2011 | % of Change |
| Algeria | 4,967 | 5,244 | 6% | 4260 | 4470 | 5% | 4.9 | 4.5 | -8% | 58 | 48 | -17% |
| Angola | 4,414 | 5,318 | 20% | 3320 | 3830 | 15% | 12.5 | 13.5 | 8% | 26 | 20 | -23% |
| Benin | 800 | 802 | 0% | 730 | 780 | 7% | 7.9 | 2.7 | -66% | 11 | 15 | 36% |
| Burkina Feso | 538 | 600 | 12% | 480 | 570 | 19% | 10.7 | 2.8 | -74% | N/A | N/A | ERROR:#VALUE! |
| Cameroon | 1,265 | 1,260 | -0% | 1150 | 1210 | 5% | 5.3 | 2.9 | -45% | 16 | 12 | -25% |
| Chad | 784 | 823 | 5% | 550 | 690 | 25% | 10.3 | -4.9 | -148% | N/A | N/A | ERROR:#VALUE! |
| Congo | 3,091 | 3,485 | 13% | 1870 | 2250 | 20% | 7.3 | 1.3 | -82% | N/A | N/A | ERROR:#VALUE! |
| Cote de Ivorie | 1,223 | 1,195 | -2% | 1070 | 1090 | 2% | 6.3 | 4.9 | -22% | 12 | 13 | 8% |
| Demo. Of Congo | 187 | 231 | 24% | 160 | 190 | 19% | 17.3 | -100% | N/A | N/A | ERROR:#VALUE! | |
| Egypt | 2,079 | 2,781 | 34% | 1880 | 2600 | 38% | 18.3 | 10.1 | -45% | 24 | 17 | -29% |
| Gabon | 10,022 | 11,114 | 11% | 7500 | 8080 | 8% | 5.3 | 1.3 | -75% | N/A | N/A | ERROR:#VALUE! |
| Ghana | 1,226 | 1,570 | 28% | 1160 | 1410 | 22% | 16.5 | 8.7 | -47% | 5 | 9 | 80% |
| Kenya | 792 | 808 | 2% | 740 | 820 | 11% | 26.2 | 14 | -47% | 13 | 14 | 8% |
| Mauritius | 7,600 | 8,755 | 15% | 6830 | 8040 | 18% | 9.7 | 6.5 | -33% | 17 | 14 | -18% |
| Morrocco | 2,793 | 3,054 | 9% | 2540 | 2970 | 17% | 3.7 | 0.9 | -76% | 33 | 28 | -15% |
| Mozambique | 443 | 535 | 21% | 380 | 470 | 24% | 10.3 | 10.4 | 1% | 4 | 14 | 250% |
| Nigeria | 1,375 | 1,502 | 9% | 1150 | 1280 | 11% | 11.6 | 10.8 | -7% | N/A | N/A | ERROR:#VALUE! |
| Senegal | 1,136 | 1,119 | -1% | 1020 | 1070 | 5% | 5.8 | 3.4 | -41% | 16 | 22 | 38% |
| South Africa | 5,613 | 8,070 | 44% | 5850 | 6960 | 19% | 11.5 | 5 | -57% | 15 | 16 | 7% |
| Tunisia | 4,345 | 4,297 | -1% | 3900 | 4070 | 4% | 4.9 | 3.6 | -27% | 22 | 25 | 14% |
| Zambia | 1,183 | 1,425 | 20% | 970 | 1160 | 20% | 12.4 | 6.4 | -48% | 13 | 28 | 115% |
Sheet3
| Sociocultrual Segment | Labor participation rate, female 2008 (% of female population ages 15+) | Labor woman 2011 | % of change |
| Algeria | 14 | 15 | 7% |
| Angola | 61 | 63 | 3% |
| Benin | 67 | 67 | 0% |
| Burkina Feso | 78 | 78 | 0% |
| Cameroon | 63 | 64 | 2% |
| Chad | 65 | 65 | 0% |
| Congo | 68 | 68 | 0% |
| Cote de Ivorie | 51 | 52 | 2% |
| Demo. Of Congo | 70 | 70 | 0% |
| Egypt | 23 | 24 | 4% |
| Gabon | 56 | 56 | 0% |
| Ghana | 67 | 67 | 0% |
| Kenya | 61 | 61 | 0% |
| Mauritius | 42 | 44 | 5% |
| Morrocco | 27 | 26 | -4% |
| Mozambique | 87 | 86 | -1% |
| Nigeria | 48 | 48 | 0% |
| Senegal | 66 | 66 | 0% |
| South Africa | 47 | 44 | -6% |
| Tunisia | 25 | 25 | 0% |
| Zambia | 74 | 73 | -1% |
Sheet4
| Physical Segment |
| Algeria |
| Angola |
| Benin |
| Burkina Feso |
| Cameroon |
| Chad |
| Congo |
| Cote de Ivorie |
| Demo. Of Congo |
| Egypt |
| Gabon |
| Ghana |
| Kenya |
| Mauritius |
| Morrocco |
| Mozambique |
| Nigeria |
| Senegal |
| South Africa |
| Tunisia |
| Zambia |
