Sig T in Custom Tables

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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
Reply | Threaded
Open this post in threaded view
|

Re: Sig T in Custom Tables

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 &lt; sGRIDYRET&gt; for &lt;sGRIDYCAT&gt; , 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 &lt; sGRIDYRET&gt; for &lt;sGRIDYCAT&gt; , 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 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