Difference between revisions of "IS428 2016-17 Term1 Assign2 Wang Ziteng"
Jump to navigation
Jump to search
(2) |
(3) |
||
| Line 1: | Line 1: | ||
==Abstract== | ==Abstract== | ||
| − | Workplace security has always been an important issue for Singapore Minister of Manpower. To develop a productive workforce and progressive workplaces, MOM should know more about the workplace injuries in different aspects. Through 2014, the data regarding to workplace injuries was collected by all the employees in Singapore. This report will focus on the workplace injuries issue and give analysis based on Workplace Injuries Data 2014. | + | Workplace security has always been an important issue for Singapore Minister of Manpower. To develop a productive workforce and progressive workplaces, MOM should know more about the workplace injuries in different aspects. Through 2014, the data regarding to workplace injuries was collected by all the employees in Singapore. This report will focus on the workplace injuries issue and give analysis based on Workplace Injuries Data 2014. |
==Theme of Interest== | ==Theme of Interest== | ||
| − | To know more about the situation of workplace injuries and better deal with it, we need to know the overall trend of the number of injuries and injuries situation in different groups according to different categorizations. Thus, the government can make more specific policies to help employees. | + | To know more about the situation of workplace injuries and better deal with it, we need to know the overall trend of the number of injuries and injuries situation in different groups according to different categorizations. Thus, the government can make more specific policies to help employees. |
==Analytical & Investigation Questions== | ==Analytical & Investigation Questions== | ||
| − | 1. What is the overall trend of number of injuries through the year? | + | 1. What is the overall trend of number of injuries through the year? <br/> |
| − | 2. What is the overall trend of number of injuries in each day of the week through the year? | + | 2. What is the overall trend of number of injuries in each day of the week through the year?<br/> |
| − | 3. What is the injuries situation in different occupation? | + | 3. What is the injuries situation in different occupation?<br/> |
| − | 4. Does the months worked matters? | + | 4. Does the months worked matters?<br/> |
| − | 5. What is the frequency of different causes of injuries? | + | 5. What is the frequency of different causes of injuries?<br/> |
| + | |||
==Data Preparation== | ==Data Preparation== | ||
| − | 1. Data Selection | + | 1. Data Selection<br/> |
| − | From all the 48 variables, I choose 11 of them. | + | From all the 48 variables, I choose 11 of them. <br/> |
| − | Accident Day | + | Accident Day<br/> |
| − | Accident Weekday | + | Accident Weekday<br/> |
| − | Accident Month | + | Accident Month<br/> |
| − | Major Industry | + | Major Industry<br/> |
| − | Sub Industry | + | Sub Industry<br/> |
| − | Body Pars Injured | + | Body Pars Injured<br/> |
| − | Nature of Injury | + | Nature of Injury<br/> |
| − | Accident Type level 2 Category | + | Accident Type level 2 Category<br/> |
| − | Cause | + | Cause<br/> |
| − | Occupation | + | Occupation<br/> |
| − | Months worked | + | Months worked<br/> |
| − | 2. Check the distribution of the fields | + | 2. Check the distribution of the fields<br/> |
| − | To check the categorized data and numerical data and see whether they are valid. For categorized data, I need to know whether the categorizations are typed correct. For numerical data, I need to see whether the distribution make sense. | + | To check the categorized data and numerical data and see whether they are valid. For categorized data, I need to know whether the categorizations are typed correct. For numerical data, I need to see whether the distribution make sense. |
| − | + | <br/> | |
| − | 3. Lowercase Formatting (Occupation) | + | 3. Lowercase Formatting (Occupation)<br/> |
| − | I noticed that the format of Occupation is not consistent which will make it troublesome when using this field. So I used JMP Pro to lowercase the data. | + | I noticed that the format of Occupation is not consistent which will make it troublesome when using this field. So I used JMP Pro to lowercase the data. |
==Data Visualization== | ==Data Visualization== | ||
| − | 1. What is the overall trend of number of injuries through the year? / | + | 1. What is the overall trend of number of injuries through the year? <br/> |
| − | 2. What is the overall trend of number of injuries in each day of the week through the year? | + | 2. What is the overall trend of number of injuries in each day of the week through the year?<br/> |
| − | 3. What is the injuries situation in different occupation? | + | 3. What is the injuries situation in different occupation?<br/> |
| − | 4. Does the months worked matters? | + | 4. Does the months worked matters?<br/> |
| − | 5. What is the frequency of different causes of injuries? | + | 5. What is the frequency of different causes of injuries?<br/> |
==Conclusion== | ==Conclusion== | ||
| + | |||
==Tools== | ==Tools== | ||
1. Tableau Desktop | 1. Tableau Desktop | ||
2. JMP Pro 12 | 2. JMP Pro 12 | ||
Revision as of 09:18, 26 September 2016
Contents
Abstract
Workplace security has always been an important issue for Singapore Minister of Manpower. To develop a productive workforce and progressive workplaces, MOM should know more about the workplace injuries in different aspects. Through 2014, the data regarding to workplace injuries was collected by all the employees in Singapore. This report will focus on the workplace injuries issue and give analysis based on Workplace Injuries Data 2014.
Theme of Interest
To know more about the situation of workplace injuries and better deal with it, we need to know the overall trend of the number of injuries and injuries situation in different groups according to different categorizations. Thus, the government can make more specific policies to help employees.
Analytical & Investigation Questions
1. What is the overall trend of number of injuries through the year?
2. What is the overall trend of number of injuries in each day of the week through the year?
3. What is the injuries situation in different occupation?
4. Does the months worked matters?
5. What is the frequency of different causes of injuries?
Data Preparation
1. Data Selection
From all the 48 variables, I choose 11 of them.
Accident Day
Accident Weekday
Accident Month
Major Industry
Sub Industry
Body Pars Injured
Nature of Injury
Accident Type level 2 Category
Cause
Occupation
Months worked
2. Check the distribution of the fields
To check the categorized data and numerical data and see whether they are valid. For categorized data, I need to know whether the categorizations are typed correct. For numerical data, I need to see whether the distribution make sense.
3. Lowercase Formatting (Occupation)
I noticed that the format of Occupation is not consistent which will make it troublesome when using this field. So I used JMP Pro to lowercase the data.
Data Visualization
1. What is the overall trend of number of injuries through the year?
2. What is the overall trend of number of injuries in each day of the week through the year?
3. What is the injuries situation in different occupation?
4. Does the months worked matters?
5. What is the frequency of different causes of injuries?
Conclusion
Tools
1. Tableau Desktop 2. JMP Pro 12
