The SPSS syntax below computes the raw score means with given mean rank (as outputted by !kwpairs). This may be a more intuitive way of expressing the locations of each group. Run immediately after running !kwpairs as the macro assumes the data has been backed up in a file called input.sav which is created by running !kwpairs.
[COPY AND PASTE BELOW SYNTAX INTO A SPSS SYNTAX WINDOW; SELECT ALL AND RUN; EDIT LAST TWO LINES TO SUBSTITUTE OBSERVED MEAN RANKS]
* input a column of scores (y) and group * run immediately after using !kwpairs macro * using the outputted mean ranks as input in * bottom line below; * BACKUP DATA BEFORE RUNNING THIS MACRO * * outputs in file called output.sav (located in * My Documents folder) and in output window * the raw data value in original data with * corresponding mean rank obtained by * interpolation set errors=none. set mprint=off. DEFINE RMEAN (!POS !TOKENS(1)). get file=input.sav. COMPUTE MR=!1. RANK VARIABLES=y (A) /RANK /PRINT=YES /TIES=MEAN . exe. SORT CASES BY RY(A). IF (MR GT RY) LR=MIN(ABS(MR-RY)). IF (MR LT RY) UR=MIN(ABS(MR-RY)). EXE. IF (LR GT 0) IND=1. IF (UR GT 0) IND=2. EXE. aggregate outfile=* /break=IND /LRY LY=MAX(RY Y) /URY UY=MIN(RY Y). IF (IND EQ 1) LRYY=LRY. IF (IND EQ 1) LYY=LY. IF (IND EQ 2) URYY=URY. IF (IND EQ 2) UYY=UY. EXE. COMPUTE dummy=1. EXE. aggregate outfile=* /break=dummy /RY1 Y1 RY2 Y2=FIRST(LRYY LYY URYY UYY). COMPUTE MR=!1. COMPUTE RMN=Y1 + (Y2-Y1) * (MR-RY1) / (RY2-RY1). EXE. aggregate outfile=* /break=dummy /LY=FIRST(RMN). save outfile=output.sav /keep = LY. exe. GET FILE=OUTPUT.SAV. compute mr=!1. formats all (f11.8). variable labels mr 'Mean Rank' /ly 'Raw mean' . report format=list automatic align(center) /variables=mr ly /title "Raw score mean obtained by interpolation having given mean rank". !ENDDEFINE. * input a single group mean rank as outputted * by !kwpairs macro: * macro outputs raw data value in original data * with inputted corresponding mean rank * substitute the two outputted mean ranks * for 8.5 and 8.0714 given below RMEAN 8.5. RMEAN 8.0714.