FAQ/lbaroms - CBU statistics Wiki

Upload page content

You can upload content for the page named below. If you change the page name, you can also upload content for another page. If the page name is empty, we derive the page name from the file name.

File to load page content from
Page name
Comment
Type the odd characters out in each group: abz2a 125t7 HhHaHh year.s 5433r21 worl3d

location: FAQ / lbaroms

Using OMS to produce interaction plots

The below produces an excel file which can be used to obtain graphs of means with their confidence intervals. The means from combinations of categorical variable values (e.g. age and sex) must be recoded into a single value. This can be done using if statements such as 

IF(age eq 1 and sex eq 'M') group =1.
exe.

Since EXCEL only accepts series of adjacent cells care should be taken in the values of the single recoded group variable. 

OMS
/SELECT TABLES
/IF SUBTYPES=['DESCRIPTIVES']
/DESTINATION FORMAT=SAV OUTFILE='c:\descriptives.sav'
/COLUMNS SEQUENCE=[R3].

EXAMINE
  VARIABLES=test_score BY group
  /PLOT NONE
  /STATISTICS
  /CINTERVAL 95
  /MISSING LISTWISE
  /NOTOTAL.

OMSEND.

GET FILE='C:\descriptives.sav'.
exe.

compute width=UpperBound-Mean.
exe.

select if(var3 eq 'Statistic').
SAVE TRANSLATE OUTFILE='C:\ebars.xls'
  /TYPE=XLS /VERSION=8 /MAP /REPLACE /FIELDNAMES
  /CELLS=VALUES
  /DROP=Command_ Subtype_ Label_ Var1 Var2 Var3 LowerBound UpperBound @5TrimmedMean Median Variance Std.Deviation Minimum
  Maximum Range InterquartileRange Skewness Kurtosis  .

You should have a file on your C: drive called ebars.sav which contains two columns called mean and width.