---A--- --B-- --C-- --D-- --E-- --F-- --G-- ---------------------H---------------------
1 nSubj 10 B1: =ROWS(A7:A16)
2 Total 140 B2: =SUM(B7:F16)
3 nR 14 B3: =Total / nSubj
4
5
6 Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 P(i)
7 Subj 01 0 0 0 0 14 1.000 G7 and down: =(SUMSQ(B7:F7) - nR)/nR/(nR-1)
8 Subj 02 0 2 6 4 2 0.253
9 Subj 03 0 0 3 5 6 0.308
10 Subj 04 0 3 9 2 0 0.440
11 Subj 05 2 2 8 1 1 0.330
12 Subj 06 7 7 0 0 0 0.462
13 Subj 07 3 2 6 3 0 0.242
14 Subj 08 2 5 3 2 2 0.176
15 Subj 09 6 5 2 1 0 0.286
16 Subj 10 0 2 2 3 7 0.286
17 Total 20 28 39 21 32 3.780 B17 and across: =SUM(B7:B16)
18 p(i) 0.143 0.200 0.279 0.150 0.229 0.213 B18 and across: =B17/Total
19 G18: =SUMSQ(B18:F18)
20
21 Kappa 0.210 B21: =(G17/nSubj - G18) / (1 - G18)
Here's the example from Fleiss' kappa - Wikipedia, the free encyclopedia (which has some numerical errors) worked in Excel:
Code:---A--- --B-- --C-- --D-- --E-- --F-- --G-- ---------------------H--------------------- 1 nSubj 10 B1: =ROWS(A7:A16) 2 Total 140 B2: =SUM(B7:F16) 3 nR 14 B3: =Total / nSubj 4 5 6 Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 P(i) 7 Subj 01 0 0 0 0 14 1.000 G7 and down: =(SUMSQ(B7:F7) - nR)/nR/(nR-1) 8 Subj 02 0 2 6 4 2 0.253 9 Subj 03 0 0 3 5 6 0.308 10 Subj 04 0 3 9 2 0 0.440 11 Subj 05 2 2 8 1 1 0.330 12 Subj 06 7 7 0 0 0 0.462 13 Subj 07 3 2 6 3 0 0.242 14 Subj 08 2 5 3 2 2 0.176 15 Subj 09 6 5 2 1 0 0.286 16 Subj 10 0 2 2 3 7 0.286 17 Total 20 28 39 21 32 3.780 B17 and across: =SUM(B7:B16) 18 p(i) 0.143 0.200 0.279 0.150 0.229 0.213 B18 and across: =B17/Total 19 G18: =SUMSQ(B18:F18) 20 21 Kappa 0.210 B21: =(G17/nSubj - G18) / (1 - G18)
Can you hammer your data into that format?
If not, post a link that describes what you're trying to do.
Here's the example from http://en.wikipedia.org/wiki/Fleiss'_kappa (which has some numerical errors) worked in Excel:
Code:---A--- --B-- --C-- --D-- --E-- --F-- --G-- ---------------------H--------------------- 1 nSubj 10 B1: =ROWS(A7:A16) 2 Total 140 B2: =SUM(B7:F16) 3 nR 14 B3: =Total / nSubj 4 5 6 Cat 1 Cat 2 Cat 3 Cat 4 Cat 5 P(i) 7 Subj 01 0 0 0 0 14 1.000 G7 and down: =(SUMSQ(B7:F7) - nR)/nR/(nR-1) 8 Subj 02 0 2 6 4 2 0.253 9 Subj 03 0 0 3 5 6 0.308 10 Subj 04 0 3 9 2 0 0.440 11 Subj 05 2 2 8 1 1 0.330 12 Subj 06 7 7 0 0 0 0.462 13 Subj 07 3 2 6 3 0 0.242 14 Subj 08 2 5 3 2 2 0.176 15 Subj 09 6 5 2 1 0 0.286 16 Subj 10 0 2 2 3 7 0.286 17 Total 20 28 39 21 32 3.780 B17 and across: =SUM(B7:B16) 18 p(i) 0.143 0.200 0.279 0.150 0.229 0.213 B18 and across: =B17/Total 19 G18: =SUMSQ(B18:F18) 20 21 Kappa 0.210 B21: =(G17/nSubj - G18) / (1 - G18)
Can you hammer your data into that format?
If not, post a link that describes what you're trying to do.
Row\Col | B | C | D | E | F | G |
4 | nSubj | 12 | ||||
5 | Total | 72 | ||||
6 | nR | 6 | ||||
7 | ||||||
8 | Psychotic | Bordeline | Bipolar | None | P(i) | |
9 | Patient 01 | 4 | 2 | 0.467 | ||
10 | Patient 02 | 1 | 2 | 3 | 0.267 | |
11 | Patient 03 | 1 | 4 | 1 | 0.400 | |
12 | Patient 04 | 1 | 1 | 4 | 0.400 | |
13 | Patient 05 | 1 | 5 | 0.667 | ||
14 | Patient 06 | 1 | 5 | 0.667 | ||
15 | Patient 07 | 2 | 3 | 1 | 0.267 | |
16 | Patient 08 | 3 | 3 | 0.400 | ||
17 | Patient 09 | 2 | 4 | 0.467 | ||
18 | Patient 10 | 3 | 3 | 0.400 | ||
19 | Patient 11 | 4 | 2 | 0.467 | ||
20 | Patient 12 | 6 | 1.000 | |||
21 | Total | 12 | 20 | 26 | 14 | 5.867 |
22 | p(i) | 0.167 | 0.278 | 0.361 | 0.194 | 0.273 |
23 | ||||||
24 | ||||||
25 | Kappa | 0.2968 |
Welcome to the board.
I take your point, but don't know enough statistics to explain it.
There's another example at Fleiss' Kappa | Real Statistics Using Excel, and the same formulas give the same result obtained there:
Row\Col B C D E F G 4 nSubj 12 5 Total 72 6 nR 6 7 8 Psychotic Bordeline Bipolar None P(i) 9 Patient 01 4 2 0.467 10 Patient 02 1 2 3 0.267 11 Patient 03 1 4 1 0.400 12 Patient 04 1 1 4 0.400 13 Patient 05 1 5 0.667 14 Patient 06 1 5 0.667 15 Patient 07 2 3 1 0.267 16 Patient 08 3 3 0.400 17 Patient 09 2 4 0.467 18 Patient 10 3 3 0.400 19 Patient 11 4 2 0.467 20 Patient 12 6 1.000 21Total 12 20 26 14 5.867 22p(i) 0.167 0.278 0.361 0.194 0.273 23 24 25Kappa 0.2968
<tbody>
</tbody>
If you figure it out, let me know.