|
<< Click to Display Table of Contents >> Navigation: Reference Manual > Windows and dialog boxes > Tables Global > Tables global |
This will appear when Global tables is requested from the Data drill down window.
These settings affect all tables produced.
You can choose to produce a single sheet in the spreadsheet report instead of a separate sheet for each table.
You can suppress the colouring of cells in spreadsheet output that show significance differences from the "rest" (total column minus column being tested).
You can set the decimal places to be used for figures:
•Weighted figures when one or more weights have been applied
•Percentages
•Means
Unweighted figures (not percentages) are always shown as whole numbers.
You can decide whether to show the "Missing", "Count" and "Effective sample size" figures.
"Effective sample size" (ESS) will only show on weighted tables.
You can decide to suppress blank (empty) rows and columns.
You can set the column widths for row labels and table columns.
Use the "Significance testing formats" button to control the Significance formats for testing against the total column and against other columns. The type of tests selected will also be used for any distinction analysis.
Columns that are "significantly different" to the total column (using the chosen SIG and TTV settings) can be coloured green for higher and red for lower. Note this is "numerically" higher and lower, not necessarily green "better" and red "worse".
If column identifiers have been used, then columns that are significantly higher than other the other columns being tested against can be marked. Note that only the numerically higher columns are marked.
When hovering over cells in a table you can ask to see:
•Confidence intervals for percentages. Note that percentages must be shown for this to appear
•Actual significant percentages for all column markers when the percentage of over 50%
When hovering the actual significance percentage against the total column will always show if it is over 50%
Columns markers can be separated by full stops (dots) to make them easier to read.
The significance testing formats chosen will also be used in distinction analysis.
Set the lowest significance level to check for.
Set the maximum rows to display.
Choose whether to exclude empty entries.