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

Pay, gaps and fairness

"Women at this company are paid 8 percent less than men" is a sentence that means two different things, and the headline never says which. It can mean that a woman and a man doing the same job are paid differently, which is unequal pay and unlawful. Or it can mean that the average hourly pay of all the women is 8 percent below the average for all the men, which is a pay gap, and which a company with perfectly equal pay in every role can still report, because of who holds which roles. Tonight is the second meaning, on real data: the six figures every large UK employer must publish, the four pay bands, 11,315 filings for 2024, and the two mechanisms, composition and within-band pay, that any gap is made of. Then a lever that most people pull in the wrong direction.

🟢 Foundations Leaders, HR partners, anyone who has to explain a pay gap figure No code 45 min
0-3 · Welcome 3-18 · The filing, the pyramid, two mechanisms 18-40 · Build-along: reading one filing's six numbers 40-45 · Q&A
Part 0

Where we start

Pay is the one people number where the data is public. Since 2017, every UK employer with 250 or more employees has had to publish six figures a year under the Equality Act 2010 (Gender Pay Gap Information) Regulations 2017, and the government publishes the whole set as an open file. For reporting year 2024 that is 11,315 filings, and they are the running data for tonight and for the deep-dive track's pay sessions. No employer is named on any page, no filing is called good or bad, and nothing on the page says why any gap exists. What the filings can show, precisely, is how much of a gap the shape of a workforce produces on its own. That turns out to be most of it, and it is not the part most pay gap plans address.

🎫 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 difference between a pay gap and unequal pay, said in one sentence; the six figures and what each one's base is; the pyramid, and why 81.3 percent of employers have one; composition against within-band pay as the two mechanisms behind any gap; and the reason "hire more women" is not a lever until you say where.

Part 1 · covers the filing, the six figures and the pyramid

A pay gap is not unequal pay

6 min live

Equal pay is a legal duty: the same pay for the same work, or work of equal value, between a man and a woman at the same employer. A pay gap is a statistic: the difference between the average hourly pay of all men and all women at that employer, whatever jobs they do. An employer can meet the first completely and still report a large second, if its best-paid roles are mostly held by men. The filing is built to show that, and its most telling part is not the headline gap but the four bands underneath it.

FOUR EQUAL BANDS, AND WHO IS IN EACH the median employer across 11,315 filings for 2024 · each band is a quarter of the staff, by hourly pay top quartile best paid quarter upper middle lower middle bottom quartile lowest paid quarter 40.0% women 60.0% men 47.0% women 53.0% men 52.7% women 47.3% men 56.0% women 44.0% men HIGHER PAY LOWER PAY THE PYRAMID 81.3 percent of employers have more women at the bottom than at the top median employer, 2024 filings, UK, 250+ employees Equal pay inside every band would still leave a gap here, because the wine share shrinks as the ladder rises. That is a pay gap made of composition, and it is the shape 81.3 percent of filings have.
🔍 Click to zoom - the wine share narrows as the ladder rises; the gap that shape produces exists before anyone is paid unequally
LiveThe six figures, and what each one's base is4 min▶

The Equality Act 2010 (Gender Pay Gap Information) Regulations 2017, SI 2017/172, require every employer with 250 or more employees to publish six figures each year, on a snapshot date of 5 April for private employers, within twelve months. All six are about hourly pay or bonus, and all six are averages across all men and all women, whatever their jobs.

1 and 2: the mean and the median hourly pay gap, as a percent of men's pay. The median is the one to read first: it is the middle woman against the middle man, and it is not pulled by a handful of very high earners the way the mean is. 3 and 4: the mean and the median bonus gap, on the same logic, over the year before the snapshot; 75.8 percent of 2024 filings report a median bonus gap, the rest pay no bonus to one sex or either. 5: the share of each sex who received a bonus. 6: the share of each sex in four equal-sized hourly pay quartiles, which is the pyramid in the figure, and the one figure that shows where a gap comes from rather than how big it is.

Every one of the six is a statistic about averages across roles. None of them compares a woman and a man in the same job. That comparison is equal pay, it is a legal duty, and a filing cannot show whether it is met. What the filing can show is how the workforce is shaped, and that turns out to be most of the story.

LiveWhat 11,315 filings show: 8.4, 77.6 and the pyramid2 min▶

