Tag Archives: Excel

Signal Detection Theory

The signal detection theory evolved from the development of communications and radar equipment the first half of this century.  It migrated to psychology, initially as part of sensation and perception, in the 50’s and 60’s as an attempt to understand … Continue reading

Posted in Excel, Master Thesis, Perception, Uncategorized | Tagged , , , , | Leave a comment

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

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

Import Text Into Excel

Sometimes you need to import data from, lets say matlab, eprime, word or just a txt.-file, so you can further analyze it in Excel or SPSS. Its quite easy-piecy, like the clip above shows, or the web page below also … Continue reading

Posted in Excel | Tagged , , | 1 Comment

Calculating the Mean and Standard Deviation with Excel

Sometimes you just want to calculate the average mean and standard deviation without having the hassle to open SPSS or other statistical programs. Then Excel comes in handy, and here’s a simple video explaining how to find your sought after … Continue reading

Posted in Excel, Master Thesis | Tagged , , , , | 1 Comment

Randomizing lists in Excel

Since a big part of working with a master thesis is data collection and analysis, I first have to create list of stimuli I want my participants to look at. But since I want to follow the scientific method, I … Continue reading

Posted in Excel, Master Thesis | Tagged , , , , , , | 2 Comments