How to Calculate New Hire Retention Rate
A reader recently asked me a great question about new hire retention, namely how to measure it over multiple years. To my embarassment, it turns out I have never actually addressed that topic. In today’s post, we’ll show you how to measure new hire retention (and turnover) and how to execute it in both R and Excel.
Why New Hire Retention Matters
We often talk about employee turnover but embedded in our broader employee population is a special group, namely new hires.
Understanding how long more recent hires stay at our company is important for identifying barriers to growth and development challenges, successful or unsuccessful hiring practices, and possible future stress points in workforce planning.
Similar to turnover, asking a question about new hire retention essentially means asking what proportion of our new hires are sticking around over some period of time. The only real difference in our measure of new hire retention/ new hire turnover v. our standard measures of turnover is that we take the hiring date into account when talking about new hires.
As with most things, I think the best approach is to keep things really simple.
Let’s suppose we want to look at new hire retention for anyone hired within the last 2 years. Here are the basic steps
Basic Steps for New Hire Turnover
- Total up the number of people you have hired in the last two years (or whatever period you are concerned with); don’t worry about those who were hired before your cutoff. Just filter them out.
- Get the total number of new hires that also voluntarily left your organization in that same time window.
- Divide the number of leavers in Step 2 by the total number of new hires in Step 1 to get your new hire turnover rate.
Basic Steps for New Hire Retention
Retention is just the complement of turnover.
- Total up the number of people you have hired in the last two years (or whatever period you are concerned with); don’t worry about those who were hired before your cutoff. Just filter them out.
- Get the total number of new hires who have stayed with your organization in that same time window.
- Divide the number of stayers in Step 2 by the total number of new hires in Step 1 to get your new hire rate.
It’s that simple.
What Time Period is Best?
There is no single answer because it depends on your business question. To help you get a feel for your data and your organization, I would suggest that you plot the duration of employment for those who leave voluntarily using a histogram or a boxplot.
You might find that most of the quitting is done within the first few months…or perhaps most of it occurs after 18 months…or perhaps it’s evenly distributed.
Why is this important?
Because the timing of when people quit relative to their hire date might tell you something meaningful about underlying hiring, turnover, and retention challenges.
For example, the steps you might need to consider if everyone quits in the first month would likely be different than if you find people are mostly leaving after a year or two. One pattern might signal poor hiring practices or poor pay while another might signal frustration with limited opportunities for career growth.
What Counts as a “Voluntary” Departure?
Depending on the type of organization you work with and the kind of roles you are filling, you might need to carefully consider your definition of “voluntary” quitting.
For instance, sometimes employees just stop showing up. That might be considered a form of quitting even though they might technically have been fired. In other cases, there is simply a broader pattern of not being reliable, leading to involuntary removal. You also might need to consider leaves of absence and remove those from the calculations.
Regardless of what you decide, the key is just be transparent and consistent with what you are measuring.
Finally, I would encourage you to keep a running calculation, performing it every quarter so that your new hire retention window moves along over time and you can see trends emerging.
That said, I would caution you against going back too far in time. Looking at a 3-year window that began in 2013 and ends in 2016 might have very little relevance to decision making processes in the current economic and labor climate.
Examples in R and Excel
Let’s first generate some data to work with.
set.seed(42)
emp_id <- seq(1,1000)
hire_date <- sample(seq(as.Date('1998/01/01'), as.Date('2018/01/01'), by="day"), 1000)
term <- sample(c(0,1), 1000, replace = T, prob = c(.9, .2))
emp_dur <- as.integer(1000)
for (i in 1:1000){
if (term[i] == 1){
emp_dur[i] <- rnorm(1, 180, 40)
}
}
term_date <- hire_date + emp_dur
d <- data.frame(emp_id, hire_date, term, term_date, emp_dur)
Our data is a mix of people who have left and who are still here. It also has a range of hire dates.
Calculating New Hire Turnover and Retention in R
Our first step is to filter down to just those who have been hired after some cutoff. Let’s say we want to only look at those who have been hired in the last 2 years (since 1 May 2016)
We’ll use the subset function to create a new dataframe with just those individuals:
d2 <- subset(d, hire_date >= as.Date('2016/05/01'))
Now we just need to look at the proportion of those in this group that have left voluntarily. This will give us our new hire turnover metric. We can do this by getting the mean of the term field in this dataset (since a termination = 1).
We could also just as easily get this from the summary function. I provide both here.
mean(d2$term)
## [1] 0.2278481
summary(d2)
## emp_id hire_date term
## Min. : 2.0 Min. :2016-05-04 Min. :0.0000
## 1st Qu.:241.0 1st Qu.:2016-10-04 1st Qu.:0.0000
## Median :542.0 Median :2017-02-19 Median :0.0000
## Mean :512.7 Mean :2017-02-24 Mean :0.2278
## 3rd Qu.:790.0 3rd Qu.:2017-07-31 3rd Qu.:0.0000
## Max. :979.0 Max. :2017-12-14 Max. :1.0000
##
## term_date emp_dur
## Min. :2016-11-10 Min. : 90.91
## 1st Qu.:2017-05-07 1st Qu.:155.68
## Median :2017-07-22 Median :174.86
## Mean :2017-08-12 Mean :179.06
## 3rd Qu.:2017-12-01 3rd Qu.:207.33
## Max. :2018-05-19 Max. :243.86
## NA's :61 NA's :61
The results show that we have a turnover rate of 23% over the last 2 years for our new hires.
Retention is the complement of turnover so we just subtract the turnover rate from 1 to get our retention rate of 77% percent for new hires over the same period.
Finally, let’s see what we can learn from a histogram of the durations of employment for our leavers.
library(ggplot2)
library(wesanderson)
ggplot(data = d2[d2$term == 1,], aes(x = emp_dur)) + ggtitle ('Distribution of Employment Duration for Leavers') + xlab( 'Employment Duration') + geom_histogram(fill = wes_palette("Zissou1")[2], binwidth = 25, color = 'black')
The results here show us that our leavers start to head for the exits around 5-7 months. Note again that your possible action steps here are somewhat different from what you might do if people were leaving in the first month. The main thing here is realize that doing a distribution of employment can shed light on the processes.
Calculating New Hire Turnover and Retention in Excel
I’m going to export the data we created to a csv and then show you how to calculate new hire turnover in Excel.
write.csv(d, './new_hire_retention_CSV.csv')
First, we’ll open up our data in Excel and create a pivot table.
Then we’ll “hire date” to the filter column and insert a timeline filter
Finally, we can calculate the average of our term column to give us the percentage of new hires that voluntarily termed in that period (23% as expected), yeilding a complementary new hire retention rate of 77%.
Summary
New hire retention and turnover are essentially HR metrics but just as importantly, be sure to look at the distribution of voluntary terminations relative relative to the hire date. Doing this will help move you from looking at a single number to talking about your hiring, your people, and the processes that drive their employment decisions.
Like this post? Have Something to Say?
Add your comments OR just send me an email: john@hranalytics101.com
I would be happy to answer them!
Get our FREE Turnover Mini Course!
You’ll get 5 insight-rich daily lessons delivered right to your inbox.
In this series you’ll discover:
- How to calculate this critical HR metric
- How turnover can actually be a GOOD thing for your organization
- How to develop your own LEADING INDICATORS
- Other insightful workforce metrics to use today
There’s a bunch more too. All free. All digestible. Right to your inbox.
Yes! Sign Me Up!
Contact Us
- © 2023 HR Analytics 101
- Privacy Policy