Diff for "FAQ/rmform" - CBU statistics Wiki

MRC CBU Wiki

Quick Links

Search Wiki

Page Tools

Differences between revisions 3 and 4

= How do I format data for input uto a repeated measures analysis of variance? =

An example data set for activity in different regions of the brain specified by eight combinations of areas corresponding to the x, y and z axes in 3 dimensions. The first four data points for subject 1 are given below. The replicates for each x, y, z combination correspond to different electrodes. These are not presumed to differ so can be pooled.

To present this as repeated measures data in SPSS we need to restructure the data as one row (per subject) with eight columns corresponding to each of the eight regional activity combinations meaned over the electrodes.

This can be done by first specifying a combination factor.

if (morph eq 1 and anterior eq 1 and lateral eq 1) comb=1.
if (morph eq 2 and anterior eq 1 and lateral eq 1) comb=2.
if (morph eq 1 and anterior eq 2 and lateral eq 1) comb=3.
if (morph eq 1 and anterior eq 1 and lateral eq 2) comb=4.
if (morph eq 2 and anterior eq 2 and lateral eq 1) comb=5.
if (morph eq 2 and anterior eq 1 and lateral eq 2) comb=6.
if (morph eq 1 and anterior eq 2 and lateral eq 2) comb=7.
if (morph eq 2 and anterior eq 2 and lateral eq 2) comb=8.
exe.

We can then use split file and the output management system to produce a table fo means and send these to a SPSS data file.

SORT CASES BY subj .
SPLIT FILE
  LAYERED BY subj .

OMS
/SELECT TABLES
 /IF SUBTYPES=['Report']
 /DESTINATION FORMAT=SAV
  OUTFILE="C:\comb.SAV"
 /COLUMNS SEQUENCE=[C1 R2].

MEANS
  TABLES=mmna  BY comb
  /CELLS MEAN COUNT STDDEV.

OMSEND.

Morph

<12% style="VERTICAL-ALIGN: center"> Anterior

Lateral

Activity

<12% style="VERTICAL-ALIGN: center"> Morph

<12% style="VERTICAL-ALIGN: center"> Anterior

Lateral

Activity

-0.22

<12% style="VERTICAL-ALIGN: center"> 0.93

-0.42

-0.19

<12% style="VERTICAL-ALIGN: center"> 0.24

<12% style="VERTICAL-ALIGN: center"> -0.25

-0.16

-0.36

-  ⇤ ← Revision 3 as of 2008-02-19 15:11:13 → 
  Size: 3396
  Editor: PeterWatson
  Comment:
+   ← Revision 4 as of 2008-02-19 15:14:48 → ⇥
  Size: 3298
  Editor: PeterWatson
  Comment:
-Deletions are marked like this.
+Additions are marked like this.
 Line 5:
-||||||||<25% style="TEXT-ALIGN: center"> '''Morph'''|| <25% style="TEXT-ALIGN: center"> '''Anterior''' ||<25% style="TEXT-ALIGN: center"> '''Lateral'''||<25% style="TEXT-ALIGN: center"> '''Activity''' ||
+||||||||<25% style="TEXT-ALIGN: center"> '''Morph'''||<25% style="TEXT-ALIGN: center"> '''Anterior''' ||<25% style="TEXT-ALIGN: center"> '''Lateral'''||<25% style="TEXT-ALIGN: center"> '''Activity''' ||
 Line 48:
-||||||||||||||||<12.5% style="TEXT-ALIGN: center"> '''Morph'''|| <12.5% style="VERTICAL-ALIGN: center"> '''Anterior''' ||<12.5% style="VERTICAL-ALIGN: center"> '''Lateral'''||<12.5% style="VERTICAL-ALIGN: center"> '''Activity''' || <12.5% style="VERTICAL-ALIGN: center"> '''Morph'''|| <12.5% style="VERTICAL-ALIGN: center"> '''Anterior''' ||<12.5% style="VERTICAL-ALIGN: center"> '''Lateral'''||<12.5% style="VERTICAL-ALIGN: center"> '''Activity''' ||
||||||||||||||||<12.5% style="TEXT-ALIGN: center"> '''Morph'''|| <12.5% style="VERTICAL-ALIGN: center"> '''Anterior''' ||<12.5% style="VERTICAL-ALIGN: center"> '''Lateral'''||<12.5% style="VERTICAL-ALIGN: center"> '''Activity''' || <12.5% style="VERTICAL-ALIGN: center"> '''Morph'''|| <12.5% style="VERTICAL-ALIGN: center"> '''Anterior''' ||<12.5% style="VERTICAL-ALIGN: center"> '''Lateral'''||<12.5% style="VERTICAL-ALIGN: center"> '''Activity''' ||
+||||||||||||||||<12% style="TEXT-ALIGN: center"> '''Morph'''|| <12% style="VERTICAL-ALIGN: center"> '''Anterior''' ||<12% style="VERTICAL-ALIGN: center"> '''Lateral'''||<12% style="VERTICAL-ALIGN: center"> '''Activity''' || <12% style="VERTICAL-ALIGN: center"> '''Morph'''|| <12% style="VERTICAL-ALIGN: center"> '''Anterior''' ||<12% style="VERTICAL-ALIGN: center"> '''Lateral'''||<12% style="VERTICAL-ALIGN: center"> '''Activity''' ||
||||||||||||||||<12% style="TEXT-ALIGN: center"> -0.22|| <12% style="VERTICAL-ALIGN: center"> 0.93 ||<12% style="VERTICAL-ALIGN: center"> -0.42||<12% style="VERTICAL-ALIGN: center"> -0.19 || <12% style="VERTICAL-ALIGN: center"> 0.24 || <12% style="VERTICAL-ALIGN: center"> -0.25 ||<12% style="VERTICAL-ALIGN: center"> -0.16||<12% style="VERTICAL-ALIGN: center"> -0.36 ||

Anterior

Lateral

Activity