• tidycensus error + SQL pseduocode

    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…

  • Calculating a Median From a Weighted Distribution

    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…

  • RE: Household Demographics with Children under 18

    Hi ! 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…

  • RE: Does a "female householder" variable exist without the "no spouse or partner present" ?

    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…

  • RE: Derived MOE for Percents when the value is 0 inside the square root

    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…

  • Use of microdata file for average state income

    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…

  • RE: ACS Status Dropout Rates

    Keriann,
    As far as I know, this particular table is not available through published tables in American FactFinder. But you could create this variable using the ACS Public Use Microdata Sample (PUMS) data. The Census Bureau provides the PUMS data for download…
  • RE: Confusion when Deriving a Percent and Reporting the Margin of Error

    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…

  • RE: Energy insecurity/utility assistance data in ACS?

    Could you consider using PUMAs as the primary unit of analysis and working from the PUMS file, which as electricity, gas, and other fuel costs (ELEP, GASP, and FULP)?
  • 2019 to 2020 changes in initial addresses selected by states

    I am conducting some analysis using the 2020 ACS PUMS, and one evaluation is the changes in the number of initial addresses selected by states. I did a simple comparison of the numbers in 2020 to the numbers in 2019. I noticed a significant difference…