In this example, a Chi Square test analysis is performed on the fictitious banking data to analyze account usage.
-
Parameterize a Chi Square Test analysis as follows:
- Available Tables — twm_customer_analysis
- First Columns — female, single
- Second Columns — svacct, ccacct, ckacct
-
Analysis Parameters
Threshold Probability — 0.05
- Run the analysis.
-
Click Results when it completes.
For this example, the Chi Square Test analysis generated the following table. The Chi Square Test was computed on all combinations of pairs of the two sets of variables. Results were sorted by column1 and column2. The tests shows that probabilities observed are the same for three pairs of variables and different for three other pairs. A ‘p’ means significantly different and an ‘a’ means not significantly different.The SQL is available for viewing but not listed below.
Chi Square Test (Part 1) column1 column2 Chisq DF Z CramersV PhiCoeff LlhChiSq female ccacct 3.2131312 1 1.480358596 0.065584911 0.065584911 3.21543611 female ckacct 8.2389731 1 2.634555949 0.105021023 0.105021023 8.23745744 female svacct 3.9961257 1 1.716382791 0.073140727 0.073140727 3.98861957 single ccacct 6.9958187 1 2.407215881 0.096774063 0.096774063 7.01100739 single ckacct 0.6545145 1 0.191899245 0.02960052 0.02960052 0.65371179 single svacct 1.5387084 1 0.799100586 0.045385576 0.045385576 1.53297321 Chi Square Test (Part 2) column1 column2 ContAdjChiSq ContinCoeff ChiPValue ChiPText ChiCallP_0.05 female ccacct 2.954339388 0.065444311 0.077657185 a female ckacct 7.817638955 0.10444661 0.004512106 p female svacct 3.697357526 0.072945873 0.046729867 p single ccacct 6.600561728 0.096324066 0.00854992 p single ckacct 0.536617115 0.029587561 0.25 >0.25 a single svacct 1.35045989 0.045338905 0.226624385 a