For reporting year 2024, 11,315 employers filed; 11,312 of the filings are complete and in range, and 11,301 have at least one man and one woman across the four bands, which is what it takes for a gap to be decomposable. Across them, the median hourly gap has a median of 8.4 percent (2023: 8.9). 77.6 percent of employers report a positive median gap, men paid more; 8.5 percent report exactly zero. The mean gap's median is 11.0.

The pyramid at the median employer runs 56.0 percent women in the bottom band, 52.7 in the lower middle, 47.0 in the upper middle, 40.0 in the top, and 81.3 percent of employers have a higher share of women at the bottom than at the top. That single fact is the reason the median gap is positive at most employers: it does not require any woman to be paid less than a man in the same band. It requires the bands to be paid differently, which is what bands are, and the sexes to be unevenly spread across them, which they are at four filings in five.

Real world

The headline and the correction. A pay gap figure is published, a news story calls it "paying women less", and the employer's reply says pay is equal for equal work. Both can be true. The headline reads a gap as unequal pay; the reply answers the equal pay question the filing cannot address. The pyramid is the sentence that ends the argument: "our gap is X, and here is the share of women in each of our four pay bands". Constructed exchange; the confusion is in most coverage of every filing year.

Part 2 · covers composition and within-band pay

Two mechanisms make any gap

5 min live

Any pay gap is the sum of two things. Composition: women and men are spread differently across pay bands, and the bands pay differently, so the averages differ even with equal pay in every band. Within-band pay: inside a band, women and men are paid differently. The filing shows the first mechanism directly, through the four bands. It cannot see the second at all. Most of what a company can honestly say about its gap follows from keeping those two apart.

COMPOSITION PLUS WITHIN-BAND PAY the filing shows the left panel and cannot see the right one · 11,301 usable filings, 2024 COMPOSITION the pyramid times the ladder top bottom 2.80 1.45 1.20 1.00 fitted pay ladder, all employers equal pay in every band still gives 9.8 (median) + WITHIN A BAND what the filing cannot see PAY a man, same band a woman, same band, paid less the residual: reported minus composition, 2.3 (median) The three numbers are medians over 11,301 employers and do not add; the reported mean gap's median is 11.0. 33.8 percent of employers report a gap below their composition-only gap: their within-band pay runs the other way.
🔍 Click to zoom - the left panel is the part a company can read off its own filing; the right panel is the part it has to go and measure
LiveComposition: the pyramid times the ladder3 min▶

Take the median employer's pyramid, 56.0 / 52.7 / 47.0 / 40.0, and suppose every band pays the same to everyone in it. The women's average is still lower than the men's, because more of the women are in the lower-paid bands. How much lower depends on how steeply pay rises up the bands. Nobody publishes band pay, so the deep-dive track fits a ladder across all usable employers from the gaps they reported: 1 / 1.20 / 1.45 / 2.80, meaning the top band pays about 2.8 times the bottom at a typical filer. Under that ladder, composition alone explains about a third of the variation in reported mean gaps across employers (R2 0.353), and the composition-only gap has a median of 9.8 percent against a reported mean-gap median of 11.0.

The plain reading: at a typical UK filer, most of the reported gap is the pyramid. That is not a defence and it is not an accusation. It says where the gap is: in who holds which band, not in what the band pays. It also says where a plan has to act if it wants the number to move, which is Part 3.

LiveWithin a band: what the filing cannot see2 min▶

Subtract the composition-only gap from the reported gap and what is left is the residual: pay differences inside bands, plus whatever the fitted ladder gets wrong for that employer. Its median is 2.3 points, with a wide spread, and 33.8 percent of employers report a gap below their composition-only gap, which means within-band pay at those employers runs in women's favour, or their own ladder is flatter than the fitted one. The filing cannot tell those apart. It knows nothing about pay within a band, nothing about hours, occupation, tenure or part-time status, and nothing causal.

Measuring within-band pay properly needs the salary table and a regression: pay on grade, tenure and sex, with the method that splits a gap into "explained by measured differences" and "not explained", named Oaxaca-Blinder after the two 1973 papers. Deep-dive session 6 does it on constructed Apex salaries, with the warning that "explained" is not the same as "justified".

Real world

The plan that fixed the wrong mechanism. An employer with a reported gap near the median commissions an equal pay audit, finds pay within grades close to equal, and announces the gap is "explained". Explained by what? By the pyramid: the audit checked the right panel and found little, and the left panel, where most of the gap sits, was never in scope. The gap will be the same next year, and the audit will be quoted again. Constructed employer; the scope error is common.

