How does the outlier list in Rapidminer compare to the outliers that you could manually calculate in Excel

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

MGMT8520

Data Analytics and Financial Management II

 

Assignment 2 – Outlier Detection and Employee Absenteeism

QUESTIONS (80 marks)

Once you have created the worksheet (with the Rapidminer outliers and correlations sheets copied in), you have some questions to answer about the data you see. Answer these in a textbox in the worksheet to which they refer.

1.      How does the outlier list in Rapidminer compare to the outliers that you could manually calculate in Excel? Explain. (5 marks)

2.      What is the total cost of absenteeism to our company? What is the ratio of absentee cost to annual salaries? (5 marks)

3.      How does the absentee/annual salaries ratio compare to the U.S. plant? Based on the data you have what accounts for the difference? Explain. (10 marks)

4.      Is there a strong correlation between any of the absentee attributes found using RapidMiner? Explain. (5 marks)

5.      Create pivot tables in a single worksheet to help you answer these questions. Which absentee code has the most lost wages cost associated with it? What % of lost wages? Which sex is more prone to injury and by what ratio? Which are the top two (2) positions in cost of absenteeism? Speculate as to why these two positions, in other words, what type of absenteeism is most prevalent in these positions? Write your brief answers next to each pivot table in a text box. (25 marks)

6.      In Column X, calculate the Employee Absence Rate (Unplanned absences/Work days). Can you see a pattern between position, Pay Type, and Employee Absence Rate? Speculate about what you see. (5 marks)

 

7.      Create a 1-page memo in Word describing 3 key points you have found in your analysis around the impact of absenteeism on our company, and how you plan to use the Bradford Factor score to help our company measure, understand, and reduce the cost of absenteeism. This may include text, numbers, charts, screen shots, whatever data you feel will help you recommend an approach to absenteeism for the company. (25 marks)

Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme