Excel Age-Range creator for 2001 and 2011 Census population figures.
This Excel-based tool enables users to query the single year of age raw data so that any age range can easily be calculated without having to carry out often complex, and time consuming formulas that could also be open to human error.
Simply select the lower and upper age range for both males and females and the spreadsheet will return the total population for the range.
This file uses the single year of age data from the 2011 Census released on 24 September 2012, which was available for all Local Authorities.
The ward data is currently modelled data for sex, based on single year of age data from Table qs103ew. The final data will be inserted into the tool when it is released in summer 2013.
Also included are the 2001 Census figures for comparison.
This tool was created by the GLA Intelligence Unit.
A seperate Custom Age-Range Tool for Census 2011 Workday population is available below. This is for local authorities and higher geographies only.
Download data from ONS website