Where MCS Installer Records Are Located: A Geographic Distribution Study

1. Background and scope

A table of installer locations can answer where records are associated with a geographic label. It cannot by itself answer where installers work, how quickly an installation can be delivered or whether local demand is adequately served. A registered or contact address may be distant from the areas served by a business.

The unit of comparison is determined by the source field selected at runtime. A county comparison and a country comparison represent different geographic scales. The chart therefore names the actual field instead of presenting every result as a regional distribution. This report avoids mapping unstandardised text onto official boundaries.

2. Findings and visualisations

The results below are calculated from the latest available source analysis. The methodology and discussion describe how to interpret them; numerical claims appear only after the results have loaded.

3. Methods

1. Use all non-empty source rows as the denominator. Select the first available supported field using region, county, country and local authority as the priority order. The selection is based on field names, not on the statistical balance of the resulting categories.
2. Trim leading and trailing whitespace and collapse repeated spaces. Accept labels of 3 to 60 characters containing the permitted alphabetic characters, spaces and punctuation. Retain source case and spelling. Labels outside these rules are not classified.
3. Assign at most one accepted geographic label to each row. Do not infer a location from postcode, latitude, longitude, address text or Regions Served. Do not combine labels that appear to refer to the same place.
4. Retain categories with at least 15 records and display no more than the 20 largest eligible categories. Calculate each share against every analysed row, including rows outside the published groups.
5. Calculate displayed coverage as the sum of displayed category counts divided by all rows. Calculate the share represented by up to the first five displayed groups in the same way. Neither quantity is a population-adjusted measure of concentration.

4. Interpretation

A larger count means that more rows carry that source label. It does not establish that the area has a larger workforce, more installations or better availability. Areas also differ in size, population and administrative structure, so raw counts should not be treated as comparable service rates.

The displayed coverage measure helps readers understand how much of the file is visible in the chart. The remainder combines several possible causes: blank values, rejected labels, small categories and categories beyond the display limit. This remainder must not be labelled simply as missing geography.

A low or absent published count is not evidence that a place has no installers. The publication threshold hides small groups, and the source may use alternative place names. The dataset should be standardised against an explicit geographic reference before producing official-area maps or rates.

5. Limitations

• Rows are the unit of analysis. The calculation does not deduplicate legal entities, establish whether a business is currently trading, or independently re-check its certification.
• The source is a commercial dataset rather than a probability sample. No sampling weights, population estimates, confidence intervals or causal claims are produced.
• This is a living analysis of the latest available source file. Later refreshes may change the figures. Comparisons require retained, dated snapshots and consistent definitions.
• The selected location field has not been independently validated against addresses or an official geographic classification. Different spellings, capitalisation and historic county names can remain separate.
• This is a distribution of source labels, not a service-area study. No conclusion about local shortages, accessibility, travel distance or demand is supported.
• The top-20 display and the 15-record threshold mean the chart is not an exhaustive geographic list. Very high-cardinality geographic fields are withheld by the analyser.

6. Implications and further research

The geographic study is useful for describing the location information already present in the source and for deciding where geographic cleaning is required. Its published counts should always be cited with the selected field and source version.

A stronger spatial study would define a geographic unit, reconcile source labels or geocode suitable addresses, document unmatched records and select an appropriate denominator such as households or population. Service-area analysis would require a separate variable and research design.

7. Data access and disclosure

Data Menu produces this analysis and sells access to the underlying commercial dataset. This commercial relationship should be considered when using the study. The aggregate downloads are available with the findings; individual records and the source workbook are not published here.

These studies examine the same source dataset and are not independent replications. They are descriptive analyses, have not undergone external peer review, and are not official MCS statistics. Data Menu is independent of MCS and does not claim its endorsement.

8. References

1. Data Menu Limited. MCS Certified Installers UK. Commercial source dataset; current version identified with each analysis. Source
3. Government Data Quality Hub. The Government Data Quality Framework. 3 December 2020. GOV.UK. Source

9. How to cite this study

Data Menu Research. Where MCS Installer Records Are Located: A Geographic Distribution Study. DM-MCS-002, methodology 2.0. Data Menu Limited. Living study, n.d. https://www.datamenu.co.uk/research/mcs-installer-geography-uk.

When citing numerical findings, use the snapshot citation supplied with the loaded results. Retain the source update, analysis time, analysis version and aggregate download so readers can identify the figures you used. A live page is not a permanent archive of a historical result set.