- Thread starter mizansiddiqis
- Start date

Is this for a class or real-life project? Examples, https://pareonline.net/getvn.asp?v=20&n=8

https://help.xlstat.com/customer/en...-chi-square-and-fisher’s-exact-tests-in-excel

It might be more simple than the very accurate and complete article by Donald Sharpe quoted in the previous post.

As you have a cell with 5 individuals which is the known limit to use the chi-square test, you might want to use the Monte Carlo or Fisher exact tests. I let you run the tests, but the Fisher exact test gives a higher p-value.

Is this for a class or real-life project? Examples, https://pareonline.net/getvn.asp?v=20&n=8

Age group

<15 15-44 45+

Female

Count 41 39 5

Expected Count 45.0 31.3 8.8

Residual -4.0 7.7 -3.8

Standardized R -.6 1.4 -1.3

Adjusted R -1.3

Male

Count 41 18 11

Expected Count 37.0 25.7 7.2

Residual 4.0 -7.7 3.8

Standardized R -.7 -1.5 1.4

Adjusted R 1.3

df p

Pearson Chi-Square 8.616 2

Likelihood Ratio 8.774 2 0.12

Age group

<15 15-44 45+

Female

Count 41 39 5

Expected Count 45.0 31.3 8.8

Residual -4.0 7.7 -3.8

Standardized R -.6 1.4 -1.3

Adjusted R -1.3

Male

Count 41 18 11

Expected Count 37.0 25.7 7.2

Residual 4.0 -7.7 3.8

Standardized R -.7 -1.5 1.4

Adjusted R 1.3

df p

Pearson Chi-Square 8.616 2

Likelihood Ratio 8.774 2 0.12

df p

Pearson Chi-Square 8.616 2** 0.13 **

Likelihood Ratio 8.774 2 0.12

Pearson Chi-Square 8.616 2

Likelihood Ratio 8.774 2 0.12

meaning that one cannot reject the null hypothesis: "the distribution of sexes is the same in each age group"

(or "the distribution of age groups is the same for each sex", respectively). Therefore, post-hoc analyses

would usually not be performed.

By the way, it is unclear (at least for me) what you want to find out. Your analysis concerns whether the

distribution of sexes is the same over 3 age groups, irrespective of whether there are more men than women

(or vice versa). Your questions, though, seem to suggest that you want to know in which age groups there

are significantly more men than women (or more women than men). But maybe this is a misunderstanding

from my side.

With kind regards

Karabiner

Female

Count 41 39 5

Expected Count 45.0 31.3 8.8

Residual -4.0 7.7 -3.8

Standardized R -.6 1.4 -1.3

Adjusted R -1.3 2.6 -2.0

Male

Count 41 18 11

Expected Count 37.0 25.7 7.2

Residual 4.0 -7.7 3.8

Standardized R -.7 -1.5 1.4

Adjusted R 1.3 -2.6 -2.0

df 2

Pearson Chi-Square 8.616 2

p value .013

Likelihood Ratio 8.774 2 0.12

"I am trying to find out which group is significant." is not a research

question. Do you want to find out in which age groups

there are significantly more men than women (or more women than men),

i.e. significant deviations from 50%/50%?

Or do you want to find out in which age group men are underrepresented

(or over-represented), i.e. in which certain age groups the proportion

of men is larger than overall?

With kind regards

Karabiner