Final exam-BI

December 4, 2019
Ans 1) Another Position Unhappy More Money Career Change Ans 2) 16 Ans 3) 11 Ans 4) Career Builder Pay Per CLick MBTA Ads On-Campus Recruiting Ans 5) 82.76 % keeping future joinees out of the calculation for "Employee Referral" category. Ans 6) To build a linear regression model, I have taken 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) To build a logistic regression model, I have taken 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) If we would have to chosse CART, I would like to use Reason for Termination in addition to the variables taken into consideration for logistic regression as well in order to predict the results more accurately. Ans 9) The larger the lift ratio, 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 case, performance score=fully meets and terminated for a cause have high correlation. A lift ratio larger 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 ratio larger 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.