Part 3 · covers the anti-lever and the national figure

"Hire more women" is not a lever until you say where

3 min live

If the gap is mostly the pyramid, the way to move it is to change the pyramid. The obvious plan is to hire more women. Take the median employer's profile, keep the fitted ladder and equal pay within every band, and add women equal to 10 percent of headcount. Put them in the bottom band and the composition-only gap goes from 9.57 to 14.88 percent. Put them in the top band and it goes to -3.18. Same plan, same headcount, opposite signs. The lever is not "more women"; it is "more women where".

THE SAME LEVER, PULLED IN TWO PLACES median employer's profile, 2024 · add women = 10 percent of headcount · modelled top band bottom band now: 9.57 INTO THE BOTTOM BAND the new women join the lowest-paid quarter 9.57 to 14.88 wider by 5.3 points more women, and a bigger gap to explain at the next filing INTO THE TOP BAND the new women join the best-paid quarter 9.57 to -3.18 the sign flips same headcount, same ladder, same equal pay within bands Modelled on the median profile under the fitted ladder with equal pay within every band; nothing else moves. The deep-dive bench lets you pull both arrows on 3,000 real employers, including yours if it filed.
🔍 Click to zoom - the wine card is the plan most companies run; the moss card is the same headcount in a different band, and the gap changes sign
LiveWhere the lever is2 min▶

A gap made of composition moves when the composition moves, and composition is who is in which band. Adding people to the bottom band adds to the pyramid; adding them to the top band subtracts from it. A hiring plan that brings in women mostly at entry level, which is where most hiring happens, makes the reported gap wider at the next filing while the company is doing what it said it would. The plan is not wrong. The metric is measuring composition, and composition just got more pyramid-shaped.

The honest sentence for a plan is therefore about bands, not headcount: "we intend to change the share of women in the top band from 40.0 to X", with the date. Promotion into the band and hiring into the band both count; hiring into the bottom band counts the other way.

Self-studyThe anti-lever, modelled: 9.57 to 14.88, or to -3.182 min▶

The arithmetic is modelled, and every assumption is on the figure: the median employer's band profile from the 2024 filings, the fitted ladder 1 / 1.20 / 1.45 / 2.80, equal pay within every band, and women added equal to 10 percent of headcount with nothing else changing. Under those assumptions the composition-only gap starts at 9.57 percent. Put the added women in the bottom band and it becomes 14.88. Put them in the top band and it becomes -3.18, a gap in women's favour.

None of that is a forecast for any real employer, whose ladder is steeper or flatter than the fit and whose within-band pay is unknown. It is a demonstration that the sign of the effect depends on the band, which is true under any ladder that rises. Deep-dive session 10 runs the same two arrows on a 3,000-employer sample of the real filings, live, where the numbers come out as 9.79, 15.07 and -2.92 on the sample's own profile.

Self-studyThe national figure, 7.0 and 13.1, and why it is a different animal2 min▶

The Office for National Statistics publishes the UK gender pay gap from the Annual Survey of Hours and Earnings: for April 2024, 7.0 percent for full-time employees and 13.1 percent for all employees (2023: 7.5 and 14.2). It is tempting to hold 8.4 beside 7.0 and conclude that the median filer is slightly worse than the country. The two numbers are not comparable. The ONS figure is the median hourly earnings of all women in the economy against all men, one calculation across everyone. The 8.4 is the median of 11,315 employer-level medians, each computed inside one workforce. An economy where every employer had a zero gap could still have a national gap, if women worked at lower-paying employers; and the reverse. The two numbers answer different questions and both are worth knowing. Write which one a slide is quoting.

Self-studyGoldin on hours: what is left when composition is accounted for2 min▶

Goldin 2014, "A Grand Gender Convergence: Its Last Chapter", American Economic Review 104(4) 1091-1119, argues that most of the historical gap has closed and that the remaining gap is driven by occupations that reward long and particular hours disproportionately: jobs where being available at specific times, and for many of them, is paid at a premium rather than pro rata. That is a statement about the structure of pay across occupations, not about any employer's filing, and it is one explanation for why the top band of the pyramid looks the way it does at so many employers. The filing cannot see hours or occupation, so it cannot test this; a company that wants to know whether its own top band is shaped by hours has to go and look.

Build-along

