Africa Countries Data Set: 53 countries, 22 variables, 12 lessons with answers (Excel)

Real 2023 data for 53 African countries in one clean spreadsheet: population, median age, birth and death rates, fertility, life expectancy (now, 1990 and 1960), migration, urban %, density, GDP per person, CO2 and electricity per person.

Includes 12 ready lessons with worked answers (sampling, averages, IQR and outliers, box plots by region, PMCC, regression, Spearman's rank, gender gap, change since 1990, demographic transition, population pyramids, own investigation) and 12 population pyramids (Niger, Nigeria, Ethiopia, DR Congo, Kenya, Tanzania, Uganda, Egypt, Morocco, Ghana, South Africa, Mauritius).

Good for GCSE / A-level / IB Geography and Statistics case studies on development in Africa: a GCSE statistics large data set focused on one continent.

Free sample (12 countries, 3 lessons): https://payhip.com/b/NZIuA

Need every country? World Countries Large Data Set, 200 countries, $6.99: https://payhip.com/b/a0oxh

Sources: UN World Population Prospects 2024 (CC BY 3.0 IGO), World Bank WDI (CC BY 4.0), Our World in Data / Global Carbon Project / Ember (CC BY 4.0), cited inside.

Licence: use with your own classes and modify; please do not resell the files.

Built with our own code from public data; the lesson tasks were drafted with AI help, and every answer was computed from the data.

Custom data packs, maps or worksheets for your class: hello@lilambd.com