• Preview of Promotion and Progression Equity AnalysisExcel workbook preview

Equality, Diversity and Inclusion

Promotion and Progression Equity Analysis

$17.99 Free XLSX
Excel workbook · 14 KB

3 downloads per free account, no card needed.

Need more than 3? Get all 300 templates for $249 One payment, lifetime access, including every template added later.

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.