Median Employee Age
Median Employee Age - HR Metric - calculation
What (Definition)
Median Age measures the Median of ages of all employees in the company. .
Why (Benefits)
Understanding the age mix of your employees is part of measuring diversity in your workforce.
In order to make sure that there is no bias based on age, in your recruitment process and in your performance evaluation process and other HR processes, you need to measure the age mix of your workforce.
How (Calculation?)
Formula
Age in Days = (Current Date – Employee Birth Date + 1)
Median Age = Median of Ages calculated for each employee
We have to calculate the Age first for each employee and then calculate median of the ages.
Median Age Calculation with an Example
It is always recommended to have frequency distribution data in addition to the overall median.
Use Frequency distributions data
This is where we create bins or buckets or categories of age, and count frequency of occurrence of each bin. In our example, we can create bins based on years of age. Let’s take a look at this chart.
Employee Age Distribution chart
We are now displaying the number of employees in each bin. For example, there are 5 employees with ages between 20 and 30 years. This type of visualization helps understand the concentration of employees in age buckets. It also will show any outliers more clearly.
Recommended:
Please make sure that you are segmenting this metric by Department, Location, Manager and other attributes, to ensure that there is no age bias in any subgroups within the company.
Related HR metrics
Now, it’s your turn.
How do you measure age distribution in your company? Please share your thoughts below. I look forward to learning from you.