Assessing reliability

ReCal (”Reliability Calculator”) is an online utility that computes intercoder/interrater reliability coefficients for nominal ordinal, interval or ratio-level data. I haven't tried it out yet, but will need to test reliability on my analysis, so I'm bookmarking it here.

http://dfreelon.org/utils/recalfront/

Counting words in an Excel cell

http://office.microsoft.com/en-us/excel-help/count-the-number-of-words-in-a-cell-or-range-HA001034625.aspx

=IF(LEN(TRIM(A1))=0,0,LEN(TRIM(A1))-LEN(SUBSTITUTE(A1," ",""))+1)

I knew there must be a way of doing this - but hadn't tracked down the exact formula until now. This one piece of information made the whole Excel course worthwhile. Now that I have the link it looks like such an easy thing to Google that I can't think why I didn't manage to track it down by myself. Suppose I was just convinced that there would be a WORDCOUNT function buried somewhere in Excel.