The film is unavailable. You can read what it shows below.
Salary benchmarking worksheet
See what your evidence can support, and when it cannot.
Try the worksheetWhat the film shows, in words
- See what your evidence can support, and when it cannot.
- Four sources for one role.
- One is older than 18 months. One has a sample below 5. Left out.
- Weighted by sample and match: USD 11,300. Range USD 8,900 to USD 13,900.
- Ask for 20 from every source: one source left. Range suppressed.
- A number only when the evidence can carry it.
The demo: the worked example, one input changed at a time
ExampleInvented figures for an illustrative role. They are not salary data.
Example role: finance officer, Example city. Evidence older than 18 months is ignored; at least 5 in each source.
Weighted figure of the sources that count
USD11,300
Range suppressed
Indicative range USD 8,900 to USD 13,900 · 2 of 4 sources · 60 observations(11,500 × 42 + 10,500 × 12.6) ÷ 54.6 = 11,269, shown as USD 11,300
Step 1 of 4
Four sources. Two are strong enough to use.
Left out: peer organisation (older than 18 months); recruiter estimate (sample below 5). Each stays on the scale as a hairline.
- Weight 42 (42 × 1)9,00011,50014,000
Sample 42 · exact match · weight 42
- Weight 12.6 (18 × 0.7)8,50010,50013,500
Sample 18 · close match · weight 12.6
- Left out: older than 18 months8,0009,80012,000
Left out: older than 18 months
- Left out: sample below 510,00013,00016,000
Left out: sample below 5
Counted: the thicker, the more weight Left out A source’s own median The weighted figure The indicative range Annual, gross
Now your own evidence, on one scale.
One row per source. The example values are invented to show how it works. Two rules decide which sources count: set them first.
Weighted summaries of your sources, not a representative market survey. Coverage depends entirely on the sources you add.
The range is suppressed unless at least two usable sources and 20 observations remain. Figures are rounded to the nearest 100 in every currency. These are this worksheet’s own rules, not a statistical standard. In a figure’s field the arrow keys move it by 100; on a touch screen, use its plus and minus buttons.
The evidence log
Every source as the worksheet reads it, and what it says about the evidence as a whole.
- Survey A (example) (excluded)9,000 to 14,000
- Job advert sample (example) (excluded)8,500 to 13,500
- Peer organisation (example) (excluded)8,000 to 12,000
- Recruiter estimate (example) (excluded)10,000 to 16,000
Line: base case, 11,269.
| Source | Dated | Match | Sample | Median | Used |
|---|---|---|---|---|---|
| Survey A (example) | 1 Mar 2026 | Exact match | 42 | USD 11,500 | Yes |
| Job advert sample (example) | 15 Jun 2026 | Close match | 18 | USD 10,500 | Yes |
| Peer organisation (example) | 30 Nov 2023 | Exact match | 6 | USD 9,800 | No |
| Recruiter estimate (example) | 10 May 2026 | Broad match | 3 | USD 13,000 | No |
Evidence quality
- Check: Peer organisation (example) excluded: older than 18 months.
- Check: Recruiter estimate (example) excluded: sample below 5.
- Note: Weighted summaries of your sources, not a representative market survey.Coverage depends entirely on the sources you add.
What the summary carries
It summarises the evidence you enter; it is not a market survey.
- Survey A (example)
- Job advert sample (example)
- Peer organisation (example)
- Recruiter estimate (example)
- Weighted figure
- USD 11,300
- Indicative range
- USD 8,900 to USD 13,900
- Sources · observations
- 2 of 4 · 60
Your full report
Salary-evidence summary, by email once delivery is connected.
Salary-evidence summary (PDF) with dates, sample sizes and coverage limits
Tool: Salary-evidence explorer Role: Example role: finance officer; location: Example city Result: Weighted figure USD 11,300 · 2 sources Request: please scope pay and grading work (SVC-021).Send as a brief
How a source counts, and what this cannot tell you.
- 01
Sources are excluded when undated, older than your threshold, below the minimum sample or missing a median.
- 02
Each usable source is weighted by its sample size × role match (exact 1, close 0.7, broad 0.4).
Survey A: sample 42 × 1 (exact match) = weight 42
Job advert sample: sample 18 × 0.7 (close match) = weight 12.6
From the worked example: invented figures. - 03
The range is suppressed unless at least two usable sources and 20 observations remain.
What it cannot tell you
- It summarises the evidence you enter; it is not a market survey.
- Mixed currencies, allowances and benefits must be normalised before entry.
- Pay decisions need job evaluation and policy, not a single number.
Read the result as this
The weighted figure is a weighted average of your sources’ medians. The indicative range is a weighted average of their lows and highs. Neither is a percentile, and neither describes a market.
Quality ruleSuppress unsupported ranges; no representative claim without method.
When the decision needs more than the evidence you hold.
Pay decisions need job evaluation and policy, not a single number.
-
Prof. Wisdom GagakumaTool owner · Practice 02Book the Professor · from USD 150