Combining HR datasets (II)

As per Gallup's research, employees leave managers, not companies. This explains the importance of a manager's role in an employee's commitment to stay in an organization.

Annual engagement surveys captures critical feedback from employees on multiple facets such as manager effectiveness, work satisfaction, performance satisfaction etc.

In this exercise, you will combine survey results to your dataset using mgr_id as the lookup key to compare manager effectiveness scores between Active and Inactive employees.

This exercise is part of the course

HR Analytics: Predicting Employee Churn in R

View Course

Exercise instructions

Use glimpse() to view the structure of the survey dataset.
Left join survey to org3 using "mgr_id" as the lookup key.
Generate a box plot to visualize the distribution of mgr_effectiveness scores for Active and Inactive employees.

Hands-on interactive exercise

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

# View the structure of survey dataset
___

# Complete the code to join survey to org3 dataset
org_final <- ___

# Compare manager effectiveness scores
ggplot(org_final, aes(x = status, y = ___)) +
  ___

Edit and Run Code