1. Learn
    2. /
  2. Courses
    3. /
  3. HR Analytics: Exploring Employee Data in R

Exercise

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().

Instructions

100 XP

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.