What formula would I use?

Im doing a project for my experimental psychology class . For my project I had to carry out an experiment start to finish. The purpose of my experiment was to see which sex is more accurate at detecting transgenders. So I had 10 pictures of non-transgenders and 10 pictures of transgenders. On the survey, I asked the participant to choose whether the picture I provided was a transgender or not and then to rate how sure they were of this choice. I am running into a problem figuring out what formula I would use in excel to determine the accuracy of how well each sex was a determining which picture was a transgender or not Can anyone help me out? I attached a picture of the excel file if that helps any.
Last edited:


TS Contributor
Hi, this seams to be a classical appraiser analysis type of question - take a look at Cohen kappa or Fleiss kappa