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

Exercise

Which department has the lowest engagement?

You and the HR analytics team have been asked to help the department with the lowest engagement score improve. The first step is to determine which department has the lowest score.

Instructions

100 XP

survey and dplyr are loaded in your workspace.

  • Use group_by(), summarize(), and arrange() to output a list of departments and the average engagement score for each one.
  • Name the average engagement score avg_engagement.
  • The lowest average engagement score should be at the top of the list.