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 Products

  • Human Resources Toolkit Excel Templates

Get automated HR metrics for your company with our templates
(Available in 3 platforms: Microsoft Power BI, Google Sheets or Microsoft Excel)

  • Human Resources Toolkit Excel Templates

Related Posts

HR Metric - Applications per Open Position

Applications Per Open Position

Gain insights into ‘Applications per Open Position’, a crucial HR metric, to understand recruitment demand and optimize hiring strategies. A key metric for HR professionals aiming to balance candidate influx with open job positions efficiently.

Read More »
HR Metric - Pending Applications

Pending Applications

Discover the significance of ‘Pending Applications’ in HR metrics; learn why tracking them is key for recruitment efficiency and how to manage them effectively.

Read More »

Now it’s your turn.

Do you measure the number of applications reaching a stage during the hiring period in your company? Please share your thoughts on how you do it below. We would like to hear from your experience.

To learn more about other recruiting metrics please visit HR Guides