6227.0.30.001 - Microdata: Education and Work, May 2019 Quality Declaration 
ARCHIVED ISSUE Released at 11:30 AM (CANBERRA TIME) 13/11/2019   
   Page tools: Print Print Page Print all pages in this productPrint All

Using TableBuilder


TableBuilder User Guide

The TableBuilder User Guide provides you with information about how to create basic tables, custom groups, graphs and large tables. It also includes practical examples and video tutorials.

Weights

When tabulating data in TableBuilder, person weights are automatically applied to the underlying sample counts. Weighting is the process of adjusting results from a sample survey to infer results for the total population. To do this, a 'weight' is allocated to each sample unit. The weight is the value that indicates how many population units are represented by the sample unit.

Not Applicable Categories

Most data items included in the TableBuilder file include a 'Not applicable' category. The classification values of these 'Not applicable' categories, where relevant, are shown in the data item list in the Downloads tab. The 'Not applicable' category generally represents the number of people who were not asked a particular question or the number of people excluded from the population for a data item when that data was derived (e.g. Year of Arrival in Australia is not applicable for people born in Australia).

Table Populations

The population relevant to each data item is identified in the data item list and should be kept in mind when extracting and analysing data. The actual population estimate for each data item is equal to the total cumulative frequency minus the 'Not applicable' category.

Generally, all populations, including very specific populations, can be 'filtered' using other relevant data items. For example, if the population of interest is 'Employed persons', any data item with that population (excluding the 'Not applicable' category) could be used. While any applicable data item can be used for this filtering process, the SEW TableBuilder also includes some data items that have been specifically derived for this purpose. For example, the population data item 'P07. Persons aged 15–24 years' can be used to filter this population rather than the actual age group data item. The specifically derived population data items are listed in the data item list and are included in the 'Population data items' folder in the TableBuilder product.

The purpose of the population data item 'P16. Non-Indigenous flag' is to assist users in producing non-indigenous data only. It should not be used to estimate for the Indigenous population through differencing, as the scope of the SEW excludes persons living in Indigenous communities.

Continuous data items

The SEW TableBuilder includes several continuous variables:

  • They can have a response value at any point along a continuum.
  • Some continuous data items are allocated special codes for certain responses (e.g. 000 = '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).
  • Continuous items with special codes have a corresponding categorical item on the Person level that provides the ability to display data for the special code.
  • Any special codes for continuous data items are listed in the Data Item List on the Downloads tab.

Confidentiality

A confidentiality process called perturbation is applied to the data in TableBuilder to avoid releasing information that may lead to the identification of individuals, families, households, dwellings or businesses. See Confidentiality in the TableBuilder user guide.