Análise de RH: Prevendo Rotatividade de Funcionários em 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{ Actual Compensation }}{\text{Median Compensation}} $$
Compa-ratio de 1,2 ou 120% indica pagamento 20% acima da mediana
Compa-ratio de 1 ou 100% indica pagamento exatamente na mediana
Compa-ratio de 0,8 ou 80% indica pagamento 20% abaixo da mediana

# 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
Análise de RH: Prevendo Rotatividade de Funcionários em R