For indicators within Community Insight, data for stock groups is created in the following way;
- For stock groups where an entire Lower Layer Super Output Area (LSOA) is within the boundary of the stock group, the data value for this whole area is included.
- For stock groups where part of an LSOA is within the boundary of the stock group, the data is apportioned down to Output Area (OA) level. Output Areas are included into the stock group if more than 50% of the residential postcodes within that OA reside within the stock group area.
This is done in different ways, depending upon what level the data is published to (eg OA or LSOA level):
- When data is available to OA level: We use the actual OA counts in these cases. For example, this is the case for Census data, and also for Police.uk and Land Registry data which are published to point (postcode or lat/longitude) level.
- When data is not available to OA level: As we do not know the exact data value for the OAs, we apportion the published data to OA level. Population data from the census is available down to OA level and we use this data to get a weighting for each OA, by calculating the population of the OA divided by the population of the LSOA (or whatever area-types for which the data is published). We then apply this weighting to approximate the data value for the OAs.
Finally, the data for the stock group is created by summing up the data for the Output Areas and/ or LSOAs as per above.
Rate / percentage data is created by carrying out the above process separately for both the numerators and denominators, and using these to calculate the stock group rate / percentage.
For more information about Output Areas check out this page created by the Office of National Statistics
If you have ideas on how this process could be improved, please let us know!