Re: transpose data?

Posted by Bruce Weaver on Apr 19, 2014; 7:35pm
URL: http://spssx-discussion.165.s1.nabble.com/transpose-data-tp5725547p5725551.html

Okay.  Here's the example you showed in your first post:

Colour Accuracy
1           1
1           1
1           0
1           1
1           0
1           1
2           1
2           0
2           1
2           0
2           1
2           1
3           0
3           1
3           1
3           1
3           1
3           1
3           0
3           1
3           0

If I follow, this is raw accuracy data, with each line representing one trial in your experiment, and you want to end up with something that looks like this:

acc1 acc2 acc3
66.7  66.7 66.7

If that is what you want, look up AGGREGATE and CASESTOVARS, and study the examples.  

HINT 1:  Given that your variable are coded 1-0, the MEAN function in AGGREGATE will give you the proportion of scores that are 1s.  Multiply those proportions by 100 if you need to be report them as percentages.  

HINT 2:  I expect your file contains raw accuracy data for multiple subjects.  If so, you'll need two BREAK variables for the AGGREGATE command, the unique ID variable AND the colour variable.

HTH.

charlotte wrote

Sorry just saw the avoiding small talk notice, will keep to the point. The data I'm working with is similar to this: http://computingforpsychologists.wordpress.com/2012/12/11/how-to-analyse-reaction-time-rt-data-part-1/ only the portion I'm working on is the accuracy section. I'm trying to work out what to do with the data to get mean accuracy(%) for each category(1,2,3) and to compare them & get descriptives etc. Sorry I meant Anova as an example of statistical analysis I'd run after, I shouldn't have specified.

If this doesn't make more sense let me know & I won't post again.