How to calculate MOE in Excel using VREs: example for males under 18 in one census tract
Census analyst Vicky Mack demonstrates step-by-step how to download VRE CSV files, sum age-category estimates, compute squared differences across 80 replicate columns, derive variance and standard error, and calculate the MOE (example shown with estimate '2 11' and MOE ±40 in the transcript).
The full story
Vicky Mack of the American Community Survey Office at the U.S. Census Bureau walked viewers through a concrete Excel example showing how to calculate a count estimate and its margin of error using VRE tables.
Sign up to keep reading.
Your free newsletter brings you what your city council, county, and school board discussed and decided.
or