Deriving Compa-level

Compa-ratio of greater than 1 implies the employee is paid above the median compensation, thus ensuring competitive pay.

Based on compa-ratio, you will calculate compa_level as:

"Above", if compa-ratio is greater than 1
"Below", otherwise

This exercise is part of the course

HR Analytics: Predicting Employee Churn in R

View Course

Exercise instructions

Use compa_ratio to derive compa_level as per the condition mentioned above.
Create a bar chart of compa_level for active and inactive employees.

Hands-on interactive exercise

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

# Add compa_level
emp_final <- emp_compa_ratio %>%  
  mutate(compa_level = ___)

# Compare compa_level for Active & Inactive employees
ggplot(emp_final, aes(x = status, fill = ___)) + 
  geom_bar(position = "fill")

Edit and Run Code