regan-rg/kenya-county-population-analysis

Excel analysis of Kenya's 2019 census population data across all 47 counties. # Kenya County Population & Economic Analysis Excel-based analysis of Kenya's 2019 census population data across all 47 counties, merged with Gross County Product (GCP) data to explore how population size relates to economic output — built as a structured 7-day project. ## Week 1 Progress Days 1–7 complete: raw data cleaned and restructured, summary statistics calculated, COUNTIF analysis applied, population merged with Gross County Product data via VLOOKUP, results visualized by region and by county, and brought together into a one-page dashboard. ## Overview This project moves from raw KNBS census data through cleaning, summary statistics, and a merge with county-level economic data, to a one-page dashboard answering: how is Kenya's population distributed, and does population size predict economic output? ## Business Problem Population data alone tells you how many people live where — not whether that county's economy matches its size. This analysis identifies which counties carry outsized economic weight relative to population, and which lag behind, information relevant to investment and resource-allocation decisions. ## Dataset - Kenya Population and Housing Census (KPHC) 2019 — population, households, land area, density - Gross County Product (GCP) 2020–2024 — economic output by county Source: Kenya National Bureau of Statistics. ## Tools Used Microsoft Excel — formulas, COUNTIF, VLOOKUP, PivotTables, charts. ## Process 1. Cleaned and restructured the raw KNBS dataset (flattened a two-row merged header, relocated the national total) 2. Calculated total and average population per county 3. Used COUNTIF to identify counties above 1 million population 4. Merged population and GCP data via VLOOKUP, joined on county name 5. Built a pivot table summarizing population and GCP by region 6. Visualized the top 10 counties by population, and the population-vs-GCP relationship 7. Consolidated all findings into a one-page dashboard ## Key Insights - Nairobi City has …