Categorical Report - Weighted? Cell Chisq Pval Coloring?

Question

Two questions regarding the Categorical Report under the Consumer Research Option. 1. Is there a way to add a Weight variable to the Categorical analysis as you would in the Fit Y by X and Fit Model analyses? 2. Within the same analysis, I'm confused how to interpret the cell chisq pval (values and colors) on their own and in relation to the LR and Pearson pvalue. The cell pvalues don't seem to be significant (they are much higher than 0.05 and 0.1 even) but they are still in light red/blue. Also, the LR/Pearson pvalue is <0.05 so I understand that the test is significant but again I'm still confused how this relates back to the non-significant cell chisq pvalues. Any help would be greatly appreciated!

dale_lehman · Answer

Well, thanks, I just learned something new.  I never used the Consumer Research platform for this analysis.  When you use Fit Y by X, you don't get the option for the individual cell p values.  Now, if only someone would respond to the questions about weights.

pmasui · Answer

Thanks for the response. I was referring to the cell chi squared pvalues explained from the JMP help source: https://www.jmp.com/support/help/en/15.2/index.shtml#page/jmp/example-of-the-cell-chisq-test.shtml#. Here it walks through how to view the pvalues for the individual cells when comparing observed vs expected counts.

dale_lehman · Answer

I may be able to help with one part of your question, and I want to expand upon a second.  As for the cell chi squared values, I am not aware that you see any p values for the individual cells.  The cell chi squared value is computed as the cell deviation from the expected (under the null hypothesis of no association) squared and divided by the expected number.  These cell chi squared values are then summed for the hypothesis test, which does give a p value.  So, if your chi squared test shows a significant association, then I don't think there is any way to map that back into the individual cells that cause that - it is a property of all the cells together (of course, looking at how the row/column percentages vary suggests where the largest differences lie).

Your other question about weights relates to a question I posed last week, which nobody responded to.  It appears that weights and frequencies are interchangeable in the fit Y by X platform for nominal variables.  Of course, the statistical properties (such as confidence intervals) are greatly affected.  If the weights are such as those found in Census Bureau surveys, the confidence intervals are artificially narrow when using the weights (as weights or frequencies, since they have the same impact).  But the descriptive statistics, I believe, are more accurate when the weights are used than if they are left out.  What puzzles me (and was my question last week) is that the weight variable is ignored in the Analyze Distribution platform.  Why?  And, why is it used in Fit Y by X but not in Analyze distribution.  In Analyze distribution, if you put the weight variable as a frequency, then it affects (properly) the results, but is ignored if used as a weight variable.  So, I am confused about the differential treatment of weights and frequencies in the two platforms.