Custom Age Tool for 2011 Census Population, Borough and Ward

Excel Age-Range creator for 2001 and 2011 Census population figures.

2011 Census custom age tool

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. This is for local authorities and higher geographies only.
Download from ONS website

Data and Resources

Additional Info

Field Value
Author Office for National Statistics
Maintainer Opinion Research and General Statistics (GLA)
bounding_box Greater London
conformity
conformity_degree
created_date
dp_created 2013-02-01T10:51:37
dp_modified 2013-11-15T15:13:26
email_notify_author true
email_notify_maintainer true
license_text
lineage
odi-certificate
or_author
or_distributor
or_originator
or_owner
or_point_of_contact
or_principal_investigator
or_processor
or_publisher
or_resource_provider
or_responsible_party_role
or_user
revision_date
smallest_geography Ward
spatial_resolution
spatial_resource_language
spatial_resource_type
temporal_coverage_from 06/10/2014
temporal_coverage_to 06/10/2014
topic_category
update_frequency Ad hoc