|Page tools: Print Page Print All|
USING THE TABLEBUILDER
The purpose of the population data item "Non-Indigenous flag" is to assist users in producing non-Indigenous data only. It should not be used to estimate Aboriginal and Torres Strait Islander populations through differencing, as the scope of the National Health Survey excludes Very Remote areas of Australia and discrete Aboriginal and Torres Strait Islander communities.
Note on Continuous Items
Some continuous data items are allocated special codes for certain responses (e.g. 9999 = 'Not applicable'). When creating ranges for such continuous items for use in the TableBuilder, these special codes will NOT be included in these ranges. Any special codes for continuous (summation) data items are listed in the Data Item List (DIL) and will be found in the categorical version of the continuous item. However, note that labelling of '0's in the DIL does not necessarily mean they are excluded from the ranges (for example - identifying 0 as 'Did not visit' or 'Did not do') as they may still be important in some calculations. Reference should be made to the categorical version of the item to identify which codes are specifically excluded. Therefore the total shown only represents 'valid responses' of that continuous data item rather than all responses (including special codes).
'Systolic blood pressure' is located both in the Selected Persons level folder...
...and the Summation Options.
The following table shows the responses for 'Systolic Blood Pressure' by 'Sex of person'. The continuous values of the data item are contained in the 'A valid response was recorded' row. If the actual continuous values are to be displayed, it is necessary to create a range for them. For information on constructing ranges, see the User Manual: TableBuilder, Jun 2013 (cat. no. 1406.0.55.005).
To minimise the risk of identifying individuals in aggregate statistics, a technique is used to randomly adjust cell values. This technique is called perturbation. Perturbation involves small random adjustments of the statistics and is considered the most satisfactory technique for avoiding the release of identifiable statistics while maximising the range of information that can be released. These adjustments have a negligible impact on the underlying pattern of the statistics.
The introduction of these random adjustments results in tables not summing to totals. While some datasets apply a technique called additivity to give internally consistent results, additivity has not been implemented on this TableBuilder. 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. The size of the difference between summed cells and the relevant total will generally be very small.
Please be aware that the effects of perturbing the data may result in components being larger than their totals. This includes determining proportions.
Some tables generated within TableBuilder may contain a substantial proportion of very low contributors within cells (excluding cells that have counts of zero). When this occurs, all values within the table are suppressed in order to preserve confidentiality. The following error message is displayed at the bottom of the table when table suppression has occurred.
ERROR: The table has been suppressed as it is too sparse
ERROR: table cell values have been suppressed
Two benchmarked weights are provided with the NHS TableBuilder: ‘Households’ and ‘Selected persons (3)’. ‘Selected persons (3)’ is the default summation, which means that this weight is automatically added to the row of any table. In TableBuilder, these weights can be found under the Summation Options category in the left hand pane. TableBuilder only allows one weight to be used at a time.
When analysing a Household level item, you may want to change the summation weight from selected persons to households - for example, if you wanted to know the number of households in a state, rather than the number of persons living in that state. In this case you would add the weight called ‘Households’ from the Summation Options heading. Similarly, the ‘Selected persons (3)’ weight can be found there as well.
Caution should be used when applying the ‘Household’ weight to items from other levels. For example, if the household weight is applied to a selected person level demographic item, such as ‘Sex’, your table will show the number of households with one or more selected persons of that sex. Since up to two people can be selected in the NHS, this will result in some households being counted twice, once for females and once for males.
These documents will be presented in a new window.