• Best approach for minimizing error for a given year when using overlapping 5-year data?

    Hi Folks,

    This is my first post and day on this forum.  I couldn't find the answer to this question, but if there is a good thread which exists already, please point me in that direction.

    I am conducting an analysis where my geographic region is at…

  • RE: calculating SE and MOE in R package srvyr for a proportion using replicate weights and PUMS data

    Thanks David, and in my original code with the additions provided by Elizabeth, how do I then utilize qnorm(0.95) to get the margin of error?

    And do you agree that standard error is 2.75% (not .0275%)?

  • RE: Calculating percentage of individuals in a census tract with high school diploma or equivalent using tidycensus

    I think the table you may be looking for is B15003, which contains educational attainment for the population 25 and older. Using tidycensus, you can specify the variables from that table B15003_017 through B15003_25 that represent the population with…

  • Different coefficients of variation with same information

    Hi, all. We often use coefficients of variation (CV = standard error ÷ estimate) as a rough guideline for statistical reliability: CV < 0.15 is pretty trustworthy; CV > 0.30 is not to be trusted. But the CV value depends on how the estimate is expressed…

  • Comparison of RACE and Hispanic STATUS for National Tables 2019 to 2021

    Someone noticed that I had incorrectly computed (using Excel) t in the First Panel of the Table, where I report percent  Total Race for the 2019 ACS.  The table below reports corrected percents and corrected percent differences for that table.  I should…
  • RE: Question of Using API: Variable Postfix

    I'm guessing it's

    E: Estimate
    M: Margin of Error

    Maybe PE is Percent Estimate, PM is Percent Margin of Error?
  • Total population differences between table for same census tracts

    Hello,

    I have limited experience with the ACS data.   I am working with 2020 ACS data in Los Angeles County.  I am comparing People with Disabilities vs Age & Sex (and other tables that have the same population total).  The total population is different…

  • RE: What's the smallest geographic slice to browse ACS data?

    Hi Diana,

    thanks for your notes here! Would be curious to read your blog post :)

    Aggregating by geography makes sense.

    Regarding aggregating by rows/categories, you said

    > For example, with the age and sex breakdowns in your screenshot, could you live…

  • Annual DP Tables: Column Name - Label Changes

    I'm working on analyzing tables DP02, DP03, DP04, and DP05 from 2007 to 2022 and am searching for a comprehensive legend that tracks changes in variable codes over time.

    For instance, the field “Estimate!!ANCESTRY!!Total population!!Greek” uses the…

  • Calculating MOE for average of Median Estimates

    Currently computing estimates using the Household Income dataset--B19049 for 2016 5-year estimates.

    I am working with the data on a county level. However, when it comes to New York City, we combine the boroughs to obtain estimates for New York City as…