learn-people-analytics-with-phoebe / Foundations session 2 of 6
Learn People Analytics with Phoebe · Foundations session 2 of 6

An attrition rate needs a base

"Attrition is 44.6 percent" is four words and a number, and every one of the four words is hiding a decision. Attrition of whom: the group, an entity, a department of 75? Over which period: a half-year doubled, or a year measured? Counting which leavers: everyone who left, or only the ones you were sorry to lose? And 44.6 compared with what: last year, another company, a national survey that counts a different thing on a different clock? Tonight takes Apex's 210 leavers, constructed, and works each decision in turn. The rate never changes on its own; it changes every time one of those four decisions is made silently.

🟢 Foundations Leaders, HR partners, anyone who reads a people dashboard No code 45 min
0-3 · Welcome 3-18 · Annualising, small bases, regretted as a choice 18-40 · Build-along: the Apex rate card 40-45 · Q&A
Part 0

Where we start

Foundations session 1 ended with a rate and its base written under it: 210 leavers over an average headcount of 941.5, 22.3 percent for the half-year. That number is honest. It is also nearly useless on its own, because the first three questions anyone asks of it are "what is that for the year", "which teams" and "is that bad". Each of those questions changes the number, and each change is defensible only if it is written down. Apex is constructed, every person in it is invented, and the pages say so; the four decisions are real in every company.

🎫 Clear all three quiz questions to stamp your passport Live = presented in the 45 minutes Self-study = the full depth, after class ★ Build-along = everyone works it through

★ What you walk out with tonight. The word "annualised" and the assumption it always carries, a rule for how small a base can be before one person becomes a point, the habit of showing the categories behind any "regretted" figure, and the arithmetic that turns a monthly national quits rate into something you can hold beside a half-year rate without fooling anyone.

Part 1 · covers annualising and the benchmark question

The base is a decision, the doubling is an assumption

5 min live

Apex's half-year rate is 22.3 percent on the average base. The board pack will say 44.6, because a board thinks in years and somebody doubled it. Doubling is not wrong; it is a forecast wearing the clothes of a measurement. It says the second half of 2026 will look like the first, and for a company whose Sales department lost half its people between January and June, that is the one thing nobody knows.

THE SAME 210 LEAVERS, THREE BASES, THEN DOUBLED Apex H1 2026, constructed · bar length is the base start base: headcount 1 January 1,022 20.5% average base: (1,022 + 861) / 2 941.5 22.3% end base: headcount 1 July 861 24.4% hatched: the 210, identical in every row ignores the 49 joiners the usual choice shrinks with leavers ANNUALISED, BY DOUBLING 22.3% 22.3 again? H1, measured H2, assumed = 44.6% a year only if the second half repeats the first, which nobody has measured Four points of spread from the base, then another 22 from doubling. The doubled number is the one that travels without its assumption. Write the base under the rate, and the word annualised beside any figure that was.
🔍 Click to zoom - the dashed box is the half that has not happened yet; 44.6 is a bet that it will look like the hatched one
LiveAnnualising, and the assumption it carries3 min▶

Doubling a half-year rate assumes the second half repeats the first. For Apex, 22.3 percent on the average base becomes 44.6 percent annualised. The word "annualised" is doing real work in that sentence: it says the figure is a projection, built from six months of data, under an assumption that the next six months look the same. Drop the word, and 44.6 becomes a fact about a year that has not happened.

The assumption fails in both directions. If the Sales exodus was a one-off, the second half will be quieter and 44.6 overstates. If it was the start of something, the second half will be worse and 44.6 understates. The half-year figure does not know which, and neither does the doubling. What the number can honestly say is "22.3 percent in H1, which would be 44.6 for the year if H2 repeats it", and that is the sentence to put on the slide, unshortened.

The same trap runs the other way. A quarter's rate multiplied by four, a month's rate multiplied by twelve: every one of those multiplications is a forecast, and the shorter the period it was built from, the noisier the forecast. It also breaks a comparison: an annualised half-year against last year's measured full year is one projection beside one measurement, and the gap between them is partly the assumption.

LiveThe benchmark question: compared with what, on which clock2 min▶

