In this example, a D'Agostino and Pearson test analysis is performed on the fictitious banking data to analyze account usage.
-
Parameterize a D'Agostino and Pearson Test analysis as follows:
- Available Tables — twm_customer_analysis
- Column of Interest — income
- Group By Columns — years_with_bank
-
Analysis Parameters
- Threshold Probability — 0.05
- Run the analysis.
-
Click Results when complete.
For this example, the D'Agostino and Pearson Test analysis generated the following table. The D'Agostino and Pearson Test was computed for each distinct value of the group by variable “years_with_bank”. Results were sorted by years_with_bank. The tests show the user that all incomes were not normally distributed except those from years_with_bank = 9. ‘p’ means significantly nonnormal and an ‘a’ means accept the null hypothesis of normality.The SQL is available for viewing but not listed below.
D'Agostino and Pearson Test: Output Columns years_with_bank T Zkurtosis Zskew ChiPValue ChiPText ChiCallP_0.05 0 29.05255 2.71261 4.65771 0.0001 <0.0001 p 1 34.18025 3.30609 4.82183 0.0001 <0.0001 p 2 30.71123 2.78588 4.79062 0.0001 <0.0001 p 3 32.81104 3.06954 4.83621 0.0001 <0.0001 p 4 82.01928 5.72010 7.02137 0.0001 <0.0001 p 5 62.36861 4.91949 6.17796 0.0001 <0.0001 p 6 24.80241 2.40521 4.36089 0.0001 <0.0001 p 7 17.72275 1.83396 3.78937 0.00019 p 8 6.55032 -0.23415 2.54863 0.03992 p 9 3.32886 -0.68112 1.69261 0.20447 a