Final 4Dec2019_HRDataset_After

December 4, 2019
Exam
ns 1. Unhappy, Return to School, Retiring, Relocation out of area. Ans 2. 14 Female employees from Production Department have left because of "Another Position" Ans 3. 11 employees are joining in near future. Ans 4. Most expensive recruitment channels: Career builder: 7790 Pay per click: 1323 MBTA ads: 646 On campus recruiter: 625 Ans 5. 82.75 Ans 6. For a linear regression model, Pay Rate as depenedent Variable because this is the rate of money attained by an employee by keeping position, manager name, employee source, performance score and department as indepenedent variables. This model explains the that the amount of money is mostly depends on the position, department and manager as well which explains the general rule of salary earned also. Ans 7. For a logistic regression model, Employement status as dependent variable which is of categorical nature. This would help me understand what are the variables which is impacting the status of employment. The factors for logistic regression taken are payrate, department, position, manager name and performance score. These variables are taken into cosideration beacuse they affect the status for any employee by a large degree. Ans 8. For CARTree, Reason for Termination will be in addition to the variables taken into consideration for logistic regression.Also to order to predict the results more accurately. Ans 9. The larger the lift value, the more significant is the correlation between the two variables. It also means that the two variables are independent and have nothing in common, still they show a high degree of association. In the first Rule, performance score=fully meets and terminated for a cause have high correlation. Lift ratio greater than 1 implies that the relationship between the Marital Description= Divorced and employee status=voluntarily terminated is more significant than would be expected if the two sets were independent. Also, the count of 3 shows, the three case where a person was divorced has voluntarily left the organisation. If the employee is able to meet performance score in 90 days, the employee is voluntarily terminated. A lift value greater than 1 implies that the relationship between the Performance score= 90 days meets and employee status=voluntarily terminated is more relevant than would be expected if the two items were independent. The count of 3 shows, the three transactions where a person has met his performance score and has voluntarily left the organisation.