cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
jmpvmd
Level II

How to determine differences between each pair of categorical data with 3+ groups

Hi!

 

I feel my question is pretty straight forward. How can I determine differences between each pair of categorical data with 3+ groups?

I have two categorical variables:

1) Type of Grant (Grant 1, Grant 2, Grant 3, & Grant 4)

2) Professorship (Assistant professor, associate professor, full professor)

 

I can use Fit Y by X and get a significant Chi Square value between the two.... But how can I tell where this differences lies? For example, how do I know if grant 3 is significantly more likely to have associate professors compared to grant 2, or that grant 1 is significantly more likely to have full professors than all of the other grants?

 

If I make professorship a numerical variable, I can get comparisons and a p value for each pair, is this how it should be done?

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions

Re: How to determine differences between each pair of categorical data with 3+ groups

Click the red triangle next to Contingency and select Correspondence Analysis.You only have two variables so it reduces to a one-dimensional plot. You will see the association between levels.

 

Here is mock data to illustrate.

 

Screen Shot 2020-06-28 at 8.52.16 AM.png

 

Here is the initial analysis as you describe.

 

Screen Shot 2020-06-28 at 8.52.50 AM.png

 

Here is the addition of the correspondence analysis.

 

Screen Shot 2020-06-28 at 8.53.04 AM.png

 

So in this mock up, Assistant is associated with Grants 1 and 2, Associate is associated with Grant 4, and Full is associated with Grant 3.

 

You can read more about correspondence analysis in Help > JMP Documentation Library > Basic Analysis guide > Contingency Analysis chapter.

 

Note that there is a richer platform, Analyze > Multivariate Methods > Multiple Correspondence Analysis available. It is described in Help > JMP Documentation Library > Multivariate Methods guide > Multiple Correspondence Analysis chapter

View solution in original post

1 REPLY 1

Re: How to determine differences between each pair of categorical data with 3+ groups

Click the red triangle next to Contingency and select Correspondence Analysis.You only have two variables so it reduces to a one-dimensional plot. You will see the association between levels.

 

Here is mock data to illustrate.

 

Screen Shot 2020-06-28 at 8.52.16 AM.png

 

Here is the initial analysis as you describe.

 

Screen Shot 2020-06-28 at 8.52.50 AM.png

 

Here is the addition of the correspondence analysis.

 

Screen Shot 2020-06-28 at 8.53.04 AM.png

 

So in this mock up, Assistant is associated with Grants 1 and 2, Associate is associated with Grant 4, and Full is associated with Grant 3.

 

You can read more about correspondence analysis in Help > JMP Documentation Library > Basic Analysis guide > Contingency Analysis chapter.

 

Note that there is a richer platform, Analyze > Multivariate Methods > Multiple Correspondence Analysis available. It is described in Help > JMP Documentation Library > Multivariate Methods guide > Multiple Correspondence Analysis chapter