SPSSX Discussion

How to generate top 2 and top 4 box for 10 Point scale question with compare test...

Classic

List

Threaded

5 messages Options

Satish

How to generate top 2 and top 4 box for 10 Point scale question with compare test...

Hi Guyes,

I need your support how to generate top 2 box and top 4 box for 10 point
scale question. I have searched a lot on portal but not able to see as per
my requirement.

I am using this syntax and i am getting data correctly as well but i noticed
that i am not getting compare test value in table.

CTABLES
/pcompute &T2B = expr([9] + [10])
/pproperties &T2B label = "% Top 2 box" hidesourcecats=no
format=COLPCT.COUNT
/pcompute &T4B = expr([7] + [8] + [9] + [10])
/pproperties &T4B label = "% Top 4 box" hidesourcecats=no
format=COLPCT.COUNT
/VLABELS VARIABLES=Q6 DISPLAY=None
/TABLE
Q6[C] [COLPCT.COUNT '' F40.0,TOTALS[COUNT"" F40.0]] by
Total [C]+Q1 [C]+Q2 [C]
/SLABELS POSITION=ROW VISIBLE=NO
/CATEGORIES VARIABLES=Q6 EMPTY=INCLUDE TOTAL=YES LABEL= "N=" POSITION=
BEFORE
/CATEGORIES VARIABLES=Total EMPTY=INCLUDE TOTAL=No LABEL= " " POSITION=
BEFORE
/categories variables=Q6 [0 thru 10, &T2B, &T4B] total=NO
/COMPARETEST TYPE=PROP ADJUST=NONE ALPHA=.05
/TITLES
TITLE=")TABLE".

Here is the test data set

Test_Data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Data.sav>

Here is the test output file
Test_Output.xlsx
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Output.xlsx>

Regards
SAT

--
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

Jon Peck

Re: How to generate top 2 and top 4 box for 10 Point scale question with compare test...

Your total variable is not in that data file, but computed categories are not used in tests. You might try using SUBTOTAL or HSUBTOTAL instead.

On Mon, Oct 19, 2020 at 1:46 PM Satish <[hidden email]> wrote:

Hi Guyes,

I need your support how to generate top 2 box and top 4 box for 10 point
scale question. I have searched a lot on portal but not able to see as per
my requirement.

I am using this syntax and i am getting data correctly as well but i noticed
that i am not getting compare test value in table.

CTABLES
/pcompute &T2B = expr([9] + [10])
/pproperties &T2B label = "% Top 2 box" hidesourcecats=no
format=COLPCT.COUNT
/pcompute &T4B = expr([7] + [8] + [9] + [10])
/pproperties &T4B label = "% Top 4 box" hidesourcecats=no
format=COLPCT.COUNT
/VLABELS VARIABLES=Q6 DISPLAY=None
/TABLE
Q6[C] [COLPCT.COUNT '' F40.0,TOTALS[COUNT"" F40.0]] by
Total [C]+Q1 [C]+Q2 [C]
/SLABELS POSITION=ROW VISIBLE=NO
/CATEGORIES VARIABLES=Q6 EMPTY=INCLUDE TOTAL=YES LABEL= "N=" POSITION=
BEFORE
/CATEGORIES VARIABLES=Total EMPTY=INCLUDE TOTAL=No LABEL= " " POSITION=
BEFORE
/categories variables=Q6 [0 thru 10, &T2B, &T4B] total=NO
/COMPARETEST TYPE=PROP ADJUST=NONE ALPHA=.05
/TITLES
TITLE=")TABLE".

Here is the test data set

Test_Data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Data.sav>

Here is the test output file
Test_Output.xlsx
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Output.xlsx>

Regards
SAT

--
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

Jon K Peck
[hidden email]

===================== 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

Javier Figueroa

Re: How to generate top 2 and top 4 box for 10 Point scale question with compare test...

Hello!!!

In this particular case, you should recode to a different variable in this way and calculate the significant differences in different variables.

RECODE q6 (9 thru 10 = 9) INTO q6_1.
VARIABLE LABELS q6_1 '% Top 2 box'.
RECODE q6 (7 thru 10 = 7) INTO q6_7.
VARIABLE LABELS q6_1 '% Top 4 box'.
EXECUTE.

VALUE LABELS q6_1 q6_7
9 '% Top 2 box'
7 '% Top 4 box'.

El lun., 19 oct. 2020 a las 14:21, Jon Peck (<[hidden email]>) escribió:

Your total variable is not in that data file, but computed categories are not used in tests. You might try using SUBTOTAL or HSUBTOTAL instead.

On Mon, Oct 19, 2020 at 1:46 PM Satish <[hidden email]> wrote:
Hi Guyes,

I need your support how to generate top 2 box and top 4 box for 10 point
scale question. I have searched a lot on portal but not able to see as per
my requirement.

I am using this syntax and i am getting data correctly as well but i noticed
that i am not getting compare test value in table.

CTABLES
/pcompute &T2B = expr([9] + [10])
/pproperties &T2B label = "% Top 2 box" hidesourcecats=no
format=COLPCT.COUNT
/pcompute &T4B = expr([7] + [8] + [9] + [10])
/pproperties &T4B label = "% Top 4 box" hidesourcecats=no
format=COLPCT.COUNT
/VLABELS VARIABLES=Q6 DISPLAY=None
/TABLE
Q6[C] [COLPCT.COUNT '' F40.0,TOTALS[COUNT"" F40.0]] by
Total [C]+Q1 [C]+Q2 [C]
/SLABELS POSITION=ROW VISIBLE=NO
/CATEGORIES VARIABLES=Q6 EMPTY=INCLUDE TOTAL=YES LABEL= "N=" POSITION=
BEFORE
/CATEGORIES VARIABLES=Total EMPTY=INCLUDE TOTAL=No LABEL= " " POSITION=
BEFORE
/categories variables=Q6 [0 thru 10, &T2B, &T4B] total=NO
/COMPARETEST TYPE=PROP ADJUST=NONE ALPHA=.05
/TITLES
TITLE=")TABLE".

