Get startedGet started for free

Attrition rates by recruiting source

Another quality of hire metric you can consider is the attrition rate, or how often hires leave the company. Determine which recruiting channels have the highest and lowest attrition rates.

In the last exercise, the output was a data frame with the recruiting channels and the average quota attainment. It would have been easier to tell which channel had the highest-performing employees if it were sorted with arrange().

This exercise is part of the course

HR Analytics: Exploring Employee Data in R

View Course

Exercise instructions

recruitment and dplyr are loaded in your workspace.

  • Use summarize() to calculate the attrition rate within each recruiting source. Store it in a new column called attrition_rate.
  • Sort the result by attrition rate, from lowest to highest, and assign it to avg_attrition.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Find the average attrition for the sales team, by recruiting source, sorted from lowest attrition rate to highest
avg_attrition <- recruitment %>%
  ___ %>% 
  ___ %>% 
  ___

# Display the result
avg_attrition
Edit and Run Code