Extra Activity 1
Data of 100+ rows & 5 columns
Data of 100+ rows & 5 columns
Here is my data google sheet
(pl click on the link; dataset is given therein)
Rows: each row represents a single country. There are 195 rows (so ~195 countries/territories).
Columns (in simple words):
Country Name — the country’s full name (text).
Country Code — 3-letter country code (text).
Birth rate — numeric. Based on the values (min ≈ 7.9, max ≈ 49.66, mean ≈ 21.47), this looks like a crude birth rate measure (i.e., births per 1,000 people) or a similarly scaled birth metric.
Internet users — numeric. Values run from about 0.9 up to 96.55 with a mean ≈ 42.08 — this reads like percentage of population who use the Internet.
Income Group — categorical labels (four groups present): High income, Upper middle income, Lower middle income, Low income. No missing values in any column.
Internet users: min ≈ 0.9%, median 41%, max ≈ 96.55%, mean ≈ 42.08%.
Birth rate: min ≈ 7.9, median 19.68, max ≈ 49.66, mean ≈ 21.47.
No missing values in the columns.
There is a strong negative relationship between birth rate and internet penetration in this dataset:
The Pearson correlation between Birth rate and Internet users is −0.816 (strongly negative)
When we split by Income Group the pattern is clear:
High income countries (67 entries): average Internet users ≈ 74.23%, average Birth rate ≈ 12.75.
Upper middle income (48): avg Internet ≈ 40.28%, avg Birth rate ≈ 18.74.
Lower middle income (50): avg Internet ≈ 22.37%, avg Birth rate ≈ 26.31.
Low income (30): avg Internet ≈ 5.99%, avg Birth rate ≈ 37.24.
Wealthier countries in this dataset tend to have much higher internet penetration and substantially lower birth rates Lower-income countries have low internet use and much higher birth rates.
This is consistent with the demographic transition (due to education, access to information/healthcare, urbanization and economic development all correlate with internet access) are associated with falling fertility.
Other observations:
About 34% of countries in the world are classified as high-income (67 out of 195).
Roughly 15% of countries are low-income (30 out of 195).
Nearly half of all countries (≈50%) fall in the middle-income range (lower-middle + upper-middle = 98 countries).
Upper-middle-income countries alone make up about 25% of the global country count.
Lower-middle-income countries account for another 26%, making them the single largest group.
Only about 1 in 7 countries has average internet usage below 10%, and most of them are low-income.
Over one-third of countries have average internet usage above 60%, concentrated almost entirely in high-income economies.
More than 40% of countries have birth rates above 25, predominantly outside the high-income group.
No low-income country appears among the top internet-using countries, highlighting a strong digital divide.
High-income countries represent just one-third of nations but account for the majority of global digital connectivity.