can excel calculate inter rater reliability?
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. |
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. |
All times are GMT +1. The time now is 09:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com