COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

### help with testing whether there is significance difference between the proportions or not

• Email
• Follow

```I realy need help. Let say I have data as below,  where each row
denotes a company(case).
I want to test whether there is significance difference between the
proportions of gender or not according to characteristic of
companies.
How can I test this with SPSS? Which test should I use and how? If you
help me, I will be very glad. Thanks a lot.

company        "characteristic"      "no of female"         "no of
male"
--------------------------------------------------------------------------------------------------
1                    a
25                        35
2                    a
32                        54
3                    b
25                        45
4                    b
36                        52
5                    b
78                        65
6                    b
45                        62
7                    c
15                        18
8                    c
78                        92

```
 0
Reply oercim 2/21/2011 11:14:51 PM

See related articles to this posting

```On 21/02/2011 6:14 PM, oercim wrote:
> I realy need help. Let say I have data as below,  where each row
> denotes a company(case).
> I want to test whether there is significance difference between the
> proportions of gender or not according to characteristic of
> companies.
> How can I test this with SPSS? Which test should I use and how? If you
> help me, I will be very glad. Thanks a lot.
>
> company        "characteristic"      "no of female"         "no of
> male"
> --------------------------------------------------------------------------------------------------
> 1                    a
> 25                        35
> 2                    a
> 32                        54
> 3                    b
> 25                        45
> 4                    b
> 36                        52
> 5                    b
> 78                        65
> 6                    b
> 45                        62
> 7                    c
> 15                        18
> 8                    c
> 78                        92
>
>

Line-wrap is making your table hard to read.  I think you meant it to
look like this (use fixed font like Courier to make it line up):

Co Char F    M
----------------
1   a   25   35
2   a   32   54
3   b   25   45
4   b   36   52
5   b   78   65
6   b   45   62
7   c   15   18
8   c   78   92

I *think* that what you you're asking is how to crosstabulate
Characteristic and Sex.  If so, you would need to have two rows per
Company*, with variables indicating Characteristic, Sex, and the count
for that combination.  Like this:

Co Char Sex Kount
1   1    1   25
1   1    2   35
2   1    1   32
2   1    2   54
etc
8   3    1   78
8   3    2   82

(Notice that I used 1-3 for the characteristic codes rather than a-c.
Generally, it's better to use numeric variables where possible--this
gives you more flexibility in how you can use the variable.)

Then use the WEIGHT command to "weight by kount" before running the
Crosstab.

weight by Kount.
crosstabs char by sex / stat = chisq.

* Actually, you would need two rows for each Characteristic; but then
you would need the counts of males and females across all companies with
that characteristic.

If this is not what you wanted, please clarify your question.

--
Bruce Weaver
"When all else fails, RTFM."
```
 0
Reply Bruce 2/21/2011 11:41:30 PM

```On Feb 22, 1:41=A0am, Bruce Weaver <bwea...@lakeheadu.ca> wrote:
> On 21/02/2011 6:14 PM, oercim wrote:
>
>
>
>
>
>
>
>
>
> > I realy need help. Let say I have data as below, =A0where each row
> > denotes a company(case).
> > I want to test whether there is significance difference between the
> > proportions of gender or not according to characteristic of
> > companies.
> > How can I test this with SPSS? Which test should I use and how? If you
> > help me, I will be very glad. Thanks a lot.
>
> > company =A0 =A0 =A0 =A0"characteristic" =A0 =A0 =A0"no of female" =A0 =
=A0 =A0 =A0 "no of
> > male"
> > -----------------------------------------------------------------------=
---- -----------------------
> > 1 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0a
> > 25 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A035
> > 2 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0a
> > 32 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A054
> > 3 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0b
> > 25 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A045
> > 4 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0b
> > 36 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A052
> > 5 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0b
> > 78 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A065
> > 6 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0b
> > 45 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A062
> > 7 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0c
> > 15 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A018
> > 8 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0c
> > 78 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A092
>
> Line-wrap is making your table hard to read. =A0I think you meant it to
> look like this (use fixed font like Courier to make it line up):
>
> Co Char F =A0 =A0M
> ----------------
> 1 =A0 a =A0 25 =A0 35
> 2 =A0 a =A0 32 =A0 54
> 3 =A0 b =A0 25 =A0 45
> 4 =A0 b =A0 36 =A0 52
> 5 =A0 b =A0 78 =A0 65
> 6 =A0 b =A0 45 =A0 62
> 7 =A0 c =A0 15 =A0 18
> 8 =A0 c =A0 78 =A0 92
>
> I *think* that what you you're asking is how to crosstabulate
> Characteristic and Sex. =A0If so, you would need to have two rows per
> Company*, with variables indicating Characteristic, Sex, and the count
> for that combination. =A0Like this:
>
> Co Char Sex Kount
> 1 =A0 1 =A0 =A01 =A0 25
> 1 =A0 1 =A0 =A02 =A0 35
> 2 =A0 1 =A0 =A01 =A0 32
> 2 =A0 1 =A0 =A02 =A0 54
> etc
> 8 =A0 3 =A0 =A01 =A0 78
> 8 =A0 3 =A0 =A02 =A0 82
>
> (Notice that I used 1-3 for the characteristic codes rather than a-c.
> Generally, it's better to use numeric variables where possible--this
> gives you more flexibility in how you can use the variable.)
>
> Then use the WEIGHT command to "weight by kount" before running the
> Crosstab.
>
> weight by Kount.
> crosstabs char by sex / stat =3D chisq.
>
> * Actually, you would need two rows for each Characteristic; but then
> you would need the counts of males and females across all companies with
> that characteristic.
>
> If this is not what you wanted, please clarify your question.
>
> --
> Bruce Weaver
> "When all else fails, RTFM."

Yes, that is what I want. But I have the data inputed. And it is a
large data set(hundreds of cases-I won't do that just for gender, also
for education level, etc). So it is very difficult to make two rows
manually for each chrasteristic. Is there a short way to make prepare
this data? Thanks a lot .
```
 0
