can excel calculate inter rater reliability?

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

Max

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
COUNTIF formula Using 2 or more cells 2
What are the benefits of using 32 bit Excel 2010 on 64 bit Windows 7 1
Excel assignment 0
how to add a combolist drop down to each row 2
lookup function to ignore blanks 1
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
XIRR vs. IRR Function 11

Top