Leadership Without Self-Abandonment

Employee Turnover Analysis: Investigate Before Acting

ShareLinkedInFacebookX
Three unlabelled folders and a magnifying glass on a meeting table with empty chairs.
AI-generated illustration of comparing records, not actual employee or client data.

An exit can signal harm or a routine change: a retirement, a contract ending, or a move unrelated to work. The task is to understand the exits well enough to act with care.

Employee turnover analysis starts with clear counts. Compare like groups, test possible causes, and review the action you choose. The aim is a decision based on evidence.

What question should employee turnover analysis answer?

Start with the decision in front of you. Are you weighing a manager change, a pay adjustment, a role redesign, or no action at all? The analysis should serve that choice.

Ask a question you can answer. "Why do people leave?" invites a story. "Have voluntary exits from this role risen since March, and does the evidence point to workload?" gives you a place to start.

Use the findings to narrow the options before you spend money or change someone's job. They do not give you certainty.

Which exits and denominator are you counting?

Define the group, period and exit types first. Then count. People may quit, be laid off, be dismissed, retire, change teams, or reach the end of a contract. A total helps plan staffing and costs. Split it by type to explore causes.

Define which company or unit you are counting. Someone who moves to another team or role inside the company has not left it. Track internal moves apart from company exits. Record role changes and team changes separately too.

Write down how you code contract endings and retirements. Use those rules each time. Other datasets may use different rules.

Then choose the denominator. One option is average headcount on the same date each month. State the dates and use the same method each time. State whether you count people or full-time equivalents (FTE).

Match the units. If you count people who left, divide by headcount. A person count divided by FTE is a different measure; label it clearly.

End-of-month dates have a limit. Three months of 38, 40 and 42 average to 40, but that average can miss swings inside a month. Note changes in the group or errors in the records. Correct errors openly. If a business unit changes shape, explain where the comparison breaks. Show any restated figures.

A review of a century of theory traces job attitudes, shocks, embeddedness and collective turnover. Those lenses help you generate better questions. They are not a test of one local departure, and you cannot apply them automatically to your own case (Hom et al., 2017).

A worked illustration, not a benchmark

These figures are made up to show the method. They are not client data or a tested tool.

Suppose average headcount for one quarter was 40, with four voluntary exits and two layoffs. No other exits are assumed.

MeasureNumeratorDenominatorResult
Voluntary exit rate4 voluntary exits40 average headcount10%
All-separation rate6 separations40 average headcount15%

Divide exits by average headcount, then multiply by 100. These are local rates for one quarter. They are not annual rates or national benchmarks.

Do not multiply a quarter's rate by four and call it the year's actual rate. The pattern may change. One unusual month can skew it. In a small group, one exit matters. With headcount held at 40, one extra exit adds 2.5 percentage points to the rate. That is a change in percentage points, not a relative percent change.

No single group size makes every result reliable. Treat small counts with care.

What do interviews and patterns actually show?

Exit interviews miss the people who stay. An approved survey of current staff can add their views. Some people may not respond, so it may still miss part of the picture.

Keep three measures separate: plans to leave, job satisfaction, and actual exits. A person can be unhappy and stay for years, or content and leave for a family reason. Do not treat these as the same outcome.

Meta-analytic work refreshed and extended the predictor set, tested moderators, and found context-dependent relationships between antecedents and turnover (Rubenstein et al., 2018). You cannot apply a ranking automatically to your team. A correlation inside one team is not proof of cause, and a vivid interview quote is a single perspective, not a finding.

Check other possible causes. The role, length of service, contract type, season, or a recent team change may help explain exits. Match these where you can. That can improve a comparison, but it does not remove all bias.

How can you compare possible explanations fairly?

Write down two or three possible causes. State what would support each one and what would weaken it. Look for evidence against your first idea too.

Possible causeWhat would support itWhat would challenge itNext authorized check
Workload is driving exitsMore exits in like groups with more work; overdue work risesLike groups with less work show the same patternReview approved group workload data and staff views before a pilot
Pay or role expectations mismatchExits cluster after a pay cycle or role changeExits span pay bands and roles that did not changeCompare group pay data after a privacy review
Planned contract mix explains itMost recorded exits are fixed-term endingsMost recorded exits are voluntary, with no contract endCheck records against your written rules; correct documented errors

