Description: Analyzed a dataset of demographic details from various countries using advanced Excel techniques.
Skills and Tools: MS Excel (Named Ranges, Statistical Functions, Filters, Pivot Tables)
Tasks and Achievements:
Created named ranges for BirthRate and IncomeGroup.
Calculated key statistics including mean, median, variance, standard deviation, and IQR for birth rates and internet users.
Implemented filters to determine the income group of specific countries and counted countries within the same income group.
Developed a pivot table to summarize internet usage by country and income group.
Insights helped understand the relationship between income groups and internet usage across countries.