Lab2_AnswersTemplate

CST8390 - Lab 2 Data Preparation and Cleaning - Answers Part 1 8. Which are the four important attributes that are relevant for data analysis? Country, branch, currency, salary 9. For the nominal attributes of the above question, fill in the following table: Attribute Name: ID Attribute Name: Branch Label Count Label Count CHINA 36 1 38 USA 38 2 39 GERMANY 38 3 37 MEXICO 37 4 35 JAPAN 1 6 1 Attribute Name: Currency Label Count CHY 38 EUR 38 MXD 35 USD 38 INR 1 10. Analyze your data to see any anomalies. List the identified anomalies below. Write why you think those records are anomalies in the following format (add rows as required):

Id first_name last_name email Address Country Branch Currency Salary Reason 100149 Darcy Addie daddie1k@jalbum.net 836 Marquette Pass Germany 2 EUR 60500999 Darcie has a salary that is significantly higher than anyone else in their branch, country, or currency, making them an outlier in multiple fields. 100204 Misha Tunna mtunnaj@dailymotion.com 15 Kipling Drive USA 1 USD 32000999 Misha also has a salary that much higher than others in their branch, country and currency making them another notable outlier. 100233 Bel Hodgin bhodgin2g@msu.edu 60 Bellgrove Court Japan 3 CHY 600000 Bel is the only employee working out of Japan 100187 Elsworth Skells eskells35@spotify.com 54486 Carberry Park Mexico 4 CHY 150000 Only employee in branch 4 using Chinese currency 100169 Chelsie Mulles cmulles3x@amazon.co.uk 8 Talmadge Circle Mexico 6 MXD 36000 Chelsie is the only employee working in branch 6 100187 Elsworth Skells eskells35@spotify.com 54486 Carberry Park Mexico 4 CHY 150000 Elsworth is the only employee working in Mexico using Chinese currency 100247 Nelson McRinn nmcrinn3p@economist.com 56053 Buell Terrace Mexico 2 MXD 19999 Nelson is the only employee in branch 2 working in Mexico 100139 Burton Dudden bdudden39@japanpost.jp 050 Nova Court Mexico 4 INR 45999 Burton is the only employee using INR currency 100233 Bel Hodgin bhodgin2g@msu.edu 60 Bellgrove Court Japan 3 CHY 600000 One of two people not in China using Chinese currency 100247 Nelson McRinn nmcrinn3p@economist.com 56053 Buell Terrace Mexico 2 MXD 19999 Only person in branch 2 not using EUR currency

(Add more rows as required. You will be able to find at least 8 anomalies) Part 2 8. How many instances do you have now? ____3010_______________________ 9. Take a screenshot and save it in lab2.doc.