In this article
The Distributions tab .- contains a number of properties that enable you to define the type of numerical presentation used in the table. You can select any combination of counts (the actual number of responses), horizontal and/or vertical percentages, and an additional selectable value. Percentage values can be presented with or without the % character. Each table cell is divided into one, two or four fields depending on the number of data items selected, with one field allocated to each item.
Figure 1 - The Distributions tab properties
- Use Innermost Totals as Base - the default behavior for calculating percentages is based on the overall total for the table. Check this option to obtain percentages calculated for the sub-totals of the nested questions in the specific columns or rows.
- Additional Statistic - select from the drop-down list an additional statistic to be displayed in the lower-right field of each row/column cell - field D in the illustration below. The data selected for display in this cell can be used in a chart as the Distribution (go to Distribution for more information). Note that the position of the field in the cell will depend on which other data items are selected. The options are:
- None - the field is empty.
- Affinity - affinity index statistic is displayed.
- Table Percent - the field displays the percentage value of the count in each cell against the total count for the entire table.
- Chi Square - shows the Chi Square cell value for a table cell (go to Chi-Square Significance Statistic for more information).
Note: To assist the viewer, the distribution statistics displayed in the table can be listed in the meta data below the table. The text lists the data displayed in the grid cells in "top-left > top-right > bottom-left > bottom-right" order. To display this text, go to the Meta Data tab and select Distribution (go to Meta Data for more information).
The figure here shows an example of a table where counts (A), horizontal percents (B) and vertical percents (C) are selected. "None" is selected for the Additional Statistic cell D. The vertical percents are set up so that they will be easy to compare by browsing vertically through the table and the horizontal percents so that they will be easy to compare by browsing horizontally through the table. The count is placed in the upper left corner of each data point.
Figure 2 - Example of a table showing counts, horizontal and vertical percents
If you wish to display the percentage values without the percent character (%), check the Hide Percent Sign box.