turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Chi-Square Analysis: WHERE is it in JMP?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 21, 2014 9:26 AM
(3130 views)

Chi-Square Analysis: WHERE is it in JMP? Pretty simple in other software, but I would like to do it in JMP. I have data to determine if certain departments have disproportionately high injury rates compared to the overall rate. A goodness-of-fit exercise.

Steve

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Solution

Did you search the help in JMP? Found it in 2 seconds.

Help > Search the Help

Enter Chi-Square and hit Enter.

13 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Did you search the help in JMP? Found it in 2 seconds.

Help > Search the Help

Enter Chi-Square and hit Enter.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 21, 2014 10:55 AM
(2270 views)

Yes, I did try the help, but did not get to what I was specifically looking for :-(

Steve

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 21, 2014 11:33 AM
(2270 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 21, 2014 11:59 AM
(2270 views)

Here's what I am trying to get JMP to do for me (done in Excel): Calculated the Chi-Square Stats for each department and total:

Dept | Staff Level | Observed Injuries | Staff Proportion | Expected Injuries | Expected-Observed | (Expected-Obs)^2 | Chi-Squared |

A | 53 | 1 | 0.125 | 7.63 | 6.63 | 43.9 | 5.76 |

B | 12 | 5 | 0.028 | 1.73 | -3.27 | 10.7 | 6.21 |

C | 46 | 13 | 0.108 | 6.62 | -6.38 | 40.7 | 6.15 |

D | 78 | 14 | 0.184 | 11.22 | -2.78 | 7.7 | 0.69 |

E | 91 | 17 | 0.215 | 13.09 | -3.91 | 15.3 | 1.17 |

F | 37 | 3 | 0.087 | 5.32 | 2.32 | 5.4 | 1.01 |

G | 29 | 3 | 0.068 | 4.17 | 1.17 | 1.4 | 0.33 |

H | 29 | 3 | 0.068 | 4.17 | 1.17 | 1.4 | 0.33 |

I | 49 | 2 | 0.116 | 7.05 | 5.05 | 25.5 | 3.62 |

Totals | 424 | 61 | 1.000 | 61 | Total Chi-Sq = | 25.26 |

Steve

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 21, 2014 1:11 PM
(2270 views)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 21, 2014 1:54 PM
(2270 views)

I believe Lou has the proper approach. However, his example included the full raw data table for the different departments. Just in case you had summarized data (as presented in the sample data you provided), you would want to conduct your analysis using Frequency variables. I have included that example here.

Dan Obermiller

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 22, 2014 4:05 AM
(2270 views)

Dan and Lou,

Thanks for your help. I was having difficult switching the method of data entry from the way I was doing with another software package.

Best regards,

Steven

Steve

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 22, 2014 6:05 AM
(2270 views)

Steven,

No problem....Thank you for being so open to share the data. It was an excellent opportunity to refresh my understanding of JMP for your application.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Aug 22, 2014 6:41 AM
(2270 views)

I actually think the format of the summary data in Steven's Excel spreadsheet is not that unusual. And I don't think it is always realistic to change the data entry format just to suit the idiosyncrasies of a particular analysis method. Which leaves (imho) contingency analysis languishing in Fit Y By X as the poor cousin to Bivariate and Oneway. It's tempting (especially for me) to write an add-in to deal with this problem, but it seems so basic and central to data analysis that JMP should deal with this. We have very powerful tools such as STACK and SPLIT that allow common data structures to be reshaped for particular methods of analysis. Is there not scope for a tool for reshaping of frequency-type data e.g. from Steve's format to DanO's ?

Dave

-Dave