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
Exercise instructions
survey
and dplyr
are loaded in your workspace.
- Use
group_by()
,summarize()
, andarrange()
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 %>%
___ %>%
___ %>%
___