After reading David's response, I realized that the answer may depend on whether you're using PUMS or pre-tabulated data.

This ACS Handbooks provide a set of formulas you can use to calculate MOE. (See Chapter 8 https://www.census.gov/content/dam/Census/library/publications/2020/acs/acs_general_handbook_2020_ch08.pdf)

The only challenge is (as you described above) the formulas…

Is the state-level estimate that you're trying to match from the published 05-07 tables? If so, those estimates cannot be matched exactly by the PUMS estimates because the PUMS data is a sub-sample from the full sample which is used to create the published…

Hi Gan,

My understanding is that the summary tables are already adjusted into 2014 dollars. I'm assuming they would have to use the same adjustments that users have to use when working with PUMS data, if you wanted to create your own tables not published…

The income/earnings questions don't go by calendar years, they go by "earnings/income in the past 12 months." I think what they are doing is somehow averaging the current survey year's and the previous year's CPI-U-RS (although...not everyone would be…

7455.median_with_linear_interpolation.docx8712.median_with_linear_interpolation.txt

 

 

 

Hello-

Attached are a .txt and Word version that were provided by some colleagues here at Census. It doesn't look like I can upload the SAS file directly.

Just…

I came across this problem yesterday and was quite surprised in light of a Census Bureau press release that featured the break out of additional languages in this table. I'll be able to work around this problem once the PUMS data is available, but it…

I would encourage you not to give up too quickly. As Cliff pointed out, it isn't trivial to do this, but neither is it so difficult that it isn't worth trying (depending on how much you want the data). To demonstrate, I created & uploaded a tabulation…