"Is 22.3 percent bad" has no answer until three things are fixed: bad compared with whom, over what period, and counting which leavers. The comparison most people reach for is a national figure, and the best open one is the US Bureau of Labor Statistics quits rate from its JOLTS survey, which counts voluntary quits during a month as a percent of employment. It is monthly. Apex's figure is a half-year. The scale conversion is the self-study of the build-along below, and getting it wrong by a factor of six or twelve is the single most common way a benchmark misleads.

The second comparison is with last year, and there the question is whether last year's figure used the same base, the same period, and the same definition of leaver. Usually nobody knows, because it was never written down. The rate card in the build-along is how to make sure yours is.

Real world

The number that travelled. A half-year attrition figure gets doubled for a board slide, the slide gets quoted in a town hall, and by the next quarter the annualised projection is being compared with the following half-year's measured rate as though both were the same kind of number. Nobody lied at any step. The word "annualised" fell off the number at the second hand-over, and with it the assumption. Constructed scenario; the mechanism is not.

Part 2 · covers rates by entity and department

Eight departments, eight bases

5 min live

Split the 210 leavers by department, on the start base, and the group's 20.5 percent turns into a range from 7.4 to 50.0. Sales lost 54 of 108 people. R&D lost 7 of 94. Those two numbers are on the same base rule, from the same six months, and they describe different companies. The split is where a people number becomes useful, and it is also where the base gets small enough that one resignation is a point.

ONE RULE, EIGHT RATES, EIGHT BASES Apex H1 2026, constructed · start base · 7px per point RATE, START BASE THE BASE ONE LEAVER IS Sales 50.0% 54 of 108 0.9 pts Customer Service 37.6% 35 of 93 1.1 pts Operations 25.2% 55 of 218 0.5 pts Marketing 19.7% 15 of 76 1.3 pts Engineering 11.3% 24 of 213 0.5 pts HR 10.7% 8 of 75 1.3 pts Finance 8.3% 12 of 145 0.7 pts R&D 7.4% 7 of 94 1.1 pts Sales and R&D use the same rule on the same six months and describe different companies. The moss column is what a slide usually drops; the right column is 100 over the base, which is why HR moves a point per person.
🔍 Click to zoom - the bars are the rates; the moss column is what makes them comparable, and it is the column that goes missing
LiveSales 50.0, R&D 7.4, and the base printed under each3 min▶

The group rate hides the split, and the split is the finding. Apex's eight departments on the start base: Sales 50.0 percent (54 of 108), Customer Service 37.6 (35 of 93), Operations 25.2 (55 of 218), Marketing 19.7 (15 of 76), Engineering 11.3 (24 of 213), HR 10.7 (8 of 75), Finance 8.3 (12 of 145), R&D 7.4 (7 of 94). The four entities tell a flatter story: Digital 25.0, Logistics 23.5, Manufacturing 19.3, Retail 17.7, all on the start base, all constructed.

Two rules for any split. First, the base goes under every rate, as "54 of 108", not as a footnote. A rate with its base can be re-added: 54 plus 35 plus 55 and so on reaches 210, and the bases reach 1,022, so the split reconciles to the bridge from Foundations session 1. A rate without its base cannot be checked against anything. Second, the same base rule everywhere. Sales on the start base beside R&D on the average base is a comparison of two conventions, not of two departments.

Transfers matter here too: a person who moved from Sales to Marketing in March is a Sales leaver and a Marketing joiner on the department split, and neither on the group bridge. Apex has 291 rows with a transfer flag, so the rule has to be written before the split is made.

LiveHR 8 of 75: when one person is a point2 min▶

HR's rate is 10.7 percent, from 8 leavers of 75. One more resignation and it is 12.0; one fewer and it is 9.3. On a base of 75, each person is 1.3 points, which is arithmetic (100 over the base) and not a property of HR. Marketing, on 76, has the same problem. Operations, on 218, moves 0.5 of a point per person and can carry a trend; HR cannot, and a dashboard that colours HR red at 12.0 and green at 9.3 is colouring one person's decision.

The rule of thumb: read the base before the rate, and if the base is under about a hundred, read the count instead. "8 people left HR" is a sentence a manager can act on. "HR attrition is up 2.7 points" is the same fact dressed up as a trend. Small groups also make the survivor problem from Foundations session 1 worse: with 75 people, the handful who left before the snapshot would have moved the number visibly, and they are not in the table.

