Hi There ,
This might be a relatively easy question but I dont understand how to do it. I tried using select if for this but it didnt work.
Here is the problem:
I have EIGHT columns of values which are set up in the following way
group 1 then Group 1 correct thhen group 2 then Group 2 correct then group 3 then Group 3 correct then group 4 then group 4 correct .
Now the columns labeled group 1, 2 3 and 4 contain numeric values (a bout 5-6 numeric values in each column). The columns adjacent to these columns as shown above are the ones that have a response of 1 or 2 for correct. That means if the numeric value corresponding to Group 1 for example has sa correct value then the column adjacent to it (i.e. group 1 correct) would have a value of 1.
I want to aggregate the Group 1 group 2 group 3 and group 4 values into 4 different columns labeled group 1 mean group 2 mean group 3 mean and group 4 mean. Now I know how to do this on spss and how I can use aggregate function to get the mean. However, what I also need to do is tell spss to aggregate the means only whenthe responses are Correct (=1) for the numeric values. How do I go about doing this on the syntax? I tried the select if command to specify to use the correct responses only but it apparently didnt work unless I entered it wrong somehow. So please advice me on what can be done so I can create my syntax asap.
Thanks for all the help