« Return to Thread: Testing the significant difference in Proportions

Re: Testing the significant difference in Proportions

by eins :: Rate this Message:

Reply to Author | View in Thread

Hi Jims, Bruce, et al,
 
Jims More wrote:

>
> I have two categorical variables.  One is the response variable, a yes/no
> variable.  The other is a categorical predictor variable which has 5
> categories.  The proportion table of the gathered data (n=5000) looks like
> as follows:
>
>                          Row % of Yes Response           Row % of No
> Response
> Category1                .40                                    .60
> Category2                .30                                    .70
> Category3                .80                                     20
> Category4                .40                                    .60
> Category5                .34                                    .66
>
> How to test using SPSS if the proportions of Yes and No are significantly
> equal for each category?
>
> Thank you for any help.
> Jims
>
Bruce replied:

You can always roll your own, like this:

data list list / cat (f2.0) x N (2f6.0).
begin data
1 40 100
2 30 100
3 80 100
4 40 100
5 34 100
end data.

compute p = x/N.
compute se = SQRT( p*(1-p)/N).
compute z = (p - .5)/se.
compute pvalue = 2*(1-(CDF.NORMAL(abs(z),0,1))) .
format se pvalue (f5.3).
list.

You'll have to fill in the correct values of X and N, of course.
Can someone translate the syntax of Bruce into syntax that do the same but for SPSS data file with variables(predictor and dependent) in the columns.
 
Thank you.
Eins


Have a new Yahoo! Mail account?
Kick start your journey by importing all your contacts!

 « Return to Thread: Testing the significant difference in Proportions