A data cleaning and analysis project using Microsoft Excel. In this activity, we explore key socio-economic indicators across 7 countries to highlight trends in education, internet access, and GDP.
This dataset showcases real-world data and is perfect for practicing:
- 🧹 Data wrangling
- 📊 Pivot table creation
- 📈 Chart building — Done using excel
| Column Name | Description |
|---|---|
| 🏳️ Country Name | Name of the country (e.g., Brazil, Germany, USA) |
| 🌐 Region | Continent or major geographical region |
| 📚 Literacy Rate (%) | % of population (15+) who can read and write |
| 🌐 Internet Access (%) | % of population with internet access |
| 🎓 Avg. Years of Schooling | Average years of formal education (age 25+) |
| 💵 GDP per Capita (USD) | Average income per person in USD |
| 👥 Population (Millions) | Country’s population in millions |
🛠️ Tools Used: Microsoft Excel
🧠 Skills Demonstrated:
- ✅ Cleaned and formatted raw data (removed blanks, corrected types, standardized formats)
- ✅ Used Pivot Tables to summarize data by Region and Literacy
- ✅ Built Pivot Charts to visualize relationships (e.g., Literacy vs GDP, Internet vs Schooling)
- ✅ Applied Conditional Formatting to highlight high/low performers
- 📚 Countries with higher education levels (literacy + schooling) showed higher GDP per capita
- 🌐 There’s a strong correlation between internet access and economic performance
- 🌍 Regional disparities exist, indicating digital and educational divides
This mini project is a part of my learning path at Npower Canada.
Made with 💚 by Simrah Ayan Fathima
📧 simrahayan2611@gmail.com
🔗 LinkedIn