This spreadsheet replicates selected data tables from theACT & Queanbeyan Household Travel Survey dashboard.
Please refer to the attached spreadsheet on this page.
About the Public Transport theme
In this theme, a focus is placed on public transport - the trips made by bus or light rail.
- School bus travel is included in the 'bus' category
- Light rail was not available as a mode in 2017, with services only commencing in 2019.
The data summarised is of public transport trips, rather than boardings. If someone caught two buses, or both a bus and light rail on the same trip, only a single public transport trip is recorded. Furthermore, if someone used public transport and another mode (for example, other trip legs made by driving, walking or cycling), the trip will only be recorded as public transport if this was also the longest distance leg.
Note that the tables provided represent a small subset of data available. Use of the dashboard or raw survey datasets allow more complex descriptions of travel to be developed.
Source data
The data shown is not a Census of travel, but a large survey of several thousand households from across the ACT and Queanbeyan. As with any survey there will be some variability in the accuracy of the results, and how well they reflect the movement of the entire population. For instance, if the survey were to be completed on another day, or with a different subset of households, the results would be slightly different.
Interpretations of the data should keep this variability in mind: these are estimates of the broad shape of travel only. Even for the same person, travel behaviour will vary according to many factors: day of week, month of year, season, weather, school holidays, illness, family responsibilities, work from home opportunities, etc. Again, by summarising the travel of many different people, the data provides a view of average weekday patterns.
In interpreting the data, it is worth noting the following points:
- A zero cell does not necessarily mean the travel is never made, but rather that the survey participants did not make this travel on their particular survey day.
- Values are rounded, and may not sum to the totals shown.
The small sample size (approximately 1 per cent) of people who either did not report their gender, or who did not identify as male or female, prevented their analysis as a distinct cohort group. Responses from these participants have been randomly allocated to the male and female groups.
Household income quartiles are derived by a summation of individual income ranges. As no adjustment has been made for household size, single person households are over-represented in the lowest income quartile.
An employment status of 'Not in workforce' is only applied to children. Retired people will be classed as 'Not employed'.
The survey is described on the Transport Canberra and City Services' website:
[Household Travel Survey homepage]
Cell annotations and notes
Some cells have annotations added to them, as follows:
* : Statistically significant difference across survey years (at the 95% confidence level). Confidence intervals indicate where the true measure would typically fall if the survey were repeated multiple times (i.e., 95 times out of 100), recognising that each survey iteration may produce slightly different outcomes.
~ : Unreliable estimate (small sample or wide confidence interval)
'o' is an indicative survey estimate only - reliability statistics have not been calculated for the variables shown
Additional information
Analysis by Sift Research, March 2025.
Contact research@sift.group for further information.
Enclosed data tables shared under a 'CC BY' Creative Commons licence. This enables users to distribute, remix, adapt, and build upon the material in any me
