Articles

How do you calculate Cohen's kappa for two analysts' ratings?

Measuring whether two due diligence analysts rate managers the same way, with the chance correction that raw agreement leaves out.

Cohen's kappa measures how far two reviewers agree beyond what chance would produce: κ = (po − pe) ÷ (1 − pe), where po is the share of items they rate the same and pe the share they would match on by chance given their own rating habits. Two operational due diligence analysts who agree on 82.5 per cent of 40 domain ratings, against 45.9 per cent expected by chance, have a kappa of 0.68: substantial, but not the near-certainty the raw figure suggests.

Worked in full in Operational Due Diligence in Private Equity by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →

An ODD programme that relies on one analyst's rating is relying on that analyst's calibration. The usual defence is a second reviewer. Whether the second reviewer adds anything depends on a number most programmes never compute: how often two analysts, looking at the same evidence, reach the same rating. Raw agreement overstates it, because if most domains are rated satisfactory, two analysts will agree most of the time without trying. Kappa removes that.

The assumptions

Two analysts independently rate the same five managers on eight domains each, 40 ratings in all, on a three-point scale. Rows are the first analyst, columns the second.

Illustrative ratings, analyst 1 (rows) against analyst 2 (columns)
Analyst 1 \ Analyst 2SatisfactoryWatchConcernTotal
Satisfactory223025
Watch27110
Concern0145
Total2411540

The calculation, step by step

Step 1: observed agreement. The diagonal.

po = (22 + 7 + 4) ÷ 40 = 33 ÷ 40 = 82.5%

Step 2: agreement expected by chance. If each analyst kept their own mix of ratings but assigned them at random, the chance that both say Satisfactory is 25/40 × 24/40, and so on for each category.

pe = (25 × 24 + 10 × 11 + 5 × 5) ÷ 40² = (600 + 110 + 25) ÷ 1,600 = 735 ÷ 1,600 = 45.9%

Step 3: kappa.

κ = (0.825 − 0.4594) ÷ (1 − 0.4594) = 0.68

Excel, with the 3 × 3 table in B2:D4: po =(B2+C3+D4)/SUM(B2:D4); pe =SUMPRODUCT(MMULT(B2:D4,{1;1;1}),TRANSPOSE(MMULT({1,1,1},B2:D4)))/SUM(B2:D4)^2

On the bands most often quoted, from Landis and Koch, 0.61 to 0.80 is substantial agreement and 0.81 to 1.00 almost perfect. To reach 0.80 with the same rating mix, the pair would have to agree on 89.2 per cent of ratings: 36 of 40 instead of 33.

The result

The two analysts agree well beyond chance, and the disagreements are all one notch apart: no domain is Satisfactory for one and Concern for the other. But kappa over the whole scale is not the number an investment committee cares most about. The decision that matters is whether a domain is a Concern, because that is where a veto applies. Collapsing the table to Concern against everything else, the analysts agree on 4 Concerns, each flags 1 that the other does not, and they agree on 34 non-Concerns: 95.0 per cent observed, 78.1 per cent by chance, a kappa of 0.77. Of the 6 domains either analyst flagged as a Concern, 2 were flagged by one analyst only. With a single reviewer, one of those would have gone unnoticed.

What if: most ratings are satisfactory

Two programmes compared
MeasureBase programmeSkewed programme
Ratings agreed, of 403336
Observed agreement82.5%90.0%
Chance agreement45.9%81.6%
Kappa0.680.46
Linear weighted kappa0.750.56

In the skewed programme both analysts rate 36 of 40 domains Satisfactory, 3 Watch and 1 Concern, and they agree on 36. Raw agreement is higher than in the base case, yet kappa falls to 0.46, moderate, because with that mix chance alone gives 81.6 per cent. This is the trap of a programme that rates nearly everything satisfactory: the agreement figure looks excellent precisely because the ratings carry little information. Kappa tells the head of ODD that the second review, in that programme, is mostly confirming defaults.

Weighted kappa gives half credit to one-notch disagreements. It raises the base case from 0.68 to 0.75 and is the right measure for an ordered scale, but report the Concern-only kappa beside it: in operational due diligence the near miss between Watch and Concern is the costly one.

The common mistake

Reporting percentage agreement and calling the rating process consistent. 90.0 per cent sounds reassuring and can mean less than 82.5. The second mistake is computing kappa on reviews that were not independent: if the second analyst has seen the first one's draft, agreement measures deference, not calibration. Run the exercise on a sample of reviews rated blind, at least once a year, and keep the confusion table, because the off-diagonal cells show which domains and which rating boundaries need a clearer definition.

Takeaway

The book asks whether two analysts would draw the line in the same place and builds a scorecard that records the second reviewer's view; the free workbook for this case measures how many managers sit one notch from a different recommendation. Why adding domains to a rubric weakens it is worked in why refining an ODD rubric makes it weaker.

Questions readers ask

What is a good Cohen's kappa for due diligence ratings?

The bands most often quoted, from Landis and Koch, call 0.61 to 0.80 substantial and 0.81 to 1.00 almost perfect. The illustrative pair of ODD analysts scores 0.68. To reach 0.80 with the same rating mix they would need to agree on 89.2 per cent of ratings, 36 of 40 rather than 33.

Why can 90 per cent agreement give a low kappa?

Because when nearly every rating is the same, agreement is easy by chance. In the illustrative skewed programme both analysts rate 36 of 40 domains satisfactory, so chance alone produces 81.6 per cent agreement. Their 90.0 per cent beats that by little, and kappa is 0.46, lower than the 0.68 of a pair agreeing only 82.5 per cent of the time.

What is weighted kappa and when should ODD teams use it?

Weighted kappa gives partial credit to near misses, so a Satisfactory against a Watch counts as half an agreement while Satisfactory against Concern counts as none. On the illustrative ratings it rises from 0.68 to 0.75. Use it for ordered scales, but report the plain figure for the Concern category, where a near miss is the one that matters.

Read the whole case

This article is one calculation from Operational Due Diligence in Private Equity. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

Get the book on Amazon →Free companion files

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada

Also on this site

Reading guide: private equity and private markets → · All 1340 articles →

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.