Diagnose an absent ACS table before treating it as zero

Identify what is absent

Start with the exact release, product, table ID, geography level and cell. Check whether the table exists for that product and whether its universe applies to the area. Look up the release rules rather than inferring the reason for absence from a blank spreadsheet.

Keep availability separate from the numeric value

Use separate fields for the numeric estimate, the publisher’s annotation and an analysis status such as “unavailable in this product.” Preserve the source representation. An empty cell, an annotation and a published estimate of zero are not interchangeable. If the precise reason is undocumented, record it as unresolved.

Hypothetical effect on a summary

A fictional audit expects three estimates and receives 6, 12 and one unavailable entry. The mean among observed estimates is 9. Replacing the missing value with zero yields 6 and changes the question without evidence. Neither figure is a population-weighted pooled rate; that would require suitable numerators and denominators. Report that only two of three expected areas contributed.

Decide before analysis whether to switch to an available product, broaden the geography, or exclude a cell with an explicit explanation. If switching, check that every comparator uses the same product and period. A broader product may answer a different question, even when it fills every blank.

Primary source checked 7 November 2026: U.S. Census Bureau: ACS data release rules.

Use this in your study: Download: Unpublished cell disposition log.