May 2024 M T W T F S S 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 - Addiction Authority Cartoons Consciousness Cunningham Diplopi Evolution Excel Eye tracker Face perception Humor Ideological war Ignorance Judgement and Decision making Master Thesis Music Neuroscience Optical illusions Oxytocin Pareidolia Perception PowerPoint Prejudice Psychology Religion Science Uncategorized
Archives
Blogs I Follow
- Morten mener ...
- kogatravel
- contentedness.net
- brandoncoop
- Ming Thein | Photographer
- You Are Not So Smart
- The Millennium Conjectures™
- TwistedSifter
- Byron's blog.
- coaching dreams
- neuroecology
- Gunnar og Marit sin treningsblogg
- KC Education Research Updates
- Lachlan + Cathy
- Mona skriver for livet
- yourcoachingbrain
- Emma has lost the plot
- James J Need
- InPsyghts
- Man the Measure
Meta
Category 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
Nesting IF and AND Functions in Excel
Short clip showing how to use the nested IF and AND function in Excel 2007. This is an example of a simple formula where I wanted two different actions (Yes/No) and stimuli (Face/Control) to come out as numbers in four … Continue reading
Calculate Age in Excel 2007
It’s easy to calculate someone’s age from their date of birth if you know about Excel’s DATEDIF function, unfortunately it’s easy to miss this function as it is not documented. I am baffled why it is never included in the … Continue reading
Posted in Excel
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
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
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
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
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 Excel, Mean, Standard deviation, statistical estimates, Variance
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 data collection and analysis, Excel, randomize, Randomizing, scientific method, Stimulus list, test protocols
2 Comments