advanced help needed for data analysis

**rob0387** · 01-31-2014, 04:14 PM

Hi,

I'm fairly new to excel and am having some trouble with some data I've collected. The data is from an attention experiment, and in order to analyse it I need to identify participants correct responses.

At the moment the output gives me a number for the stimuli shown in degress (360, 270, 180 and 90), and a column with the participants response (1,2,3 or 4). I need to find a way to identify whether their response matched the orientation they saw, with 1 being 360, 2 being 180, 3 being 270, 4 being 90. I then need another column to identify whether this was correct with a 1 for correct and 0 for incorrect.

Can anybody please help??

**AlKey** · 01-31-2014, 04:40 PM

Here is something that you can try

=INDEX({360,180,270,90},MATCH(A1,{1,2,3,4}))

	A	B
1	4	90
2	2	180
3	1	360
4	3	270

For Correct/Incorrect answers something like this

**Commas may need to be replaced with ; in your region

=IF(A5="Correct",1,0)

Change cell references as need it.