When you run a statistical test on a table, IBM® SPSS® Data Collection Survey Reporter can create diagnostics information that shows the p values and some of the intermediate figures used to calculate the statistics. The information is in comma-delimited format, so you can open it in Microsoft Excel and perform calculations on the data. The information varies according to the test. Here is the information for the chi-square test example :
formula. Displays the name of the formula used.
rows/cols. These indicate the category rows and columns that the test was performed on.
chisqd. The chi-square value.
chidof. The degrees of freedom.
pval. The p value.
The above example uses the Pearson test. When the Yates' correction is used, the following columns are also present:
absterm. The absolute value of the product of one diagonal minus the product of the other diagonal. When the absterm value is less than the halfsum value, the Yates' value is not calculated and the chi-square value is set to zero.
halfsum. Half the sum of frequencies in all the cells.
fisher2. The two-tailed probability of chi-square as calculated by Fisher's exact test.
fisher1. The one-tailed probability of chi-square as calculated by Fisher's exact test.