Chi-Square Analysis: WHERE is it in JMP?

[#1]

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.

[#2 · Accepted solution]

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

Help > Search the Help

Enter Chi-Square and hit Enter.

[#3]

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

[#4]

Can you post some of your data?

[#5]

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

[#6]

smoore2,

Is this what you were trying to do?

[#7]

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.

[#8]

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

[#9]

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.

[#10]

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