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

Exercise

Sales numbers by recruiting source

Which recruiting channel produces the best salespeople? One quality of hire metric you can use is sales quota attainment, or how much a salesperson sold last year relative to their quota. An employee whose sales_quota_pct equals .75 sold 75% of their quota, for example. This metric can be helpful because raw sales numbers are not always comparable between employees.

Calculate the average sales quota attainment achieved by hires from each recruiting source.

Instructions 1/2

undefined XP
    1
    2

recruitment and dplyr are loaded in your workspace.

  • Use summarize() to calculate the average sales quota attainment. Store it in a new column called avg_sales_quota_pct.