# How to organize the data for this repeated-measure within-subject setup?

This question is a follow up to the question I asked yesterday.

Here is the current situation again. I have data for a within subject measurement, where each variable is measured repeatedly. The repetitions are used to cancel out random fluctuation of the measured variable. Each subject was exposed to each of the conditions, so I have multiple datapoints per condition and subject.

Currently the data is organized like this:

Subject; Cond1_rep1; Cond1_rep2; ... Cond1_rep20; Cond1_mean; Cond2_rep1; Cond2_rep2; ... Cond2_rep20; Cond2_mean ... Cond8_rep1; Cond8_rep2 ... Con8_rep20; Cond8_mean
1      ; ....
2      ; ....


So I have eight Conditions, and around 20 repetitions per condition per subject. Currently there are about 20 subjects to be included in the analysis (no removal of outliers and other data cleanup is done yet).

Now for analysis the first attempt would be to do a multivariate ANOVA on all the means for all different conditions to see if there is any difference in the distributions. However if I use means like this I will use the fact, that each value probably has a very low error and the likelihood of a false result is actualy lower than estimated by the ANOVA. So I should somehow include the repetitions in the analysis.

The suggestion I was given in the previous question was to use a generalized linear model with repetitions and include all the repetitions in the analysis. However in this case I would need an additional variable identifying the conditions to be used as an independent variable in the generalized linear model. So I would have to somehow add this in my data.

What I would try would be first to split up the eight conditions. The eight conditions come from variations of three independent factors, so I can easily split them up. Then I would separate my data into multiple rows, so I can introduce a condition variable. This way I would organize like this:

Subject; Factor1; Factor2; Factor3; Rep1; Rep2; ... Rep20
1      ; 0      ; 0      ; 0      ; ...
1      ; 1      ; 0      ; 0      ; ...
1      ; 0      ; 1      ; 0      ; ...
1      ; 1      ; 1      ; 0      ; ...
...
1      ; 1      ; 1      ; 1      ; ...
2      ; 0      ; 0      ; 0      ; ...
2      ; 1      ; 0      ; 0      ; ...


This way I would get eight rows per subject with a different combination of factors. In this case I can do a repeated measures GLM with the factors as independent variables and the 20 repeated measurements as repeated dependent variables.

Would this setup be correct or are there any drawbacks? If there are, is there any better way of analysing this data without loosing the fact that each measurement was repeated multiple time (as when you take the mean first).

EDIT:

I am not so much interested in a way to restructure the data like this, but my main question if there could be a problem when I do a GLM like this, without taking into account that some data points where gathered from the same person. The final analysis in SPSS should not be a problem.

• The intended statistical package is R or SPSS? Because, with R you would need to work with so-called "long" format (repetition number coded into one column), while for SPSS you effectively need to use "wide" format (AFAICT from reading Repeated Measures Analysis with SPSS).
– chl
Mar 14, 2012 at 21:50
• @chl: The data is analysed in SPSS. Mar 14, 2012 at 21:55
• Ok, so I let more experienced users answer this question. Although this question is about SPSS coding--somewhat not within the scope of our FAQ--a good response that goes beyond SPSS syntax would probably be beneficial for everybody and might serve as a reference for future questions.
– chl
Mar 14, 2012 at 22:01
• @chl: Actually I am not so much interested in a way to restructure the data or do the final analysis. I can easily restructure the data in python and also the analysis is no problem. This means, I would not actually need the SPSS code for doing this. The main question is, wether this layout makes sense at all, or if I am doing something terribly wrong when I have multiple rows (sets of repetition) per subject. Mar 14, 2012 at 22:19
• Even better then! Some statistical packages require some particular data layout for repeated measures (this was the case for Statistica, for example). I've never used SPSS with repeated measures, so I can't tell if the above suggestion would work.
– chl
Mar 14, 2012 at 22:25