Desktop User Guides > Professional > Table scripting > Statistical tests > Diagnostics information
Diagnostics information
When you run a statistical test on a table, you can optionally write out UNICOM Intelligence Professional 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 diagnostics file contains information for each table that contains a statistical test. The first line of the section describes the table, whether there is overlap in the columns tested, whether the table is weighted or unweighted, and whether the effective base was used. This is followed by additional information for each test.
The first column indicates the type of test:
CHI. The chi-square test and/or Fisher's exact test.
CPT. The column proportions test.
CMN. The column means test.
NTP. The net difference test for a category row.
NTM. The net difference test for a mean row.
PPT. The paired preference test.
The remaining information is different for each test.
You can write the diagnostics information to a text file using script similar to the following:
'Enable the generation of diagnostics information for the statistical test
TableDoc.RawStatisticsDataEnabled = True
'Create and populate the tables as required
' Write out the diagnostics information for the statistical tests
Dim fso, txtfile
Set fso = CreateObject("Scripting.FileSystemObject")
Set txtfile = fso.CreateTextFile("StatisticalTestsDiagnostics.csv", True)
Giving the text file a .csv filename extension makes it easy to subsequently open the file in Excel.
For details of how to view diagnostics information, see Viewing diagnostics information for statistical tests.
See also
Diagnostics information: Chi-square test
Diagnostics information: Cell chi-square test
Diagnostics information: Column proportions test
Diagnostics information: Column means test
Diagnostics information: Net difference test
Diagnostics information: Paired preference test
Diagnostics information: Tukey test
Statistical tests