# Sig T in Custom Tables

2 messages
Open this post in threaded view
|

## Sig T in Custom Tables

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

## Re: Sig T in Custom Tables

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

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