1406.0.55.005 - TableBuilder, User Guide  
Latest ISSUE Released at 11:30 AM (CANBERRA TIME) 15/12/2016   
   Page tools: Print Print Page Print all pages in this productPrint All RSS Feed RSS Bookmark and Share Search this Product

OPTIONS

Using the Options button at the top of the table area in the Table View users can set:
Zero suppression - set for rows, columns or both
Percentages - show none, row, column, or totals as percentages
Relative standard error (where available) - display counts, RSEs or both.

Image: Table options button with selections


ZERO SUPPRESSION

The zero suppression options are designed to help users reduce noise in tables to focus on the most relevant cells of the table. When zero suppression is enabled, TableBuilder automatically removes rows and columns that contain only zeros. This can be particularly useful for very large tables with small values, as it can reduce the size of the table significantly, making it easier to focus on the results.

To activate or deactivate zero suppression, select the Rows and/or Columns options from the Options menu at the top of the table.
Image: Option for Zero suppression of rows and/or columns

If wafers are included in a table, then TableBuilder determines whether to suppress a row or column by looking at the entire cube, not just the currently visible wafer. A row or column will only be suppressed if it contains only zeros on all of the wafers. This means that rows and columns with all zero values will still appear in the table if a row or column only contains zeros on the current wafer, but has values on at least one of the other wafers.

For example, without zero suppression this table has 13 columns and 9 rows.
Image: Table without zero suppression

With zero suppression enabled, TableBuilder automatically removes all the columns that have only zeros in them. This reduces the number of columns down to 11, by removing Not applicable and Not determined. The row count remains the same even though row suppression is enabled because this table does not have any rows that only have zero values.
Image: Table with zero suppression


PERCENTAGES

Use the option at the top of the table area to change the values in the table to percentages. The percentages option can be set to show percentages for rows, columns, totals or no percentages (none).
Image: Options for percentages in table

Percentages are calculated differently based on the option selected.
Option
Description
Example
NoneDo not show percentages.Image: not showing percentages
ColumnReplace the values in the table with a percentage of the total in each column.Image: Replace the values in the table with a percentage of the total in each column
RowReplace the values in the table with a percentage of the total in each row.Image: Replace the values in the table with a percentage of the total in each row
TotalReplace the values with a percentage of the grand total.
If you are using wafers then this will show the total percentage across all the wafers.
Image: Replace the values with a percentage of the grand total

Some of the percentage options are not available for certain types of table. For example, the Total percentage option is not available when the table contains multiple summation options. Percentages are also not supported when opening a saved system table that was originally created in SuperCROSS and that contains grand totals generated by SuperCROSS.
RELATIVE STANDARD ERROR

Some datasets, including Census TableBuilder datasets, are not weighted so the relative standard error (RSE) options do not apply. RSEs are available for survey-based datasets that are subject to sampling variability. Further information about interpreting RSEs is available in the Relative standard error section.

The RSE options allow users to include RSE figures for their current table. Using the Options button at the top of the table area, users can display the data counts only (Summation), RSEs only or a combination of both.
Image: Options for relative standard error

Table displaying counts initially, user selects Summation + RSE option.
Image: Selecting option for Summation + RSE

The table then displays counts and RSEs.
Image: Table showing summation + RSE

User selects RSE option.
Image: Selecting RSE option

Table displays RSEs only.
Image: Table displaying RSEs only