-
Excel workbook preview
Equality, Diversity and Inclusion
Promotion and Progression Equity Analysis
3 downloads per free account, no card needed.
Who this is for
An HR analyst or reward lead uses this after a promotion cycle, when leadership or an employee group asks whether promotions were fair across groups.
What is inside
- 11 sample group rows for one cycle (sex, ethnicity, disability, age, work pattern) plus 20 blank
- Promotion rate, rate for the whole dimension and expected promotions, all live
- Difference and standard deviations (binomial approximation) for each group
- Adverse impact ratio against the highest group, red below 0.80 (29 CFR 1607.4(D))
- Reading column: Investigate, Review, OK or Too few to read, from thresholds you set
- Pipeline sheet: representation by level with an index to entry level, red below 0.80
How to use it: Enter eligible and promoted counts per group for each cycle; read the flags, then review the process behind any red row.
Files & formats
- XLSXpromotion-and-progression-equity-analysis-template.xlsx14 KB
Opens in Microsoft Word or Excel, Google Docs or Sheets and LibreOffice. Delivered instantly from your browser.
Free downloads & full access
Every account gets 3 free downloads. Re-downloading a template you already have does not count. This template on its own is $17.99, and buying it keeps your free downloads for something else. Full access is a one-time $249 for all 300 templates, for life.
Bought with a different email? Open your account and enter your order number.
Licence
Use and adapt the document inside your own organisation or for your own clients. Do not resell or republish the templates themselves. These templates are original working documents built on the public law or guidance named here. They are not legal advice and are not endorsed by the government body or publisher.



