4177.0.55.002 - Microdata: Participation in Sport and Physical Recreation, Australia, 2011-12 Quality Declaration 
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 09/05/2013   
   Page tools: Print Print Page Print all pages in this productPrint All

Header picture USING TABLEBUILDER


INTRODUCTION
CONTINOUS DATA ITEMS
FIELD EXCLUSION RULES
ADJUSTMENT OF CELL VALUES
ZERO VALUE CELLS
MULTI–RESPONSE DATA ITEMS


INTRODUCTION

For general information relating to the TableBuilder or instructions on how to use features of the TableBuilder product, please refer to the User Manual: TableBuilder, 2013 (cat. no. 1406.0.55.005).

More detailed information relating to survey methodologies, such as the counting units and weights applied to the TableBuilder dataset, are explained in the Survey methodology section.

The TableBuilder dataset contains all of the person and activity level data applicable to the Participation in Sport and Physical Recreation topic. Information on the structure is provided in the File structure section.

CONTINUOUS DATA ITEMS

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).

For example:

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.

Screenshot from TableBuilder - number of times participated in sport or physical recreation as a player by sex

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.

Screenshot from TableBuilder - number of times participated in sport or physical recreation as a player in ranges by sex

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.

Screenshot from TableBuilder - categories for the data item "Facilities used for participation in sport or physical recreation in last 12 months"

When a multiple response data item is tabulated, a person is counted against each response they have provided (e.g. a person who used "outdoor sports facilities" and "off-road cycleways or bike paths" will be counted one time in each of these two categories).

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.

Screenshot from TableBuilder - table containing the data item "Facilities used for participation in sport or physical recreation in last 12 months"