Prev: UserAccounts.CommonDialog - How it works
Next: Hidden cells
From: Brian Boru Brian on 9 Mar 2010 03:24
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.
From: Max on 9 Mar 2010 08:05
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.
 | 
Pages: 1
Prev: UserAccounts.CommonDialog - How it works
Next: Hidden cells