Casualty Patterns Analysis for Road Safety

🧐 What Problem Does This Project Solve?

Road safety remains a critical issue, with numerous accidents caused by varying environmental and operational factors. This project aims to analyze road accident trends, identify casualty patterns, and uncover the root causes of these incidents to improve safety strategies.

🛠️ How Was the Problem Solved?

The project used Microsoft Excel to analyze a comprehensive dataset of road accidents from 2021-2022. Key steps included:

• Conducting monthly trend analysis to track accident patterns.
• Exploring the influence of road surfaces, light conditions, and location types (urban vs. rural).
• Creating impactful visualizations to present findings in an understandable and actionable format.

✅ How Close Did This Project Get to Solving the Problem?

The project successfully provided actionable insights into casualty patterns, empowering stakeholders to develop safety strategies. Key outcomes include:

• Identification of critical trends and hotspots in accident data.
• Clear understanding of environmental and operational factors contributing to accidents.
• Comprehensive visualizations that support data-driven road safety policies.