World Countries Large Data Set: 200 Countries, 22 Variables, 12 Statistics Lessons + Pyramids

A ready-to-teach GCSE / A level statistics large data set of every country with at least 100,000 people.

• 22 variables: population, median age, under-15 and over-65 shares, birth and death rates, fertility (now and 1960), life expectancy for men and women (now, 1990, 1960), net migration, urban %, density, GDP per person, CO2 per person, electricity per person, continent and region
• 12 tasks with worked answers: stratified sampling, mean vs median, quartiles and outliers, box plots by continent, PMCC, regression on log GDP, Spearman’s rank, gender gap, change since 1990, demographic transition, population pyramids, open investigation
• 24 population pyramids (PNG) from Niger to Japan
• One Excel workbook: README, Countries, Tasks, Answers, Sources

Data: 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).
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.

Free sample (25 countries, 3 tasks, 4 pyramids) and an Africa edition (53 countries): search LilambdCrossing on Tes.

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

Missing something? Tell us in one line what you’d gladly pay for, if someone made it — one-line form: https://docs.google.com/forms/d/1tzMQtHsEbMg7JyMk7YGqslHijfNTciByi8wrwjQpUPY/viewform (or email submissions@lilambd.com, subject “Data wish”). If enough people ask, we build it, and you get it free.

Used this? Tell us what you used it for, what was missing, and what you used before: https://docs.google.com/forms/d/1tzMQtHsEbMg7JyMk7YGqslHijfNTciByi8wrwjQpUPY/viewform (one minute, no email asked).

Need a specific file or dataset made? Ask here (no promise, quick form): https://docs.google.com/forms/d/e/1FAIpQLSf6V7YALfwE42SaF1re_cLzAoP96TpRg61jE3Nf7UTWEtWRxA/viewform