Sig T in Custom Tables

[Arora, Manoj (IMDLR)]

Hi All,

 

I need help of calculating Sig T in Custom Tables.

 

I have a categorical variable with 10 categories and I want to calculate the Sig T of these categories with All Total of these. Is it possible to do so in SPSS CTABLES, if yes please suggest.

 

I have done the same in the below tables but it is not calculating problem. What algorithm SPSS use to calculate the Sig T.

 

I want to calculate the SiG T between Total Online and brand-1 to brand-4

 

 

			Beauty
			brand-1	brand-2	brand-3	brand-4	Total Online	brand-5	brand-6	brand-7	Total Offline	Total Category (Total Online + Total Offline)
Look and feel of the website/app : Q4X1_1: Q4 Again, thinking about when you shopped at < sGRIDYRET> for <sGRIDYCAT> , how satisfied were you with the following attributes. Please use a scale from 0 to 10, where 0 is ‘Extremely dissatisfied’ an	Answering Base	Count	147	128	113	117	505	0	0	0	0	505
	Top 3	Count	107	109	83	77	376	0	0	0	0	376
		Column N %	72.8%	85.8%	72.8%	65.6%	74.4%	0.0%	0.0%	0.0%	0.0%	74.4%
	Rest	Count	40	18	31	40	129	0	0	0	0	129
		Column N %	27.2%	14.2%	27.2%	34.4%	25.6%	0.0%	0.0%	0.0%	0.0%	25.6%
Comparisons of Column Proportionsc,d,e
		Beauty
		brand-1	brand-2	brand-3	brand-4	Total Online	brand-5	brand-6	brand-7	Total Offline	Total Category (Total Online + Total Offline)
		(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
Look and feel of the website/app : Q4X1_1: Q4 Again, thinking about when you shopped at < sGRIDYRET> for <sGRIDYCAT> , how satisfied were you with the following attributes. Please use a scale from 0 to 10, where 0 is ‘Extremely dissatisfied’ an	Top 3		D E J				.a,b	.a,b	.a,b	.a,b
	Rest				B	B	.a,b	.a,b	.a,b	.a,b	B
Results are based on two-sided tests with significance level .05. For each significant pair, the key of the category with the smaller column proportion appears under the category with the larger column proportion.
a. This category is not used in comparisons because the sum of case weights is less than two.
b. This category is not used in comparisons because its column proportion is equal to zero or one.
c. Tests are adjusted for all pairwise comparisons within a row of each innermost subtable using the Bonferroni correction.
d. Cell counts of some categories are not integers. They were rounded to the nearest integers before performing column proportions tests.
e. Comparisons are not performed for some pairs where compared categories of a multiple response set contain identical sets of observations.

 

 

Regards

Manoj

 

Kantar Disclaimer ===================== 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]

I don't quite understand what you mean, but you can specify CATEGORIES=SUBTOTALS on the COMPARETEST subcommand to use the subtotals in the test in place of the categories they subtotal.

If that doesn't solve the problem, please post a more detailed explanation.

On Thu, Jan 17, 2019 at 4:05 AM Arora, Manoj (IMDLR) <[hidden email]> wrote:

Hi All,

 

I need help of calculating Sig T in Custom Tables.

 

I have a categorical variable with 10 categories and I want to calculate the Sig T of these categories with All Total of these. Is it possible to do so in SPSS CTABLES, if yes please suggest.

 

I have done the same in the below tables but it is not calculating problem. What algorithm SPSS use to calculate the Sig T.

 

I want to calculate the SiG T between Total Online and brand-1 to brand-4

 

 

			Beauty
			brand-1	brand-2	brand-3	brand-4	Total Online	brand-5	brand-6	brand-7	Total Offline	Total Category (Total Online + Total Offline)
Look and feel of the website/app : Q4X1_1: Q4 Again, thinking about when you shopped at < sGRIDYRET> for <sGRIDYCAT> , how satisfied were you with the following attributes. Please use a scale from 0 to 10, where 0 is ‘Extremely dissatisfied’ an	Answering Base	Count	147	128	113	117	505	0	0	0	0	505
	Top 3	Count	107	109	83	77	376	0	0	0	0	376
		Column N %	72.8%	85.8%	72.8%	65.6%	74.4%	0.0%	0.0%	0.0%	0.0%	74.4%
	Rest	Count	40	18	31	40	129	0	0	0	0	129
		Column N %	27.2%	14.2%	27.2%	34.4%	25.6%	0.0%	0.0%	0.0%	0.0%	25.6%
Comparisons of Column Proportionsc,d,e
		Beauty
		brand-1	brand-2	brand-3	brand-4	Total Online	brand-5	brand-6	brand-7	Total Offline	Total Category (Total Online + Total Offline)
		(A)	(B)	(C)	(D)	(E)	(F)	(G)	(H)	(I)	(J)
Look and feel of the website/app : Q4X1_1: Q4 Again, thinking about when you shopped at < sGRIDYRET> for <sGRIDYCAT> , how satisfied were you with the following attributes. Please use a scale from 0 to 10, where 0 is ‘Extremely dissatisfied’ an	Top 3		D E J				.a,b	.a,b	.a,b	.a,b
	Rest				B	B	.a,b	.a,b	.a,b	.a,b	B
Results are based on two-sided tests with significance level .05. For each significant pair, the key of the category with the smaller column proportion appears under the category with the larger column proportion.
a. This category is not used in comparisons because the sum of case weights is less than two.
b. This category is not used in comparisons because its column proportion is equal to zero or one.
c. Tests are adjusted for all pairwise comparisons within a row of each innermost subtable using the Bonferroni correction.
d. Cell counts of some categories are not integers. They were rounded to the nearest integers before performing column proportions tests.
e. Comparisons are not performed for some pairs where compared categories of a multiple response set contain identical sets of observations.

 

 

Regards

Manoj

 

Kantar Disclaimer

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

... [show rest of quote]

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