Here is the test data set

Test_Data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Data.sav>

Here is the test output file
Test_Output.xlsx
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Output.xlsx>

Regards
SAT

--
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

--
Jon K Peck
[hidden email]

===================== 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

Javier Figueroa
Procesamiento y Análisis de bases de datos

Cel: 5927-4748 / 4970-1940

Casa: 2289-0184

Satish

Re: How to generate top 2 and top 4 box for 10 Point scale question with compare test...

In reply to this post by Jon Peck

Hi Jon,

Thanks for your reply, I tried the same and it's working with T2B box but not with top 4 box there is some error of duplication.

Regards

On Tue, 20 Oct 2020 at 01:50, Jon Peck <[hidden email]> wrote:

Your total variable is not in that data file, but computed categories are not used in tests. You might try using SUBTOTAL or HSUBTOTAL instead.

On Mon, Oct 19, 2020 at 1:46 PM Satish <[hidden email]> wrote:
Hi Guyes,

I need your support how to generate top 2 box and top 4 box for 10 point
scale question. I have searched a lot on portal but not able to see as per
my requirement.

I am using this syntax and i am getting data correctly as well but i noticed
that i am not getting compare test value in table.

CTABLES
/pcompute &T2B = expr([9] + [10])
/pproperties &T2B label = "% Top 2 box" hidesourcecats=no
format=COLPCT.COUNT
/pcompute &T4B = expr([7] + [8] + [9] + [10])
/pproperties &T4B label = "% Top 4 box" hidesourcecats=no
format=COLPCT.COUNT
/VLABELS VARIABLES=Q6 DISPLAY=None
/TABLE
Q6[C] [COLPCT.COUNT '' F40.0,TOTALS[COUNT"" F40.0]] by
Total [C]+Q1 [C]+Q2 [C]
/SLABELS POSITION=ROW VISIBLE=NO
/CATEGORIES VARIABLES=Q6 EMPTY=INCLUDE TOTAL=YES LABEL= "N=" POSITION=
BEFORE
/CATEGORIES VARIABLES=Total EMPTY=INCLUDE TOTAL=No LABEL= " " POSITION=
BEFORE
/categories variables=Q6 [0 thru 10, &T2B, &T4B] total=NO
/COMPARETEST TYPE=PROP ADJUST=NONE ALPHA=.05
/TITLES
TITLE=")TABLE".

Here is the test data set

Test_Data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Data.sav>

Here is the test output file
Test_Output.xlsx
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Output.xlsx>

Regards
SAT

--
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

--
Jon K Peck
[hidden email]

Jeanne Eidex

Re: How to generate top 2 and top 4 box for 10 Point scale question with compare test...

It looks like there is an error in your variable labels because you have labeled q6_1 as both top-2 and top-4 box instead of labeling q6_7 as top-4 box.

Jeanne

Get Outlook for iOS

From: SPSSX(r) Discussion <[hidden email]> on behalf of Satish Gusain <[hidden email]>
Sent: Tuesday, October 27, 2020 5:40:39 AM
To: [hidden email] <[hidden email]>
Subject: Re: How to generate top 2 and top 4 box for 10 Point scale question with compare test...

Hi Jon,

Thanks for your reply, I tried the same and it's working with T2B box but not with top 4 box there is some error of duplication.

Regards

On Tue, 20 Oct 2020 at 01:50, Jon Peck <[hidden email]> wrote:

Your total variable is not in that data file, but computed categories are not used in tests. You might try using SUBTOTAL or HSUBTOTAL instead.

On Mon, Oct 19, 2020 at 1:46 PM Satish <[hidden email]> wrote:

Hi Guyes,

I need your support how to generate top 2 box and top 4 box for 10 point
scale question. I have searched a lot on portal but not able to see as per
my requirement.

I am using this syntax and i am getting data correctly as well but i noticed
that i am not getting compare test value in table.

CTABLES
/pcompute &T2B = expr([9] + [10])
/pproperties &T2B label = "% Top 2 box" hidesourcecats=no
format=COLPCT.COUNT
/pcompute &T4B = expr([7] + [8] + [9] + [10])
/pproperties &T4B label = "% Top 4 box" hidesourcecats=no
format=COLPCT.COUNT
/VLABELS VARIABLES=Q6 DISPLAY=None
/TABLE
Q6[C] [COLPCT.COUNT '' F40.0,TOTALS[COUNT"" F40.0]] by
Total [C]+Q1 [C]+Q2 [C]
/SLABELS POSITION=ROW VISIBLE=NO
/CATEGORIES VARIABLES=Q6 EMPTY=INCLUDE TOTAL=YES LABEL= "N=" POSITION=
BEFORE
/CATEGORIES VARIABLES=Total EMPTY=INCLUDE TOTAL=No LABEL= " " POSITION=
BEFORE
/categories variables=Q6 [0 thru 10, &T2B, &T4B] total=NO
/COMPARETEST TYPE=PROP ADJUST=NONE ALPHA=.05
/TITLES
TITLE=")TABLE".

Here is the test data set

Test_Data.sav
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Data.sav>

Here is the test output file
Test_Output.xlsx
<http://spssx-discussion.1045642.n5.nabble.com/file/t341630/Test_Output.xlsx>

Regards
SAT

--
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

--

Jon K Peck
[hidden email]