This web page is a 'rapid distribution' vehicle for a number of statistical briefs and Excel-based data tools dealing with labour force status and employment indicators for the State of Queensland and its Statistical Regions. The data products were developed by the Queensland Labour Economics Office for users with an interest in state and regional labour markets. The group of data products linked from this page are those that are updated on a monthly or quarterly basis using published data from the Australian Bureau of Statistics.
State-level 'Headline' Labour Force Status
This brief in MS Word format is produced each month with the release of 'headline' seasonally adjusted and trend labour force data by the ABS. The brief contains data at the State level on a range of basic labour force indicators, presented in a number of tables and time series charts. Comparisons with the corresponding national figures are given in some cases.
Monthly labour force brief (Word) (494.0KB)
A full set of the key seasonally adjusted and trend labour force status indicators for Queensland and Australia is available from the following link. The format is a simple Excel spreadsheet showing current values and monthly and annual change.
Detailed Summary Tables (Excel) (47.0KB)
Regional Labour Force Indicators
The main Excel data tool linked below is based on the monthly 'Detailed Release' of labour force data by the ABS. It is based on original (ie unadjusted) data on a full range of basic labour force indicators, including local unemployment rates, down to the level of Statistical Areas, Level 4 (SA4s). The 'detailed release' follows one week after the release of 'headline' seasonally adjusted and trend data at State level.
The Excel workbook presents the key regional data in a set of standard tables and a selectable range of comparison charts and time series charts. Both three month averaging and 12 month averaging of original data are available and are used to reduce unacceptable levels of sampling volatility in the original data series, especially for small regions. To use the selectable charting functions in this workbook, you must have macros enabled.
Three month averages have the advantage of a much sharper time focus, but have higher relative sampling errors, while seasonal influences can be very significant in some data series. Twelve month averages are less volatile and mostly suppress seasonal influences. They are therefore more reliable for looking at longer term developments in local labour markets. Averaging over 12 months, however, only gives an overall outcome for the whole preceding year.
The present regional structure used in the Labour Force Survey was introduced by the ABS in January 2014 and represented a complete break from the previous geographical system. Fortunately, ABS has provided users with a set of 'official' historical series backcast all the way to October 1998.
Regional labour force statistics (Excel) (1.1MB)
For those interested in regional labour force status indicators by age group, the following simple Excel spreadsheet has 'current values' for a full range of basic indicators by standard age groups. All Queensland regions are included, along with State and Australian comparison values. Because of the extreme sampling volatility in some regional age group data, only 12 month averaging is used in this data product.
Regional Labour Force Survey data by age groups (Excel) (277.2KB)
Regional Industry of Employment Data
This is an Excel-based data tool containing data on broad industries of employment at the regional level. It presents 'industry of employment' data in selectable graphs and tables for each of the Statistical Areas, Level 4 (SA4s) in Australia, as well as state, territory, national and capital city/balance of state totals. It is updated each quarter when the ABS releases new industry data. SA4s are the same areas used in the main monthly regional labour force data release and form part of the Australian Statistical Geography Standard used in the 2011 Census.
This data tool allows users to choose between five different 'profile' charts and tables for any selected region or industry by selecting from any of the following topics: employment levels by industry; employment growth by industry over one or five years; the percentage contribution of each industry to employment in the region, and the percentage of national employment within the region for each industry. Macros must be enabled for it to work and the area of interest selected from the drop-down list.
In line with the ABS data source, data used in the profile charts and tables have been averaged over four quarters to minimise the volatility seen in results for single quarters. For example, 'One Year Employment Growth' represents the difference between the average of the original Labour Force Survey estimates over four quarters to the current quarter and the average over the preceding four quarters. This comes at the cost of a loss of sharp time focus in what can be a rapidly changing labour market.
A time series chart of annual average employment by industry over fourteen years can also be produced for any selected region and any selected industry. Because the ABS has not published original industry employment estimates for May 2000, the four quarters affected by this have all been set to zero for all regions and all industries.
Regional Industry Tool (Excel) (4.7MB)
Detailed Industry and Occupation (State Level)
These are two Excel-based tools containing data on the number of people employed in Queensland as a whole in particular detailed industries and occupations of employment. The data are presented as time series charts of the numbers employed over the last seven years. These tools are updated each quarter when the ABS releases new data.
Industries of employment are broken down to the Group level (ie 3-digit codes) of the ANZSIC 2006 classification system, while the occupations of employed people are broken down to the Unit Group (ie 4-digit codes) of the ANZSCO First Edition classification system. Macros must be enabled for these Excel tools to work and the industry or occupation of interest must be selected from the drop-down list.
Original data from the Quarterly Labour Force Survey have been used in these workbooks (plotted as a thin blue line) but the charts include a moving average trendline over the preceding four quarters (the thicker red line) which often gives a better indication of longer term movements in the number of people employed. The degree of 'jaggedness' in the blue line gives a rough visual indication of the potential scale of the sampling errors involved, and hence the reliability of the numbers. Generally, only large occupations/industries, or groupings of them, produce resonably reliable results.
Detailed industry of employment (Excel) (305.6KB)
Detailed occupation of employment (Excel) (389.9KB)