transpose data?

[charlotte]

Hi,

My data currently looks something like this:(please see below for an example) and I'm looking to analyse the mean percent of accuracy with (1,2,3) in the colour column each representing a category for the independent variable. I can't work out how to perform the necessary 'descriptives' for assessing normality prior to an anova etc, I believe I need to restructure the data in some manner so that I can do this but I can't work out how. Or maybe I don't need to restructure but I'm totally unsure how to assess this data for normality. Please help.

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

[David Marso]

Normality of what? You have a nominal variable and a 0/1 variable what is there to test?
And while we are on the subject, what makes you think ANOVA is the appropriate test here?

charlotte wrote

Hi,

My data currently looks something like this:(please see below for an example) and I'm looking to analyse the mean percent of accuracy with (1,2,3) in the colour column each representing a category for the independent variable. I can't work out how to perform the necessary 'descriptives' for assessing normality prior to an anova etc, I believe I need to restructure the data in some manner so that I can do this but I can't work out how. Or maybe I don't need to restructure but I'm totally unsure how to assess this data for normality. Please help.

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

[charlotte]

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.

[Bruce Weaver]

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.