abelgaiya/MSMEClimateVulnerabilityNigeria

Analyzing open source data on MSME climate vulnerability in Nigeria # MSMEClimateVulnerabilityNigeria Analyzing open source data on MSME climate vulnerability in Nigeria # WBES 2025 Enterprise Survey Analysis ## 📊 MSME Energy Access, Finance & Operations Analysis This repository contains an R script that analyzes the **World Bank Enterprise Survey (WBES) 2025** dataset, focusing on Micro, Small, and Medium Enterprises (MSMEs). The analysis examines key business environment indicators including equipment ownership, electricity access, power outages, financial inclusion, and operational challenges. ## 🎯 Key Features - **Equipment Ownership Analysis**: Generator, solar panel, website, and quality certification ownership rates by enterprise size and gender - **Electricity Access**: Primary electricity sources, generator and solar adoption rates, and percentage of electricity from backup sources - **Power Outages**: Frequency, duration, and economic impact of power outages on MSMEs - **Financial Inclusion**: Bank account ownership, credit access, loan application outcomes, and working capital financing sources - **Revenue Analysis**: Sales patterns, growth rates, and productivity metrics - **Business Obstacles**: Assessment of electricity as a constraint to business operations - **All analyses segmented by**: Enterprise size (5 categories) + Gender of top manager + Overall benchmark totals ## 📁 Data Requirements ### Input File - **Filename**: `EnterpriseSurvey.xlsx` - **Source**: World Bank Enterprise Survey 2025 - **Location**: Update the `file_path` variable in the script to point to your data file ### Expected Data Structure The script expects the following key variables (standard WBES 2025 naming): | Variable | Description | |----------|-------------| | `l1` | Permanent full-time workers | | `b7a` | Gender of top manager (1=Female, 2=Male) | | `c10` | Generator ownership | | `c43` | Solar panel ownership | | `c11` | % of electricity from generators | | `c44` | % of electricity from solar | | `c6-c9` | Power outage indicators …