Self-studyEntity rates, and why they add up when department rates do not look like they should2 min▶

The four entity rates (25.0, 23.5, 19.3, 17.7) and the eight department rates both sum to 210 leavers over 1,022 starters, because they are two cuts of the same bridge. A department that spans entities, like Operations, will show one rate on the department view and be spread across four on the entity view; both are correct, and a reader who compares Operations' 25.2 with Digital's 25.0 is comparing a column with a row. The habit is to say which cut a rate comes from, in the same breath as its base. Deep-dive session 3 rebuilds both cuts from the table and shows the reconciliation as a check that runs every month.

Real world

The red cell. A department of about seventy shows attrition up four points on the quarter and goes red on the dashboard. The four points are three people, two of whom relocated with partners and one of whom retired. Nothing about the department changed. The dashboard could not know that, because it showed the rate and not the count, and the base was in a tooltip nobody opened. Constructed; the shape of the mistake is universal.

Part 3 · covers regretted attrition as a classification

Regretted is a choice, and the choice stays visible

4 min live

Not every leaver is a loss. A retirement, a dismissal for performance, somebody leaving to study: a company would not have kept them by paying more. So dashboards split attrition into "regretted" and "not regretted", and the regretted figure is the one leadership watches. At Apex, it is 137 of 210, or 65.2 percent. That number is only as honest as the line that produced it, and the line is drawn by hand.

ELEVEN REASONS, ONE LINE, ONE NUMBER Apex, 210 leavers, constructed · the line is drawn by hand and can be moved COUNTED AS REGRETTED · 137 Better Opportunity 33 Career Growth 33 Compensation 29 Management/Culture 23 Work-Life Balance 19 NOT COUNTED · 73 Relocation 19 Unknown 17 Personal/Health 15 Involuntary / Performance 10 Retirement 9 Further Study 3 137 / 210 = 65.2% Move Relocation above the line and it is 74.3. Move Compensation below and it is 51.4. Neither is wrong. Both are a different line, and the line is a decision, not a measurement. Show the eleven categories beside every regretted figure. A reader who can see the line can argue with it.
🔍 Click to zoom - the dashed line is the whole definition of "regretted"; the counts above it are the number, the counts below it are the argument
LiveFive categories in, six out: 137 of 2103 min▶

Apex records eleven exit reasons among its 210 leavers: Better Opportunity 33, Career Growth 33, Compensation 29, Management/Culture 23, Relocation 19, Work-Life Balance 19, Unknown 17, Personal/Health 15, Involuntary/Performance 10, Retirement 9, Further Study 3. All constructed. "Regretted" is a rule that sorts those eleven into two piles. The rule used here counts Better Opportunity, Career Growth, Compensation, Management/Culture and Work-Life Balance: 137 people, 65.2 percent of the 210.

Every line in that rule is arguable. Is a relocation regretted? The person would have stayed if the company had a site in the new city, so maybe. Are the 17 Unknowns regretted? Nobody asked, or nobody answered, and putting them either side moves the figure by eight points. The honest way to report a regretted rate is with the categories beside it, so that the reader can see which pile each one landed in and argue. A regretted figure reported alone, with the rule in somebody's head, is a number that cannot be disagreed with because it cannot be seen.

The same discipline applies to "voluntary", "controllable", "avoidable" and every other adjective a dashboard puts in front of "attrition". Each is a line through the categories. Show the line.

Self-studyWhy no cost figure appears next to the rate2 min▶

The sentence that usually follows a regretted rate is "and replacing each of them costs 1.5 to 2 times salary". That range circulates widely and has no measured source: it is attributed to an analyst's estimate rather than to a study that counted the costs. The professional body most often cited for it, SHRM, publishes its own range as 50 to 200 percent of salary, which is wide enough to contain almost any conclusion and is itself a range of estimates. A cost of attrition figure is not a fact about a company until that company has counted its own recruiting, onboarding and vacancy costs, and most have not.

