Posted by
Satish on
URL: http://spssx-discussion.165.s1.nabble.com/How-to-calculate-mean-score-in-summary-tables-tp5740461.html
Hi There
Can someone help me to calculate mean score for attached table named "Mean
score placement" cell highlighted in yellow. I am able to calculate %
successfully but not able to calculate means. Here is syntax for your
reference.
Thanks in advance
Test.sav
<
http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test.sav>
Mean_score_placement.xlsx
<
http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Mean_score_placement.xlsx>
CTABLES
/VLABELS VARIABLES=T_Q32_1 T_Q32_2 T_Q32_3 T_Q32_4 T_Q32_5 T_Q32_6
DISPLAY=DEFAULT
/PCOMPUTE &T2B= EXPR([4]+[5])
/PCOMPUTE &B2B= EXPR([1]+[2])
/PCOMPUTE &M3B= EXPR([3])
/PPROPERTIES &T2B LABEL = "T2B"
/PPROPERTIES &B2B LABEL = "B2B"
/PPROPERTIES &M3B LABEL = "Rest Scale"
/TABLE BY
(T_Q32_1[C]+T_Q32_2[C]+T_Q32_3[C]+T_Q32_4[C]+T_Q32_5[C]+T_Q32_6[C])
[COLPCT.COUNT F4.0 "%",TOTALS[COUNT"Base" F40.0]]
/CLABELS COLLABELS=OPPOSITE
/SLABELS POSITION=ROW
/CATEGORIES VARIABLES=T_Q32_1 T_Q32_2 T_Q32_3 T_Q32_4 T_Q32_5 T_Q32_6
[1,2,3,4,5,&T2B,&B2B,&M3B] TOTAL=YES LABEL='Total' POSITION=BEFORE
/TITLES
TITLES="Summary Tables".
--
Sent from:
http://spssx-discussion.1045642.n5.nabble.com/=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD