January 2018 M T W T F S S « Jan 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 Neuroscience Optical illusions Oxytocin Pareidolia Perception PowerPoint Prejudice Psychology Religion Science Uncategorized
### Archives

### Blogs I Follow

- Morten Besshø
- kogatravel
- contentedness.net
- brandoncoop
- Ming Thein | Photographer
- You Are Not So Smart
- The Millennium Conjectures™
- Rudy Oldeschulte, M.A., J.D., Qualif. Psychoanalysis
- TwistedSifter
- Byron's blog.
- coaching dreams
- neuroecology
- Gunnar og Marit sin treningsblogg
- KC Education Research Updates
- Happinessecrets
- Lachlan + Cathy
- Les Scientifique
- Mona skriver for livet
- yourcoachingbrain
- Komparativ Religion

### Meta

# 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

## 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

## 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