Difference between revisions of "ANLY482 AY2017-18T2 Group13 Analysis & Findings"
Jump to navigation
Jump to search
Line 36: | Line 36: | ||
Manipulation and Cleaning of Training Records | Manipulation and Cleaning of Training Records | ||
− | [[File:Jmp missing data pattern.png| | + | [[File:Jmp missing data pattern.png|500px|center| Using JMP Pro, missing data pattern analysis was conducted on training records to identify missing data points. ]] |
+ | In order to rectify these missing data points, we replaced the values whenever possible as the team hopes to analyze as many data points as possible. When replacement of values are not possible, records are excluded from analysis. | ||
+ | |||
+ | {| class="wikitable" | ||
+ | |- | ||
+ | ! Missing data (Field) !! Action | ||
+ | |- | ||
+ | | Start and End date || 1. Attempted to find corresponding dates from exact course titles, unsuccessful | ||
+ | 2. Attempt to take 'Create date' however inaccurate as record could have been created after actual start and end date | ||
+ | |||
+ | 3. Excluded (Final action) | ||
+ | |- | ||
+ | | Category|| Replaced missing data with corresponding records with exact course title | ||
+ | |} | ||
Revision as of 23:08, 25 February 2018
DATA CLEANING & MAPPING
Manipulation and Cleaning of Training Records
In order to rectify these missing data points, we replaced the values whenever possible as the team hopes to analyze as many data points as possible. When replacement of values are not possible, records are excluded from analysis.
Missing data (Field) | Action |
---|---|
Start and End date | 1. Attempted to find corresponding dates from exact course titles, unsuccessful
2. Attempt to take 'Create date' however inaccurate as record could have been created after actual start and end date 3. Excluded (Final action) |
Category | Replaced missing data with corresponding records with exact course title |
INSIGHTS
To be updated
ANALYSIS
To be updated