I have conducted an experiment in which participants saw one figure (target) briefly followed by a figure (probe) and asked if they were the same (yes) or not (no). Five different figures total, and when the probe did not match the target, one of the other four figures were used. This has given me an Excel file with one column that tells me the correct response to the given trial (either yes  or no ) and one column that tells me what the participant responded (yes or no). The combination of 1 and 1 would be hit, and 2 and 1 would be false alarm. I need to calculate d prime for each of the five figures and these are randomly ordered in my output. I want to get this into SPSS and use SPSS to calculate d prime (z[hit] - z[false alarm]) - unless it is miles easier to just calculate d prime in Excel?
This gives me a couple issues. (1) Given SPSS wants one row per participant, how can I do this when I need 3-4 variables (correct response, observed response, target identity and probe identity) for each trial (96 trials)? Unsure how to plot this correctly. (2) How do I calculate the Z scores? (3) How do I calculate the d prime?
And if this is much easier to deal with in Excel, how do I do it there? SPSS would be ideal since that is where we are meant to analyse our data.
Thank you so much if you are able to help me out!