Lorreta-Anyika/-Nigeria-Food-Inflation-Tracker-Excel-Project-
Domain:
socioeconomicagricultureRecord type:
dataset
Creator:
Lor
Host:
# 🇳🇬 Nigeria Food Inflation Tracker (Excel Project)
## Table of Contents
1. Project Overview
2. Key Questions Addressed
3. Data Sources
4. Key Skills, Formulas & Thought Process
5. Dashboard Features
6. Excel Sheets Breakdown
7. Excel Functions & Formulas Used
8. Key Analytical Insights
9. Strategic Relevance
10. About the Analyst
11. Let’s Collaborate
---
## Project Overview
**Role Fit:** Data Analyst | Food Security & Policy | Socioeconomic Impact
**Tool:** Microsoft Excel (Advanced)
**Time Frame Analyzed:** Nov 2023–Nov 2024
**Demo:** [Contact for dashboard walkthrough or screenshots]
This project investigates the surge in food prices across Nigeria, focusing on **regional disparities, affordability, and market risks**. Using recent market and wage data, it quantifies the real impact of inflation on households, highlights where and why prices are highest, and provides actionable insights for policymakers, NGOs, and business leaders.
> 💡 **Background**
> As food prices soar, the gap between paycheques and the cost of a simple plate of food is widening for millions of Nigerians. This tracker analyzes the crisis, exposes regional and item-level inequities, and flags urgent areas for intervention.
---
## Key Questions Addressed
- **How much have staple food prices increased across Nigeria over the past year?**
- **Which regions experience the highest price disparities for key staples?**
- **What percentage of the minimum wage is required to afford a basic food basket?**
- **Are there signs of price gouging in particular states or for specific foods?**
- **Do conflict-affected zones like Borno and Adamawa have higher or lower prices than the national average?**
- **Do port states (Lagos, Rivers) offer cheaper imported food prices compared to the national average?**
- **How is protein affordability changing and what does it mean for health?**
---
## Key Findings
- **A “one-unit shop” is now punishingly expensive:** Buying a single measure each of beans, oni …