Hi everyone, I have an experiment where the participants should make decisions on the emotion of a face, the correct answer would be either 1 or 2. For those images, I stored the correct answers in correct_test column in the excel sheet. However, I have a couple of face images that can be either 1 or 2. I also put one answer in the correct_test column in the excel sheet since I didn’t know how to do either 1 or 2 in the excel sheet but I didn’t check the accuracy with this column for these specific images.
I have tried to code it this way (I put “1” and 1 since I couldn’t be sure if the numbers:
test_trials.xlsx (8.7 KB)
The problem is, when the images are in the list which I have 2 correct answers, output is always 0. However, it works when the images are not in the list (second part of the code) where it checks the correct_test column in the Excel sheet.