OCR Mathematics A H240 — large data set for June 2027

The accompanying h240-2027-lds.xlsx is the original OCR workbook. Its Information sheet gives the source definitions. The separate source-information text is a readable extraction of that sheet. The workbook contains four tables of 348 local authorities in England and Wales: travel to work and age structure in 2001 and 2011. ONS combined the 2001 authorities to the 2011 geography so the same areas can be compared. Use geography codes to match rows, rather than assuming that names or positions match.

Travel values are counts of employed residents. Use the named employment total as the denominator when finding the proportion travelling by a particular method; the whole population is a different denominator. The usual travel method is the longest part of the journey by distance. Columns move between years, including taxi, so identify each variable by its header. The 2011 non-employment count is in column Q in this workbook, with P blank.

Age-band entries are counts; mean and median age are measured in years. Age means age at the last birthday. Every mean/median-age cell in the 2001 table is blank because these measures are unavailable after amalgamation. A blank is not a zero. Grouped midpoints can give an estimated mean when the necessary grouped data are supplied, but they do not reconstruct an exact median. Check the different oldest age groups before comparing tables.

The original 2001 travel table contains one literal '-' for the Isles of Scilly underground/metro/light rail/tram count. Preserve the source workbook. If an investigation treats it as zero, state and justify that cleaning decision; otherwise use complete observations for the named variables. Never silently replace unavailable ages by zero. Save a separate working copy for filtering, calculations and charts, and record any transformations and the number of observations used.

Source: OCR's fixed H230/H240 census large data set, checked against specification version 3.1 (August 2026) for June 2027. Census sources include CT0015EW, KS15, KS102EW and KS02. The workbook attributes ONS/Crown copyright under Open Government Licence v3.0.
Original release: https://www.ocr.org.uk/Images/308727-units-h230-and-h240-large-data-set-lds-sample-assessment-material.xlsx
Original workbook SHA-256: 7f4fc7f40ec1f0dc6b37f819ca53fb744aeb8509f853dd23241c4e0dfb98b0f9