These are possible explanations, not findings. The rates above do not tell you which is right.

Keep individual sensitivity out of the comparison. Do not build tables around protected traits, and do not report cells so small that a person can be identified from their own row. If a group is too small to report safely, suppress it or combine it before it circulates.

How do you protect privacy while investigating?

Work from an authorized purpose, defined access and minimal aggregate output. Decide who may see the data, where it is stored securely, how long it is retained, and how it will be deleted. Route the plan through a qualified HR or privacy review for non-emergency process, and treat that as a scope decision, because requirements vary by jurisdiction.

For this investigation, do not collect health information, union activity, sensitive protected traits or private communications. Do not build individual flight-risk scores, run surveillance, or feed any of it into automated employment decisions. Before any personnel decision, make sure the person affected has a fair process.

Aggregation helps and is not immunity. Small groups, linked tables and identifiable quotes can all defeat it.

If an immediate safety or fairness concern surfaces at any point, address it promptly through the proper route rather than parking it until the analysis is finished.

What action and review would test your explanation?

Choose one small action to test. Give it an owner, a cost and time budget, a review date, and limits to prevent harm.

Here is a made-up example. With HR agreement, an operations lead pauses one optional weekly report. The lead also changes the order of tasks for one team. The test lasts six weeks. Setup takes at most six staff hours within existing paid time. Assume no extra cash cost. Count overdue work each week, using the same definition. Ask staff how it is working too. Protect other teams' workload, required deadlines, and safety requirements. Stop the test if it breaches those limits or proves unworkable.

At week six, compare results with the starting point. Note other changes that could explain them. This does not prove cause. Track exits over a longer, comparable period with the same definitions and method.

No exits in a quiet quarter would not prove that the pilot worked.

Use this original worksheet to keep a clear record. It is a working aid, not a validated tool. Enter figures from your own case.

You can discuss your leadership context if you want support working through these choices. For related work, see the cost of a bad hire and how to discuss workload with your manager. Browse more in the Insights library.

Key takeaways

  • Define the group, period and exit types before you count. Keep internal moves separate from company exits.
  • You can average monthly headcounts. Match the units and dates. Month-end counts can miss changes during the month.
  • A local quarterly rate is not an annual rate; one exit at a headcount of 40 moves the rate by 2.5 percentage points.
  • Exit interviews exclude people who stay, and intention, satisfaction and observed exit are not the same measure.
  • Use authorized, minimal, privacy-reviewed aggregate data, and never build individual risk scores or surveillance.

Frequently asked questions

Does high turnover prove the manager is the problem?
No. A team pattern may point toward the manager. It may also reflect workload, pay, the role, contract mix or the season. Test it alongside other possible causes before you change a person's role.
Can I compare my quarterly rate with any published annual benchmark?
Not directly. The JOLTS program uses a monthly reference period and establishment payroll, with separations split into quits, layoffs and discharges, and other categories (U.S. Bureau of Labor Statistics, n.d.). Check that periods, populations, exit types and denominators match before comparing rates. Your own consistent measures over time may be more useful.
Should every employee departure be prevented?
No. Some exits are healthy: retirements, planned contract endings and people leaving roles that no longer fit them. Retention is a choice, not a default. Ask which exits you genuinely want to reduce before designing any action around them.

References

- Hom, P. W., Lee, T. W., Shaw, J. D., & Hausknecht, J. P. (2017). One hundred years of employee turnover theory and research. Journal of Applied Psychology, 102(3), 530-545.

- Rubenstein, A. L., Eberly, M. B., Lee, T. W., & Mitchell, T. R. (2018). Surveying the forest: A meta-analysis, moderator investigation, and future-oriented discussion of the antecedents of voluntary employee turnover. Personnel Psychology, 71(1), 23-65.

- U.S. Bureau of Labor Statistics. (n.d.). JOLTS frequently asked questions.

This article is for informational and educational purposes only and does not constitute financial, legal, tax, medical, or professional advice. Individual results vary.

Work with Mherie

Building something that deserves to last?

Work with Mherie →
Newsletter

Perspective, occasionally.

A considered note on leadership, building meaningful companies, and the road less travelled. A few times a month, never noise.

Your details and consent will be sent securely and stored for Mherie's office.