Monthly Archives: February 2014

Nesting IF and AND Functions in Excel

Posted on February 26, 2014 by diplopi

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 →

Posted in Excel | 1 Comment

Calculate Age in Excel 2007

Posted on February 24, 2014 by diplopi

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

Happy Valentine’s Day

Posted on February 14, 2014 by diplopi

  Happy Valentine’s Day and may the Oxytocin be with you!

Posted in Cartoons, Humor, Oxytocin | Tagged , , | Leave a comment

Brain Rewards Us for Looking at Pretty Faces

Posted on February 11, 2014 by diplopi

You probably saw dozens of people’s faces today, many more if you live in a city. You may not have been conscious of it, but you were subtly judging every one by its beauty. Your eyes are drawn to more … Continue reading →

Posted in Eye tracker, Face perception, Judgement and Decision making, Neuroscience, Perception, Psychology, Science | Tagged , , , , , , , , , | Leave a comment

Invisible Optical Illusion

Posted on February 9, 2014 by diplopi

Try this exercise: close your left eye. Notice that big thing obscuring the left side of your vision? Yes, it’s your nose! Now, close just your right eye. You can see your nose on the right! No big surprise there. OK, … Continue reading →

Posted in Humor, Optical illusions, Perception | Tagged , , , | Leave a comment

How to Stand out in the Crowd of Photos Online

Posted on February 5, 2014 by diplopi

Why do we remember some faces, while we forget others? It’s done a lot of research on what makes a face stick in the memory, but the reasons are complex. A wide smile when the picture is taken, for example, … Continue reading →

Posted in Face perception, Judgement and Decision making, Neuroscience, Perception, Psychology, Science | Tagged , , , , , , | Leave a comment

The Problems with the Love Hormone Oxytocine

Posted on February 2, 2014 by diplopi

Oxytocin gets released during light caresses, sex, when someone shows they trust you, and sometimes even simply with talking. When released, oxytocin increases feelings of attachment for another person, as well as feelings of trust. It also decreases feelings of stress, … Continue reading →

Posted in Judgement and Decision making, Neuroscience, Oxytocin, Perception, Psychology, Science | Tagged , , , , , , | Leave a comment