Workforce salary compression comparison calculator

Calculate entry-group median salary by role and tenured-group median salary by role with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use entry-group median salary by role and tenured-group median salary by role to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Comparable pay records: employee ID, role, supplied group entry/tenured, salary $
E1,A,entry,90 E2,A,entry,100 E3,A,tenured,100 E4,A,tenured,110 E5,B,entry,80 E6,B,tenured,70
Entry-group median salary by role ($)
A: 95; B: 80
Tenured-group median salary by role ($)
A: 105; B: 70
Tenured median minus entry median by role ($)
A: 10; B: -10
Entry/tenured median ratio by role (%)
A: 90.4761904762; B: 114.285714286
Roles with entry median above tenured median
B

Try another scenario

Comparable pay records: employee ID, role, supplied group entry/tenured, salary $
E1,A,entry,90 E2,A,entry,100 E3,A,tenured,100 E4,A,tenured,110 E5,B,entry,80 E6,B,tenured,90
Entry-group median salary by role ($)
A: 95; B: 80
Tenured-group median salary by role ($)
A: 105; B: 90
Tenured median minus entry median by role ($)
A: 10; B: 10
Entry/tenured median ratio by role (%)
A: 90.4761904762; B: 88.8888888889
Roles with entry median above tenured median
None
Calculation method

Calculation method

Entry-group median salary by role ($)

Median supplied entry salaries within each role.

Tenured-group median salary by role ($)

Median supplied tenured salaries within each role.

Tenured median minus entry median by role ($)

Difference between the two observed role medians.

Entry/tenured median ratio by role (%)

Entry median/tenured median×100, undefined for a zero tenured median.

Roles with entry median above tenured median

List strictly positive entry-minus-tenured median differences.

Symbols and units
a
Comparable pay records: employee ID, role, supplied group entry/tenured, salary $

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • Descriptive supplied-group medians; tenure groups, role equivalence, currency and hours basis must already be consistent. A median gap does not establish discrimination, productivity or an appropriate salary adjustment.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

ILO: supplied workforce records and full-time-equivalent measurement background ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.