This spreadsheet replicates selected data tables from the ACT & Queanbeyan Household Travel Survey dashboard.
Please refer to the attached spreadsheet on this page.
About the Active Travel theme
Active travel relates to any trips made by walking or cycling.
While active transport is often used to describe the combined benefits of walking and cycling, the willingness and opportunity to use either mode will naturally differ depending on the person and their travel context.
As expected, this theme highlights that there is a much higher proportion of walk trips compared to bicycle. Closer examination of the data also reveals socio-demographic variability in active travel choices. For example, two-thirds of cycling trips are made by males.
As well as trip counts, data is also summarised by trip percentages. This can be the mode share for each analysis group (e.g., holding each cohort constant, such as 'all females', and examining their use of walking compared to cycling) or the use of each mode across groups (e.g., holding mode constant, such as 'all walk trips', and examining the distribution of these across males and females). Both summaries are provided on separate tabs.
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.
Trip time periods are assigned using the mid point of travel:
- AM peak (8am to 9am), PM peak (5pm to 6pm), Interpeak (9am to 5pm), Off-peak (after 6pm)
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.
~ : Un
