Calculate turnover rate across salary hike range
In the previous exercise, you created multiple categories of percent_hike for employees at the Analyst level. Now it's your turn to calculate the turnover rate across these categories and examine the difference in turnover if any.
This will help you understand if there is a difference in the percentage of employees leaving the organization in different categories of salary hike.
This exercise is part of the course
HR Analytics: Predicting Employee Churn in R
Exercise instructions
- Calculate the average turnover rate for each category in
hike_range. - Generate a bar chart to plot the average turnover rate for each
hike_range.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
# Calculate the turnover rate for each salary hike range
df_hike <- emp_hike_range %>%
___(___) %>%
___(turnover_rate_hike = mean(turnover))
# Check the results
df_hike
# Visualize the results
ggplot(df_hike, aes(x = ___, y = ___)) +
geom_col()