What can be said without a cost figure is often stronger: 137 people whose reasons the company could in principle have addressed, 54 of them from one department of 108, most of them under two years' tenure. Those are counts, they reconcile, and a board can act on them without multiplying anything by an unmeasured constant.

Build-along

The Apex rate card, on paper

★ 22 min · everyone works it through

Six worksheet steps that take a rate and give it everything it needs to travel safely: its base, its period, the annualising assumption if there is one, the split with the base under each group, the regretted rule with its categories, and a benchmark on the right clock. The benchmark is real: the US quits rate, monthly, from the Bureau of Labor Statistics. Everything Apex is constructed. Work each step for your own company as we go.

THE JOLTS QUITS RATE US, monthly, seasonally adjusted, percent of employment · Jan 2016 to Dec 2025 · BLS 1.0 2.0 3.0 2016 2018 2020 2022 2024 2026 peak 3.0, November 2021 trough 1.5, April 2020 2019 mean 2.32 2025 mean 2.02 · Dec 2025: 2.0 DECEMBER 2025, BY INDUSTRY manufacturing 1.4 professional services 1.9 education and health 1.9 total nonfarm 2.0 leisure and hospitality 4.4 quits in the month, percent of jobs Monthly, not annual. Times 12 is a rough scale: 2.0 a month is about 24 a year only if nobody quits twice and the base never moves. US, all employers, voluntary quits only, sketched through the anchors. Not a target.
🔍 Click to zoom - a monthly rate that peaked at 3.0 and troughed at 1.5; multiply by twelve before holding it beside a half-year rate, and say that you did

Step 1 · The rate, with its base and period. Start from the bridge in Foundations session 1. Write the flow, the base you chose, and the two dates. Apex: 210 over the average base 941.5, 1 January to 30 June 2026.

★ Step 1 · rate, base, periodleavers: 210 (Apex, constructed) base (which one): average, 941.5 period: 1 Jan to 30 Jun 2026 rate: 22.3 percent yours: ______ over ______ (______ base), ______ to ______ = ______

Step 2 · Annualise, and write the assumption. If the period is shorter than a year and somebody will want a yearly figure, produce it with the multiplier and the assumption on the same line. Apex: 22.3 times two, 44.6, if H2 repeats H1.

★ Step 2 · annualised, with the assumption attached22.3 percent x 2 = 44.6 percent annualised (assumes H2 repeats H1) yours: ______ x ___ = ______ annualised (assumes ________________)

Step 3 · Split it, base under each. Choose one cut (department or entity), one base rule for every group, and print leavers of base beside every rate. Add a column for what one person is worth in points: 100 over the base. Apex's eight departments are in the figure above.

★ Step 3 · the split, same rule everywhereSales 50.0 54 of 108 one leaver = 0.9 pts HR 10.7 8 of 75 one leaver = 1.3 pts R&D 7.4 7 of 94 one leaver = 1.1 pts yours: ____ __ of ___ one leaver = ___ pts groups under about 100: report the count, not the trend

Step 4 · The regretted rule, with the categories. List every exit reason with its count, draw the line, and total both sides. Apex: five categories above the line, 137 of 210, 65.2 percent.

★ Step 4 · regretted, as a visible ruleabove the line: Better Opportunity 33, Career Growth 33, Compensation 29, Management/Culture 23, Work-Life Balance 19 = 137 below the line: Relocation 19, Unknown 17, Personal/Health 15, Involuntary/Performance 10, Retirement 9, Further Study 3 = 73 regretted: 137 / 210 = 65.2 percent (the line is a choice) yours: _________________________ = ___ / ___ = ____

Step 5 · The benchmark, on the right clock. The US quits rate for December 2025 is 2.0 percent of employment, per month, voluntary quits only, every employer. To hold it beside a half-year figure, scale it and say how. Then say why the two still differ: country, employer mix, and a monthly rate that can count the same seat twice.

★ Step 5 · the benchmark and its arithmeticJOLTS quits, Dec 2025: 2.0 percent per month (US, all employers, voluntary) rough annual scale: 2.0 x 12 = about 24 percent, if nobody quits twice rough half-year scale: 2.0 x 6 = about 12 percent Apex H1, average base: 22.3 percent, all leavers, one company industries, Dec 2025: manufacturing 1.4 to leisure and hospitality 4.4 not a target, not the same clock, not the same leavers

