Difference between revisions of "IS428 2016-17 Term1 Assign2 Lim Hui Ting"
| Line 19: | Line 19: | ||
==Data Preparation== | ==Data Preparation== | ||
| − | + | ===1. Irrelevant Columns Removed=== | |
{| border="1" style="border-collapse: collapse;" | {| border="1" style="border-collapse: collapse;" | ||
|- | |- | ||
| Line 45: | Line 45: | ||
|} | |} | ||
<br> | <br> | ||
| − | + | ===2. Reformat All Text Columns=== | |
{| style="margin: auto;" | {| style="margin: auto;" | ||
|[[File:Reformat1.png|400px|center]] | |[[File:Reformat1.png|400px|center]] | ||
Revision as of 00:22, 24 September 2016
Contents
Theme of Interest
1.Background
Recently, the issue of insufficient medical leave given to injured workers has come under the spotlight again. In May this year, the court has suspended Raffles Hospital orthopaedic surgeon Wong Him Choon, 51, for six months. He had operated on a construction worker’s broken hand, but gave him just two days' medical leave and certified him fit for light duties for a month after that (Ho, 2016).
In August this year, the straits times reported that a shipyard worker has to had his right index finger amputated after it was crushed by some falling metal. However, he was only given one day of medical leave and three months of light duties (Ho, 2016).
Insufficient medical leave given to injured workers is a widespread problem in the construction industry. Employers usually influence doctors to give injured workers shorter medical leave in order to avoid reporting the accident to the Ministry of Manpower(MOM). Employers can also maintain their clean safety record and avoid paying higher insurance premiums in the future. (Foo, 2016)
Since injured employees are entitled to sufficient medical leave on proper clinical grounds, this assignment aims to analyse the distribution of the duration of the medical leave given to injured employees not just in the construction industry but the other industries in Singapore.
2. Questions for Investigation:
1)When do the accidents usually occur?
2)What are the injured employees’ characteristics?
3)What is the distribution of the number of MC days given to injured employees?
Tools Utilised
1.JMP Pro
2.Tableau
Data Preparation
1. Irrelevant Columns Removed
| Columns Removed | Reasons |
|---|---|
|
Analysis is not part of the objective of this assignment |
|
Not required as the same information can be taken from other columns |
|
Information is not useful as they are numerical representations of the descriptions set by MoM |
2. Reformat All Text Columns
 |
 |
From the raw data, we can see that some columns are in uppercase whereas some columns are in lowercase. Furthermore, as for the Occupation column, some rows are in uppercase,lowercase or titlecase. Thus, it is better to standardise all the text columns to titlecase in order for a neater presentation of findings. This is done by using the Titlecase function in the column’s formula in JMP.
