1. Learn
  2. /
  3. Projects
  4. /
  5. HR Analytics: Predicting Employee Churn in R

Connected

Exercise

Derive job hop index

A job hopper is a person who switches jobs frequently for financial or career advancement opportunities. In some industries, recruiters and hiring managers may perceive job hoppers in a negative light and think they are unstable or disloyal employees.

In this exercise, you will derive job hop index as:

$$\text{Job Hop Index} = \frac{\text{Total experience}}{\text{Number of companies worked}}$$

Total experience (total_experience) and the number of companies worked (no_companies_worked) are available in org_final.

Using this index, loyal employees get a high score, and job-hoppers get a low score.

Instructions

100 XP
  • Derive job hop index (job_hop_index) using the above formula.
  • Generate a box plot to visualize the job hop index for Active and Inactive employees.