📖 Background

You work for the road safety team within the department of transport and are looking into how they can reduce the number of major incidents. The safety team classes major incidents as fatal accidents involving 3+ casualties. They are trying to learn more about the characteristics of these major incidents so they can brainstorm interventions that could lower the number of deaths. They have asked for your assistance with answering a number of questions.

💪 Competition challenge

Create a report that covers the following:

1. What time of day and day of the week do most major incidents happen?
2. Are there any patterns in the time of day/ day of the week when major incidents occur?
3. What characteristics stand out in major incidents compared with other accidents?
4. On what areas would you recommend the planning team focus their brainstorming efforts to reduce major incidents?

🧑‍⚖️ Judging criteria

✅ Checklist before publishing into the competition

• Remove redundant cells like the judging criteria so the workbook is focused on your story.
• Make sure the workbook reads well and explains how you found your insights.
• Check that all the cells run without error.

⌛️ Time is ticking. Good luck!