Box Plot for Salary Benchmarking — Comp Band P25, Median & P75 Plotter
A salary benchmarking box plot charts market pay percentiles ($P_{25}, P_{50}, P_{75}$) across job levels so HR and compensation teams can align band midpoints and interquartile spreads.
Tip: Paste Excel or Google Sheets rows (Ctrl+V / ⌘V) directly into any cell.
| # | Label | ||||
|---|---|---|---|---|---|
| 1 | |||||
| 2 | |||||
| 3 | |||||
| 4 | |||||
| 5 | |||||
| 6 |
Compa-ratio vs midpoint: CompaRatio = Salary / P50. Range penetration: Penetration = (Salary - P25) / (P75 - P25). Interquartile Band Spread = P75 - P25.
Chart Design & Use-Case Tips
- 01Compa-ratio vs midpoint: CompaRatio = Salary / P50. Range penetration: Penetration = (Salary - P25) / (P75 - P25). Interquartile Band Spread = P75 - P25.
- 02Enter P50 (Median) in Column 1, P25 in Column 2, and P75 in Column 3 from Radford, Carta, Pave, or Levels.fyi compensation datasets.
- 03Moderate overlap between the P75 of Level N and the P25 of Level N+1 allows room for high-performing tenure growth before promotion.
- 04Check the growing box height (IQR) at senior levels to verify that performance-based band width scales appropriately.
Frequently Asked Questions
Why do compensation analysts use P25, P50, and P75 instead of averages?+
Executive and senior equity/cash outliers skew arithmetic averages upward; percentile quartiles (P25, P50, P75) provide outlier-resistant market anchors.
How do I read band overlap between adjacent job levels?+
If the upper whisker/box of L4 slightly overlaps the lower box of L5, experienced L4 engineers can be rewarded near the top of their band without forcing premature title inflation.
Can I plot total compensation (Base + Bonus + Equity) here?+
Yes, simply enter Total Direct Compensation ($K) figures for P50, P25, and P75 in the three numeric columns.