Next
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 column means test example :
row/cols. This is in the form nxy, where n represents the category row (the first category row is 1, the second category row is 2, etc.) and x and y are the IDs of the pair of columns.
pval. The p value.
tval. The t value.
dof. The degrees of freedom.
se. The standard error.
sig. The significance level chosen for the test.
m1, m2. The means in the two columns.
xx1, xx2. The weighted sum of squared values in each column (Y i).
x1, x2. The weighted sum of values in each column (X i).
n1, n2. The weighted count of cases in the mean row in each column (w i).
e1, e2. The effective base in the two columns. These are the same as the bases if the effective base option was not used.