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
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 calledattrition_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