Step 6 · The sentence. One line that carries the rate, the base, the period, the annualising assumption, the regretted rule and the benchmark's scale. Long, and every word is load-bearing.

★ Step 6 · the sentence"Between 1 January and 30 June, 210 people left against an average headcount of 941, 22.3 percent for the half-year, 44.6 annualised if the second half repeats. 137 of them, 65.2 percent, left for reasons we count as regretted (five categories, listed). Sales lost 54 of 108. For scale, the US monthly quits rate was 2.0 percent in December 2025, roughly 12 percent over a half-year."

The rate card is the unit of honesty. Any attrition number that reaches a slide without its base, its period, its annualising assumption and its regretted rule beside it has had at least one decision made for the reader without telling them. The card is short. Keep it with the number.

Homework

Before Foundations session 3

30 min
  1. Find an annualised figure in a report you have access to and write the period it was built from and the assumption it makes. If neither is stated, that is the finding.
  2. Split your own attrition by one cut, same base rule everywhere, and print leavers of base beside every rate. Mark every group under about a hundred people.
  3. Write your regretted rule as a list of categories on each side of the line, with counts. If your organisation reports a regretted rate and nobody can list the categories, that is the finding.
  4. Bring the card. Foundations session 3 moves from people leaving to people arriving: the hiring funnel, where every stage is a rate with a base of its own.
Check yourself

Three questions

Clear all three and Foundations session 2 gets stamped in your passport.

1 · A slide says "attrition 44.6 percent". Apex's measured half-year rate on the average base was 22.3. What is the 44.6, and what does it assume?

Doubling is a forecast in the clothes of a measurement. It is not wrong, but it stops being honest the moment the word "annualised" and the assumption fall off the number.

2 · HR's attrition went from 9.3 to 12.0 percent between two dashboards, and the cell turned red. HR has 75 people. What happened?

100 over the base is what one person is worth in points. Under about a hundred people the rate cannot carry a trend, and the count is the honest number.

3 · Apex reports regretted attrition of 65.2 percent, 137 of 210. What must appear next to that figure for it to be usable?

The line is a decision, not a measurement. A reader who can see the categories can disagree with the line, which is what makes the number defensible. The cost multiplier in option A has no measured source and is not claimed.

Sources covered

What this session teaches, and where it came from

✓The three bases 20.5 / 22.3 / 24.4 and the annualised 44.6Computed from the constructed Apex table; 44.6 is modelled by doubling H1, which assumes H2 repeats
✓Department rates on the start base: Sales 50.0 (54 of 108) to R&D 7.4 (7 of 94); HR 8 of 75; entity rates 25.0 / 23.5 / 19.3 / 17.7Computed from the constructed table; "one leaver is X points" is 100 over the base
✓Eleven exit reason categories; regretted 137 of 210 = 65.2 percentComputed from the constructed table; regretted is shown as a choice with the categories visible
✓BLS JOLTS quits rate: peak 3.0 (November 2021), trough 1.5 (April 2020), 2019 mean 2.32, 2025 mean 2.02, December 2025 2.0; manufacturing 1.4 to leisure and hospitality 4.4Primary; December 2025 confirmed against the BLS release of 5 February 2026; monthly, not annual, and not a target
◐"Replacing an employee costs 1.5 to 2 times salary"Not claimed: no measured source; SHRM's own range is 50 to 200 percent

Every fact on this page, and its verification tier, is recorded in the course's source map.

Foundations session 2 cheat sheet · pin this

Annualised means assumed44.6 is 22.3 doubled. Say "annualised" and say "if H2 repeats H1", every time.
Base under every rate"54 of 108", not a tooltip. Same base rule for every group in a split.
One person is 100 over the baseHR at 75: 1.3 points per leaver. Under about 100 people, report the count.
Regretted is a line137 of 210 = 65.2 under one rule. Show the eleven categories so the line can be argued.
JOLTS is monthly2.0 a month in December 2025; times 12 is a rough 24, if nobody quits twice. Not a target.
No cost multiplier"1.5 to 2x salary" has no measured source. Count your own costs or say nothing.