The 2025 ACS Data Users Conference will be held on May 29, 2025 (virtual day) and June 3, 2025 (in-person in DC)
American Community Survey Data Users Group
Search for topics, people, or keywords
Sign Up
Log in
Site
Search for topics, people, or keywords
User
Home
Discussion Forum
ACS Resources
Webinars
Conferences
Steering Committee
More
Cancel
Home
Discussion Forum
ACS Resources
Webinars
Conferences
About
More
Cancel
Details
Views
2818 views
Replies
3 replies
Subscribers
541 subscribers
Users
0 members are here
Labels
PUMS
Related Census Bureau Resources
Related Forum Threads
sum of grouped PUMA estimates within a state not equalling state estimate
Diana Lavery
over 10 years ago
Hi,
I'm working with all the 3-year ACS PUMS files for the state of Texas. I have state-level estimates, and 10 sub-state/regional estimates that are groups of PUMAs. I can't get the sum of the the 10 regional estimates to equal the state-level estimate for all 3-year ACS time periods. The numbers are relatively close: for example for '05-'07 at the state-level I get 5,564589 workers in the TX labor force who meet certain criteria, and 5,347,171 for the sum of the estimates for the10 groups of PUMAs.
Am I doing something wrong, or is there some reason as to why the sums might not add up exactly (perhaps due to the way ACS samples, uses some kind of controls, etc.)?
Has anyone else ran into this before?
Thanks,
Diana
Parents
Tom Bell
over 10 years ago
If you got the results from the state totals and the region (defined as set of PUMAs) both from the public use microdata sample then I expect you have one or two PUMAs that are not assigned to region.
Cancel
Up
0
Down
Reply
Cancel
Reply
Tom Bell
over 10 years ago
If you got the results from the state totals and the region (defined as set of PUMAs) both from the public use microdata sample then I expect you have one or two PUMAs that are not assigned to region.
Cancel
Up
0
Down
Reply
Cancel
Children
No Data