Daily Archives: November 18, 2013

Student t-Test in Excel

To test if any two different image sets are equal or unequal, one can also perform a t-test to see if they differ from each other or are more or less the same. Here’s another clip, almost the same, but … Continue reading

Posted in Excel | Tagged , | Leave a comment

Sensitivity Detection Theory and Receiver Operating Characteristic using SPSS

In my masters thesis I have two image sets, which should be more or less equal in the sense of being easy/hard for the participants. So how do I find out how equal these two sets are? First I run … Continue reading

Posted in Excel | Tagged , | Leave a comment

If/Then function in Excel

This post is about if you want to use the ‘if/then’ function in Excel with letters or text. The ‘original’ if/then formula with values is something like this: =IF(C13=20,1,0) But if you want to use text or letters, just put … Continue reading

Posted in Excel | Tagged , | 1 Comment