Get startedGet started for free

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.

This exercise is part of the course

HR Analytics: Exploring Employee Data in R

View Course

Exercise instructions

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.

Hands-on interactive exercise

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

# Output the average engagement score for each department, sorted
survey %>%
  ___ %>%
  ___ %>%
  ___
Edit and Run Code