View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default can excel calculate inter rater reliability?

How about CORREL?
Eg in D2: =CORREL(B2:B100,C2:C100)
where
col A = items/features to be rated
col B = numeric ratings by student 1
col C = numeric ratings by student 2

Correlation results will vary between -1 to 1, where
1 = perfect agreement
-1 = perfect disagreement
0 = no correlation
--
Max
Singapore
---
"Brian Boru" wrote:
two students are using a rating scale to independently assess the quality of
medical letters. They are trying to assess to what extent their ratings agree
with each other. They have ready access to excel.