IS428 2016-17 Term1 Assign2 Lim Lai Ho

Theme

This assignment aims to find the relationship between the victim’s age and the causing factor, at which age group is the common when accidents occurred and what are the causes and consequence of the accidents. From these findings, I aim to offer some recommendations/measurements to reduce the amount of accidents occurred within the age group found.

Attributes Used

1. Major Industry Type
2. Nature of Injury
3. Major Injury Indicator
4. Victim’s Age
5. Cause

Step by Step

To begin with, I have examined the data from the raw file to filter out which one the related attributes that I would need. The type of Major Industry seems to be the appropriate attribute for me to explore first as it would help me to find out which industry has the most accidents. Also, I have added more attribute, the Nature of Injury into the same bar graph so that I would know what are the amount of different injury within each industry.

This bar graph depicts that ‘Others’ industry has half the total amount of Injury recorded and Construction and Manufacturing each have half of the ‘Others’ industry. The ‘Others’ industry has the most number of injury records.

This graph further breakdown each industry into the nature of injury. From this graph, I could clearly see that the top three injuries are ‘cut bruises’, ‘crushing’ and ‘sprain strains’ in all industries.

To further explore how serious these injuries could be, I decided to plot the following graph.

Tool Utilised

The tools used for this assignment.

1. Tableau
2. Microsoft Excel