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.

This graph categorises the seriousness of each injury into major and minor. From the graph, the top three injuries that I have listed previous, only ‘crushing’ falls under major injury while ‘cut bruises’ and ‘sprain strains’ are minor injuries. It also shows that there are more minor injuries than major injuries occurred across all industries.

Now that I have find out the amount the different injuries and the seriousness of the injuries occurred in each industry, my next step is to explore more on the information of the victims.

I realised the I find of more from the victim by looking at their age which the raw data has provided.

From this graph, I could clearly see that there is a distribution in the injury records ranging from aged 17 to 81 and majority of the victims are from 19 to 67 years old. However, I would say that 25 to 32 age group is the biggest.

I have also marked the graph with the nature of injury so that I could filter them by the victim age based on the type of injury (Filter shown on the next graph)

Now that I have found out the most common age group, I need to further explore the cause of the injury. This would allow me to understand how the injury came about from all the data I have.

From the graph, it shows that half of the injuries are by self-induced while injuries caused by external factor is about 38% of the records and self and external factor is about 15%.

This graph further divides the type of injury into the respective cause. From the graph, self-induced injury is mainly caused by crushing while ‘cut-bruises’ holds the majority in the external and both self and external factors.

Tool Utilised

The tools used for this assignment.

1. Tableau
2. Microsoft Excel