Reading one filing's six numbers, on paper

★ 22 min · everyone works it through

Six worksheet steps that take a published filing and turn it into three sentences: what the gap is, what the pyramid looks like, and which band a plan would have to change. The worked example is the median employer, a composite built from the 2024 filings, not a real firm; for the bonus figures no composite is claimed, so those boxes stay blank until you fill them from a filing of your own. Any employer's filing from the gov.uk service works for the exercise, and no page here names one.

THE FILING, SIX BOXES the median employer, a composite of 11,315 filings for 2024, not a real firm · snapshot 5 April GENDER PAY GAP REPORT · reporting year 2024 boxes 3, 4 and 5: no composite claimed, fill from a filing of your own 1 · mean hourly pay gap 11.0% median across employers · 85.9% positive 2 · median hourly pay gap 8.4% 77.6% of employers positive · 8.5% zero 3 · mean bonus gap ____ % 75.8% of employers report a bonus gap 4 · median bonus gap ____ % year before the snapshot 5 · share receiving a bonus W ____ % M ____ % one share per sex 6 · women's share by quartile 56.0 / 52.7 / 47.0 / 40.0 bottom to top · read this box first Boxes 1 and 2 say how big. Box 6 says where. A filing read from box 6 upward is a filing read correctly. Every value here is a median across employers; a real filing has one employer's six numbers and nothing else.
🔍 Click to zoom - the moss box is the one that shows where the gap comes from; the two on the left only say how big it is

Step 1 · Write the two hourly gaps, with their bases. Both are percents of men's hourly pay on the snapshot date. Read the median first. Composite: 11.0 and 8.4.

★ Step 1 · boxes 1 and 2mean hourly gap: 11.0 percent (median employer, composite, 2024) median hourly gap: 8.4 percent (77.6 percent of employers positive, 8.5 percent zero) yours: ____ and ____ snapshot date: 5 April ____

Step 2 · Write the three bonus figures, if there are any. Mean bonus gap, median bonus gap, and the share of each sex receiving one. 75.8 percent of 2024 filings report a median bonus gap; if yours does not, write why (no bonus to one sex, or to either).

★ Step 2 · boxes 3, 4 and 5mean bonus gap: ____ percent median bonus gap: ____ percent share with a bonus: women ____ percent men ____ percent if blank, because: __________________________________________

Step 3 · Draw the pyramid. Women's share in each of the four quartiles, bottom to top. Then one comparison: bottom against top. Composite: 56.0 / 52.7 / 47.0 / 40.0; bottom over top at 81.3 percent of employers.

★ Step 3 · box 6, the pyramidbottom quartile: 56.0 percent women (composite) lower middle: 52.7 upper middle: 47.0 top quartile: 40.0 yours: ____ ____ ____ ____ bottom higher than top? yes / no

Step 4 · Name the mechanism the filing can see. If the bottom share is higher than the top share, composition is producing a gap on its own. Write that sentence. Then write the one the filing cannot answer: whether pay within a band is equal.

★ Step 4 · composition, and the question left openthe filing shows: more women in lower bands than higher ones, so the bands' pay differences alone produce a gap (composite: composition-only median 9.8) the filing cannot: say whether a woman and a man in the same band are paid the same that needs: the salary table and a within-band comparison (deep-dive session 6)

Step 5 · Which band would a plan change. Take the plan the company actually has, and write which band most of the people it adds will land in. Then write the direction that moves a composition gap.

★ Step 5 · the lever, and where it pointsthe plan: _____________________________________________ most people land in: bottom / lower middle / upper middle / top that moves the gap: wider (bottom) / narrower (top) composite, modelled: +10 percent headcount of women at the bottom, 9.57 to 14.88; at the top, 9.57 to -3.18

Step 6 · The three sentences. How big, where from, and what would move it. Each sentence names its base; the third names a band and a date. No sentence says why.

★ Step 6 · three sentences"Our median hourly gap is 8.4 percent, at the 5 April 2024 snapshot (men paid more). Women are 56.0 percent of our bottom pay quartile and 40.0 percent of our top one, so the shape of the workforce produces a gap before pay within any band is considered. To move the reported figure we would change the share of women in the top quartile, from 40.0 to ____ by ____; hiring into the bottom quartile moves it the other way."

