Check salaries for unexplained pay gaps
Analyzes pay data within comparable roles to find gaps not explained by legitimate factors and suggests next steps.
The prompt
Help me run a pay equity check on our salary data.
Data: [PASTE or describe columns - job title, job level/grade, job family, location, base pay, hire date, time in role, performance rating, and gender / race-ethnicity or other groups where lawfully collected]
Pay ranges by level (if any): [RANGES]
Groups to compare: [e.g. men vs. women, by ethnicity]
Population size: [NUMBER]
Do this:
1. Group comparable roles - same job family, level, and location. Tell me where groups are too small to compare (under 5).
2. Raw gap by group overall and within each comparable group.
3. Adjusted view - explain how much of the gap legitimate factors (level, tenure, location, performance) appear to account for. If the data supports it, outline a regression approach and the code (Python or Excel steps) to run it; do not fabricate results.
4. Individual outliers - people paid below range or notably below peers with similar factors, regardless of group.
5. Root-cause questions - starting salaries, promotion timing, negotiation, inconsistent off-cycle raises.
6. Remediation options with an estimated cost formula and prioritization.
Output: summary for leadership, a findings table, and a list of outliers to review. Treat results as a starting point; confirm methodology and any legal privilege considerations with counsel, and follow local pay equity and data protection rules.
Highlighted [brackets] are blanks to replace with your own details.
Fill in the blanks and use this promptMore Data & Analysis prompts
What to fill in
- RANGES
- e.g. men vs. women, by ethnicity
- NUMBER
How this prompt is built
This prompt follows the RTF structure (Role, Task, Format). RTF tells the model who to be, what to do and what shape the answer should take. It is the quickest structure that still gives noticeably better results than a bare request.
Related prompts
- Turn my monthly or quarterly numbers into an executive business reviewTurns your numbers into an executive business review: headline, performance vs. plan, drivers, risks, and decisions needed, as a report or slides.
- Compare performance against targets and find the biggest gapsCompares actuals against targets for every KPI, sizes each gap, and ranks the gaps that matter most so you know where to focus.
- Check whether my KPIs measure activity or real value, and fix themSorts your KPIs into activity, output, and outcome measures, flags vanity metrics, and redesigns the set around the outcomes that matter.
- Challenge my interpretation of the data and find other explanationsStress-tests your conclusions for alternative explanations, cherry-picking, and averaging traps, then gives you a defensible version.