Contingency Table Output - How to get just the Chi-squared, df, p-value data table?

Hi all -

Currently, when you run the Contingency Table for 2 variables and request to 'Include Chi-Squared Statistic' it doesn't provide you with an output of these values in the 'D' data output. You can, however, see the outputs in the 'R' report output; but, these are at the bottom of the formatted report and not simple to extract.

Also, any way to output the critical values from this node as well? (or another.. any way other than manually pairing in the upper and lower limit tables?)

I did download the 'Chi Square Test Macro' but unfortunately get a different degree of freedom and different output for chi square result than when I compute manually and further differs from that of the 'Contingency Table' output.

Thank you for any input!

Prescriptive Analytics

Accepted answers

Aguisande

Hi asibley,

Inside the Contingency Table macro, on Summarize Tool (94), I believe you can extract the chi-square.

Just output a macro output to this tool and you'll have the value.

I recommend to work on a copied version of the Contingency Table Macro (and it's dependencies: \Supporting_Macros\PivotTable.yxmc and \Supporting_Templates\PivotTable_Template.html)

All comments

Aguisande

Hi asibley,

Inside the Contingency Table macro, on Summarize Tool (94), I believe you can extract the chi-square.

Just output a macro output to this tool and you'll have the value.

I recommend to work on a copied version of the Contingency Table Macro (and it's dependencies: \Supporting_Macros\PivotTable.yxmc and \Supporting_Templates\PivotTable_Template.html)

JasonH123

Hi Could you show more detail how to replicate the macro and modify it?

I do open the Macro and find Summarize(94), but when I try to close it after I add Macro output it denies me...

123.PNG

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335