|Page tools: Print Page Print All|
TableBuilder includes a number of continuous variables which can have a response value at any point along a continuum. Some continuous data items are allocated special codes for certain responses (e.g. 9999 = 'Not applicable'). When creating ranges in TableBuilder for such continuous items, special codes will automatically be excluded. Therefore the total will show only 'valid responses' rather than all responses (including special codes).
The following shows the tabulation of the data items 'Number of times participated in sport/physical recreation as a player in the last 12 months' by 'Sex of person'. The continuous values of the data item are contained in the 'A valid response was recorded' row. To show the actual continuous values in a table, a range must be created.
Here is the same table with a range applied for the continuous values for the data item 'Number of times participated in sport/physical recreation as a player in the last 12 months' (SportExample). Note that the numbers of respondents for the 'Don't know' category no longer contribute to the table.
Any special codes for continuous data items are listed in the Data Item List.
FIELD EXCLUSION RULES
To ensure confidentiality, TableBuilder prevents the cross-tabulation of certain variables which could result in respondents being identified. These are known as field exclusion rules. If field exclusion rules exist for certain variables, users will see the following message: “Maximum number of fields in exclusion group exceeded.”ADJUSTMENT OF CELL VALUES
The TableBuilder dataset has random adjustment of cell values applied to avoid the release of identifiable data. All cells in a table are adjusted to prevent any identifiable data being exposed. For this dataset 'additivity' has not been applied, that is, when the interior cells are randomly adjusted they have not been set to add up to the totals. As a result, randomly adjusted individual cells will be consistent across tables, but the totals in any table will not be the sum of the individual cell values.ZERO VALUE CELLS
Tables generated from sample surveys will sometimes contain cells with zero values because no respondents that satisfy the parameters of the cell were in the survey. This is despite there being people in the population with those characteristics. That is, the cell may have had a value above zero if all persons in scope of the survey had been enumerated. This is an example of sampling variability which occurs with all sample surveys. Relative Standard Errors cannot be generated for zero cells. Whilst the tables may include cells with zero values, the ABS does not publish such zero estimates in Participation in Sport and Physical Recreation, Australia, 2011–12 (cat. no. 4177.0) and recommends that TableBuilder clients do not use these data either.MULTI–RESPONSE DATA ITEMS
A number of the survey's data items allow respondents to provide more than one response. These are referred to as 'multi–response data items'. An example of such a data item is shown below. For this data item respondents can report all types of facilities they have used for sport/physical recreation activity in the last 12 months.
As a result, each person in the appropriate population is counted at least once, and some persons are counted multiple times. Therefore, the total for a multiple response data item will be less than or equal to the sum of its components. Multi–response data items can be identified by the initials 'MR' in the data item list, which can be accessed from the Downloads page. In the example below, the sum of the components is 27,428,100 whereas the total population is 18,059,700.
These documents will be presented in a new window.