Deriving Compa-ratio

Employees always expect that they are paid fairly compared to their co-workers, and hence, maintaining internal pay parity is important.

Competitiveness of each employee's pay can be assessed by Compa-ratio. In this exercise, you'll derive compa-ratio as:

$$\text{Compa-ratio} = \frac{\text{Actual compensation}}{\text{Median compensation}}$$

Median compensation is used by organizations to estimate the typical pay for any role/level. This metric helps the organization to correct the compensation of employees who are way below the median compensation.

Note: Remember, median is also known as the 50th percentile. Exactly 50 percent of people make less than the median and 50 percent make more.

本练习是课程的一部分

HR Analytics: Predicting Employee Churn in R

查看课程

练习说明

For each level, calculate the median compensation (median_compensation) and compa-ratio (compa_ratio).
Print the median compensation for each level.

交互式实操练习

通过完成这段示例代码来试试这个练习。

# Add median_compensation and compa_ratio
emp_compa_ratio <- emp_tenure %>%  
  group_by(___) %>%   
  mutate(median_compensation = ___, 
         compa_ratio = ___)

# Look at the median compensation for each level           
emp_compa_ratio %>% 
  ___(level, median_compensation)

编辑并运行代码