Reply oercim 2/21/2011 11:54:47 PM

```On Feb 22, 1:54=A0am, oercim <oer...@yahoo.com> wrote:
> On Feb 22, 1:41=A0am, Bruce Weaver <bwea...@lakeheadu.ca> wrote:
>
>
>
>
>
>
>
>
>
> > On 21/02/2011 6:14 PM, oercim wrote:
>
> > > I realy need help. Let say I have data as below, =A0where each row
> > > denotes a company(case).
> > > I want to test whether there is significance difference between the
> > > proportions of gender or not according to characteristic of
> > > companies.
> > > How can I test this with SPSS? Which test should I use and how? If yo=
u
> > > help me, I will be very glad. Thanks a lot.
>
> > > company =A0 =A0 =A0 =A0"characteristic" =A0 =A0 =A0"no of female" =A0=
=A0 =A0 =A0 "no of
> > > male"
> > > ---------------------------------------------------------------------=
------ -----------------------
> > > 1 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0a
> > > 25 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A035
> > > 2 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0a
> > > 32 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A054
> > > 3 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0b
> > > 25 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A045
> > > 4 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0b
> > > 36 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A052
> > > 5 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0b
> > > 78 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A065
> > > 6 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0b
> > > 45 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A062
> > > 7 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0c
> > > 15 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A018
> > > 8 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0c
> > > 78 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A092
>
> > Line-wrap is making your table hard to read. =A0I think you meant it to
> > look like this (use fixed font like Courier to make it line up):
>
> > Co Char F =A0 =A0M
> > ----------------
> > 1 =A0 a =A0 25 =A0 35
> > 2 =A0 a =A0 32 =A0 54
> > 3 =A0 b =A0 25 =A0 45
> > 4 =A0 b =A0 36 =A0 52
> > 5 =A0 b =A0 78 =A0 65
> > 6 =A0 b =A0 45 =A0 62
> > 7 =A0 c =A0 15 =A0 18
> > 8 =A0 c =A0 78 =A0 92
>
> > I *think* that what you you're asking is how to crosstabulate
> > Characteristic and Sex. =A0If so, you would need to have two rows per
> > Company*, with variables indicating Characteristic, Sex, and the count
> > for that combination. =A0Like this:
>
> > Co Char Sex Kount
> > 1 =A0 1 =A0 =A01 =A0 25
> > 1 =A0 1 =A0 =A02 =A0 35
> > 2 =A0 1 =A0 =A01 =A0 32
> > 2 =A0 1 =A0 =A02 =A0 54
> > etc
> > 8 =A0 3 =A0 =A01 =A0 78
> > 8 =A0 3 =A0 =A02 =A0 82
>
> > (Notice that I used 1-3 for the characteristic codes rather than a-c.
> > Generally, it's better to use numeric variables where possible--this
> > gives you more flexibility in how you can use the variable.)
>
> > Then use the WEIGHT command to "weight by kount" before running the
> > Crosstab.
>
> > weight by Kount.
> > crosstabs char by sex / stat =3D chisq.
>
> > * Actually, you would need two rows for each Characteristic; but then
> > you would need the counts of males and females across all companies wit=
h
> > that characteristic.
>
> > If this is not what you wanted, please clarify your question.
>
> > --
> > Bruce Weaver
> > "When all else fails, RTFM."
>
> Yes, that is what I want. But I have the data inputed. And it is a
> large data set(hundreds of cases-I won't do that just for gender, also
> for education level, etc). So it is very difficult to make two rows
> manually for each chrasteristic. Is there a short way to make prepare
> this data? Thanks a lot .

Thanks a lot. I found the solution. Restructure is done my work. Again
thanks alot. It was very useful for me
```
 0
Reply oercim 2/22/2011 12:52:17 AM

3 Replies
288 Views

Similar Articles

12/1/2013 3:23:58 PM
page loaded in 1135095 ms -1