Read box 6 first. The two hourly gaps say how big; the four quartiles say where. A pay gap statement that quotes the headline and skips the pyramid has reported the size of something without saying what it is made of, and the plan that follows will pull the lever in whichever direction is easiest to hire.

Homework

Before Foundations session 5

30 min
  1. Read one real filing from the gov.uk gender pay gap service, an employer you know if it has 250 or more staff, and fill the six boxes. Write the pyramid and whether the bottom share is above the top.
  2. Write the two sentences that filing supports, how big and where from, and the one question it cannot answer.
  3. Find the plan. If the employer publishes a narrative beside its numbers, write which band its stated actions would change, and which direction that moves a composition gap.
  4. Bring the filing. Foundations session 5 turns to the other number leadership loves, the engagement score, and asks the base question in its survey form: who answered, and who did not.
Check yourself

Three questions

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

1 · An employer reports a median hourly pay gap of 8.4 percent. A news story says it "pays women 8.4 percent less for the same work". What is wrong with the story?

A gap is a statistic about averages across roles; equal pay is about the same role. The four quartiles are what show whether the gap is coming from the shape of the workforce, and 81.3 percent of filers have a pyramid that produces one.

2 · The median employer's women's share by quartile is 56.0 / 52.7 / 47.0 / 40.0, bottom to top. Suppose every band paid everyone in it identically. Would the employer report a gap?

The pyramid times the ladder is a gap on its own. The residual, what is left after composition, has a median of 2.3 points, and 33.8 percent of employers report a gap below their composition-only figure.

3 · A plan adds women equal to 10 percent of headcount, mostly at entry level. On the median profile under the fitted ladder, what happens to the composition-only gap, and what should the plan say instead?

Modelled, with every assumption stated: same ladder, equal pay within bands, nothing else moves. The sign depends on the band. "Hire more women" is not a lever; "hire more women where" is.

Sources covered

What this session teaches, and where it came from

✓Equality Act 2010 (Gender Pay Gap Information) Regulations 2017, SI 2017/172: 250 or more employees, six measures, four equal quartiles, 5 April snapshot, publish within 12 monthsPrimary; the SI was read
✓gov.uk gender pay gap service CSV for 2024, Open Government Licence v3.0: 11,315 filings, 11,312 complete, 11,301 usable; median gap 8.4 (2023: 8.9), mean gap median 11.0; 77.6 percent positive, 8.5 percent zero; 75.8 percent report a bonus gap; pyramid 56.0 / 52.7 / 47.0 / 40.0; 81.3 percent bottom over topComputed from the filings for these pages
✓Fitted ladder 1 / 1.20 / 1.45 / 2.80, R2 0.353; composition-only median 9.8; residual median 2.3; 33.8 percent below composition; anti-lever 9.57 to 14.88 (bottom) and -3.18 (top)Computed, then modelled under stated assumptions: equal pay within a band, women equal to 10 percent of headcount, nothing else moved
✓ONS ASHE April 2024: 7.0 percent full-time, 13.1 percent all employees (2023: 7.5 and 14.2)Primary; whole-economy medians, not comparable with per-employer medians, and the page says so
✓Goldin 2014, "A Grand Gender Convergence: Its Last Chapter", American Economic Review 104(4) 1091-1119Primary; the remaining gap is driven by occupations that reward long and particular hours
◐Oaxaca-Blinder decomposition, named as the regression version of composition against within-band payNamed here; taught on constructed salaries in deep-dive session 6
◐Why any employer's gap existsNot claimed; the filing carries nothing on hours, occupation, tenure, part-time status or within-band pay, and nothing causal

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

Foundations session 4 cheat sheet · pin this

Gap is not equal payA gap averages across roles. Equal pay is the same role. A filing shows the first and cannot test the second.
Six figures, four bandsMean and median hourly gap, mean and median bonus gap, bonus share by sex, and women's share in four equal pay quartiles.
2024 filings11,315 filed. Median gap 8.4. 77.6 percent positive, 8.5 percent zero. Pyramid 56.0 / 52.7 / 47.0 / 40.0 at the median.
Two mechanismsComposition (the pyramid times the ladder, median 9.8) plus within-band pay (residual median 2.3). Read box 6 first.
The anti-leverAdd 10 percent headcount of women at the bottom: 9.57 to 14.88. At the top: -3.18. Modelled. Name the band.
Not the national figureONS 7.0 full-time, 13.1 all employees (April 2024) is one economy-wide median; 8.4 is the median of employer medians.