Using the PUMS data which allow me to get data for planning districts on attainment by race, Spanish/Hispanic/Latino, and gender for all ages, I see what I was getting wrong. In the regular tables for educational attainment age 25+, I can get match the…
Hello! First time poster, so please be gentle. I'm relatively new to unaggregated Census data, although have a solid knowledge of R, statistics, and (if dated) survey methods.
I have spend a few hours over the long weekend trying to familiarize myself…
Great! Thank you so much for sharing that link, that is very helpful. I'm used to using variance replicate weights with PUMS data but have yet to try it for summary tables.
Do you know if this can be done with a subject table, when the variance replicate…
I'm reading through the PDF "Understanding and Using American Community Survey Data - What State and Local Government Users Need to Know" and need help recreating the calculation for the median salary in Case Study #1 as shown in Figure 3.8…
It looks like Table B11012 (Households by Household Type) is the best bet for what the original researcher used. That particular table doesn't indicate the sex of householder for either married couple of cohabiting couple households. It does have "female…
Hi Anna Carlson! There are a couple of ways to approach this.
For tricks on how to search, if you ask 10 people you'll get 10 different answers on their strategy. My best suggestion is to start with Census Bureau recorded trainings like this one: https…
I'm trying to calculate the average (mean) 2021 income of the state of Minnesota using PUMS to see if I can come close to the data in the ACS table S1901.
From S1901, I find that in 2021, 1YR ACS, there are 2,281,033 households in the state and households…
Dear David--
This is a huge problem in the ACS. In the staqndard publicshed numbers, they use the normal approximation to compute the putative standard errro, which they turn into a margin of error. However, for situations where the percent of given category…