Hi

The easiest method to do this is to do it in the data editor and then list the result using SUMMARISE. I assume the month variable is numeric (1=Jan, 2=Feb, etc). Recode the values if this is not the case.

DATA LIST LIST /rate1 rate2 mth. BEGIN DATA 4 5 1 5 3.5 2 3 4 1 4 4 2 5 2.5 1 3 5 3 4 4 3 2 4 1 END DATA. LIST.

VECTOR mth(3F8.0) /rate=rate1 TO rate2. LOOP cnt=1 TO 2. COMPUTE mth(mth)=rate(cnt). XSAVE OUTFILE='c:\temp\temp.sav' /KEEP=cnt mth1 TO mth3. COMPUTE mth(mth)=$SYSMIS. END LOOP. EXECUTE. GET FILE='c:\temp\temp.sav' .

AGGREGATE /OUTFILE=* /BREAK=cnt /mth1 TO mth3 = MEAN(mth1 TO mth3).

COMPUTE diff=mth3 - mth2.

SUMMARIZE /TABLES=mth1 TO mth3 diff /FORMAT=VALIDLIST NOCASENUM TOTAL /TITLE='Mean values and difference (March - Feb)' /MISSING=VARIABLE /CELLS=NONE.

Raynald Levesque rlevesque@videotron.ca Visit My SPSS Pages: http://pages.infinit.net/rlevesqu/

-----Original Message----- From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of Gerald Sent: Thursday, May 24, 2001 1:33 AM To: SPSSX-L@LISTSERV.UGA.EDU Subject: Re: Mean Difference between Categories

Dear list members, Is there a script to enable the following to be done?

Eg. 3 Variables - 2 Service Rating Questions (Rate1 & Rate 2) & Month of the Year(month) The mean rating scores table output can be generated as follows:

(Month) Jan Feb Mar Diff Rate1 4.56 3.67 2.78 ? Rate2 3.78 2.89 2.90 ?

Can there be a new column (Diff = Difference of Means between Feb & Mar) generated in SPSS output table format together with the means columns?

Appreciate any feedback and suggestions. Thanks in advance

Warm Regards Gerald