Lauren-Akhidenor/Agricultural-Insurance-Northern-State-Nigeria

# Analysing the Drivers of Agricultural Insurance Engagement among Poultry Farmers in Northern Nigeria --- ## OVERVIEW Agricultural insurance plays a key role in reducing farming risks such as livestock disease outbreaks, market shocks, and climate-related losses. In Northern Nigeria, poultry farming is an important livelihood activity, yet engagement with agricultural insurance remains uneven. This project examines the **drivers of agricultural insurance engagement** among poultry farmers, focusing on awareness, perceived benefits, and the institutional and socio-economic factors shaping farmers’ decisions. The study does not focus on participation rates but instead explores the behavioural and structural determinants of insurance uptake. --- ## OBJECTIVES - **Awareness & Understanding** - Assess farmers’ knowledge of agricultural insurance and perceived benefits. - **Behavioural Drivers** - Identify the main reasons farmers engage with agricultural insurance (e.g., risk protection, financial security, institutional requirements). - **Socio-economic Factors** - Examine how income, education, farm size, and farming experience influence insurance engagement patterns. - **Institutional Influence** - Explore the role of banks and credit institutions in shaping insurance adoption, particularly through loan-linked requirements. --- ## DATASET & METHODOLOGY **Dataset** - 105 poultry farmers across 7 Northern Nigerian states: - Abuja - Benue - Kogi - Kwara - Nasarawa - Niger - Plateau **Tools Used** - Microsoft Excel: Data cleaning, descriptive statistics, and visualization - Microsoft Power BI: Advanced dashboards and DAX measures --- ## EXCEL ANALYSIS ### Data Cleaning - Removed duplicates - Handled missing values - Standardized categorical variables - Treated income outliers for consistency --- ### 📊 Descriptive Statistics - Mean Age: **39.41 years** - Mean Household Size: **3.89** - Years in Poultry Farming: - Minimum: 1 year - Maximum: 30 years - I …