can excel calculate inter rater reliability?

  • Thread starter Thread starter Brian Boru
  • Start date Start date
B

Brian Boru

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Excel as a markbook for attendance and assessment 1
Excel Consecutive counts with conditions in excel 0
A better explanation of help required 3
Discussion: The future 9
Best Method to Chart Numerous Data Points 1
Applying a rating scale to numerical measurements 3
Medical Assessment with more than 255 fields 11
lookup function to ignore blanks 1

Back
Top