

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 brand1 to brand4

Beauty

brand1

brand2

brand3

brand4

Total Online

brand5

brand6

brand7

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 Proportions^{c,d,e}



Beauty


brand1

brand2

brand3

brand4

Total Online

brand5

brand6

brand7

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 twosided 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 SPSSXL, send a message to
[hidden email] (not to SPSSXL), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSXL
For a list of commands to manage subscriptions, send the command
INFO REFCARD


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 brand1 to brand4

Beauty

brand1

brand2

brand3

brand4

Total Online

brand5

brand6

brand7

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 Proportions^{c,d,e}



Beauty


brand1

brand2

brand3

brand4

Total Online

brand5

brand6

brand7

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 twosided 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 SPSSXL, send a message to
[hidden email] (not to SPSSXL), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSXL
For a list of commands to manage subscriptions, send the command
INFO REFCARD

=====================
To manage your subscription to SPSSXL, send a message to
[hidden email] (not to SPSSXL), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSXL
For a list of commands to manage subscriptions, send the command
INFO REFCARD

