Ocholar/mel-case-study-kenya

MEL Quantitative Case Study - Kenya MSME Manufacturing Analysis # MEL Quantitative Case Study - Kenya MSME Manufacturing Analysis ## Overview This repository contains a comprehensive Monitoring, Evaluation, and Learning (MEL) analysis of 5,016 Micro, Small, and Medium Enterprises (MSMEs) in Kenya's manufacturing sector. The analysis focuses on employment creation, business growth, and the impact of training interventions on firm productivity and gender equity. **Project Status:** ✅ Complete **Analysis Date:** November 2025 **Data Source:** Kenya MSME Manufacturing Survey **Sample Size:** 5,016 firms across multiple counties --- ## Key Findings ### Employment Metrics - **Total Employment Generated:** 11,277 jobs - **Average Firm Size:** 2.25 employees - **Micro Firm Contribution:** 70% of total employment - **Female-Owned Firm Share:** 39.8% of employment (45% of firms) ### Training Impact - **Revenue per Employee (Trained Firms):** Ksh 108,740 - **Revenue per Employee (Non-Trained Firms):** Ksh 100,560 - **Efficiency Gain from Training:** 8.1% ### Sector Distribution | Sector | Firms | Share | | --- | --- | --- | | Food, Beverages & Tobacco | 1,358 | 27% | | Textiles, Apparel & Leather | 960 | 19% | | Wood, Paper & Printing | 802 | 16% | | Chemicals, Plastics & Non-Metallic Minerals | 555 | 11% | | Basic & Fabricated Metals | 498 | 10% | | Machinery & Transport Equipment | 374 | 7% | | Electronic & Electrical Equipment | 213 | 4% | | Other Manufacturing & Repair | 256 | 5% | --- ## Repository Structure ``` mel-case-study-kenya/ ├── README.md # This file ├── data/ │ ├── Data-CaseStudySCKenya_Original.xlsx # Original raw data (5,016 firms) │ └── Cleaned_Data_CaseStudySCKenya.xlsx # Cleaned and processed data ├── analysis/ │ ├── data_cleaning_analysis.py # Python script for data cleaning and analysis │ ├── chart_1_sector_distribution.png # Sector distribution visualization │ └── chart_2_avg_employees_by_training_gender.png # Employmen …