HR Analytics:用 R 预测员工流失
Abhishek Trehan
People Analytics Practitioner
# Plot the distribution of compensation
ggplot(emp_tenure, aes(x = compensation)) +
geom_histogram()

# Plot the distribution of compensation across levels
ggplot(emp_tenure,
aes(x = level, y = compensation)) +
geom_boxplot()

$$ \text{Compa Ratio} = \frac{\text{ 实际薪酬 }}{\text{薪酬中位数}} $$
Compa-ratio 为 1.2(120%)表示该员工高于中位薪酬 20%
Compa-ratio 为 1(100%)表示该员工等于中位薪酬
Compa-ratio 为 0.8(80%)表示该员工低于中位薪酬 20%

# Derive Compa-ratio
emp_compa_ratio <- emp_tenure %>%
group_by(level) %>%
mutate(median_compensation = median(compensation),
compa_ratio = (compensation / median_compensation))
# Look at the median compensation for each level
emp_compa_ratio %>%
distinct(level, median_compensation)
# A tibble: 2 x 2
# Groups: level[2]
level median_compensation
<fct> <dbl>
1 Analyst 51840
2 Specialist 83496
HR Analytics:用 R 预测员工流失