Dear Madalsa,
I was hoping to see if I could make an example out of what you discovered but here are 3 reasons why "things don't add up" in tables
1) You added an extra variable to the tabulation. In your case, the total US population is…
2011-2015 American Community Survey (ACS) 5-Year Estimates
We are pleased to announce the release of the 2011-2015 American Community Survey (ACS) 5-year estimates. The ACS is the most relied-on source for up-to-date social, economic, and housing information…
NHGIS is part of the IPUMS family of websites, but it's not "PUMS". NHGIS provides summary tables and GIS shapefiles. As an NHGIS project manager, I'm biased, but I'd like to say it's the most user-friendly source of the 2020…
We are pleased to announce the release of the 2014-2018 American Community Survey (ACS) 5-year estimates, the most relied-on source for up-to-date social, economic, housing, and demographic information every year. The ACS is the only source of local statistics…
Thanks, Diana. I'm working with counties of 20-30K population so not working with PUMS.
I realized after posting that it is problematic using the BLS calculator since it requires that you enter a month as well as a year to adjust from and to.
I found…
Dear Lorna,
Here is some additional documentation that might be useful.
Here is some documentation on how the income and expense items in the SPM PUMS file are computed.
https://www2.census.gov/programs-surveys/supplemental-poverty-measure/technical-documentation…
Dear Christine,
MAKING PROGRESS
I was able to reproduce the AL row in the Lifeline spreadsheet. The value is 626087 I used the 2021 1-year PUMS. I added SPORDER==1 to the code posted earlier This code here computes with only SPORDER==1 person records…
We are pleased to announce the first release of documentation in support of the 2012-2016 American Community Survey 5-year estimates scheduled for release on Thursday, December 7, 2017. This documentation offers ACS data users the opportunity to prepare…