Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Inter-rater reliability question | Excel Worksheet Functions | |||
Reliability and Confidence and Excel | Excel Discussion (Misc queries) | |||
how do i save an excel graph as an image file for use on the inter | Charts and Charting in Excel | |||
excel inter-document linking acrobat | Excel Discussion (Misc queries) | |||
How does one sort a block of inter-related information in Excel? | Excel Worksheet Functions |