Script to join sigficance to number

[Manmit Shrimali-2]

Hello Team:

I often have to run several custom tables daily along with comparing
columns means and column proportion stat testing (with and without
Bonferroni correction). Let say I am generating mean of coke consumption
for over period of four years. Output will be as follows:

Year1 Year2 Year3 Year4
 40     60      70    87

Stat testing:

Comparisons of Column Means(a)
        Year1 Year2 Year3 Year4
        (A)     (B)     (C)     (D)

             A           C

Results are based on two-sided tests assuming equal variances with
significance level 0.01667.

Is there any script that directly sticks the significance to the value?
Aimed output:

Year1 Year2 Year3 Year4
 40     60A      70    87C

Any inputs are highly appreciated.

Manmit

[Peck, Jon]

If you have SPSS 14 with programmability installed, there is a mergeTables module available on SPSS Developer Central (www.spss.com/devcentral) that merges tables.  It requires certain other downloadable modules that are described with that module.

The module was inspired by this exact problem, but its capabilities are more general than this particular merge.

HTH,
Jon Peck
SPSS


-----Original Message-----
From: SPSSX(r) Discussion on behalf of Manmit Shrimali
Sent: Sat 9/30/2006 11:16 PM
To: [hidden email]
Subject:      [SPSSX-L] Script to join sigficance to number
 
Hello Team:

I often have to run several custom tables daily along with comparing
columns means and column proportion stat testing (with and without
Bonferroni correction). Let say I am generating mean of coke consumption
for over period of four years. Output will be as follows:

Year1 Year2 Year3 Year4
 40     60      70    87

Stat testing:

Comparisons of Column Means(a)
        Year1 Year2 Year3 Year4
        (A)     (B)     (C)     (D)

             A           C

Results are based on two-sided tests assuming equal variances with
significance level 0.01667.

Is there any script that directly sticks the significance to the value?
Aimed output:

Year1 Year2 Year3 Year4
 40     60A      70    87C

Any inputs are highly appreciated.

Manmit

[Manmit Shrimali-2]

Thanks Jon. Unfortunately I have never used programmability function.
Can you please give me more information. To make things complicate, I
currently have spss 13, we r in process of upgrading but not sure how
concrete it is.

Thanks

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Peck, Jon
Sent: Sunday, October 01, 2006 7:58 PM
To: [hidden email]
Subject: Re: Script to join sigficance to number

If you have SPSS 14 with programmability installed, there is a
mergeTables module available on SPSS Developer Central
(www.spss.com/devcentral) that merges tables.  It requires certain other
downloadable modules that are described with that module.

The module was inspired by this exact problem, but its capabilities are
more general than this particular merge.

HTH,
Jon Peck
SPSS


-----Original Message-----
From: SPSSX(r) Discussion on behalf of Manmit Shrimali
Sent: Sat 9/30/2006 11:16 PM
To: [hidden email]
Subject:      [SPSSX-L] Script to join sigficance to number

Hello Team:

I often have to run several custom tables daily along with comparing
columns means and column proportion stat testing (with and without
Bonferroni correction). Let say I am generating mean of coke consumption
for over period of four years. Output will be as follows:

Year1 Year2 Year3 Year4
 40     60      70    87

Stat testing:

Comparisons of Column Means(a)
        Year1 Year2 Year3 Year4
        (A)     (B)     (C)     (D)

             A           C

Results are based on two-sided tests assuming equal variances with
significance level 0.01667.

Is there any script that directly sticks the significance to the value?
Aimed output:

Year1 Year2 Year3 Year4
 40     60A      70    87C

Any inputs are highly appreciated.

Manmit

[Peck, Jon]

Until you have SPSS 14 or 15 and have installed programmability and downloaded the modules from SPSS Developer Central, you cannot use this approach.  Once you have gotten to that stage, you could do something like this.

Run your Ctables command.

Run this program:

begin program.
import spss, spssaux, tables

tables.mergeLatest(label='Count', mode='merge')
end program.

That code copies the test results into the main table and hides the test table.

There are more elaborate things you can do with this module, but simple things are ... simple.

HTH,
Jon Peck
SPSS

-----Original Message-----
From: Manmit Shrimali [mailto:[hidden email]]
Sent: Sunday, October 01, 2006 6:52 PM
To: Peck, Jon; [hidden email]
Subject: RE: Re: Script to join sigficance to number

Thanks Jon. Unfortunately I have never used programmability function.
Can you please give me more information. To make things complicate, I
currently have spss 13, we r in process of upgrading but not sure how
concrete it is.

Thanks

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of
Peck, Jon
Sent: Sunday, October 01, 2006 7:58 PM
To: [hidden email]
Subject: Re: Script to join sigficance to number

If you have SPSS 14 with programmability installed, there is a
mergeTables module available on SPSS Developer Central
(www.spss.com/devcentral) that merges tables.  It requires certain other
downloadable modules that are described with that module.

The module was inspired by this exact problem, but its capabilities are
more general than this particular merge.

HTH,
Jon Peck
SPSS


-----Original Message-----
From: SPSSX(r) Discussion on behalf of Manmit Shrimali
Sent: Sat 9/30/2006 11:16 PM
To: [hidden email]
Subject:      [SPSSX-L] Script to join sigficance to number

Hello Team:

I often have to run several custom tables daily along with comparing
columns means and column proportion stat testing (with and without
Bonferroni correction). Let say I am generating mean of coke consumption
for over period of four years. Output will be as follows:

Year1 Year2 Year3 Year4
 40     60      70    87

Stat testing:

Comparisons of Column Means(a)
        Year1 Year2 Year3 Year4
        (A)     (B)     (C)     (D)

             A           C

Results are based on two-sided tests assuming equal variances with
significance level 0.01667.

Is there any script that directly sticks the significance to the value?
Aimed output:

Year1 Year2 Year3 Year4
 40     60A      70    87C

Any inputs are highly appreciated.

Manmit