• Approximating the Median for a group of census tracts

    Hello,

    A question I get from time to time is, how to calculate/estimate/approximate the median (age/income/home value/monthly rent/etc.) when grouping together a few different census tracts. I want to have a better answer for them than, "do it using PUMS…

  • RE: Number of households or families with children by age of children and number of workers or employment status

    I thought this was an interesting question, so I wrote a little R code to pull PUMS via tidycensus and create these estimates. If you are not familiar, this is a good walk-through of how to use tidycensus for PUMS data. If you also want standard errors…

  • RE: 2018 data download error

    I believe S tables are summaries and pull together from a variety. The easiest way for me to find the tables I need is to check out the Appendices in the Summary File documentation that has a full list of the tables. https://www.census.gov/programs-surveys…

  • RE: Calculating MOEs from derived ACS estimates

    Old thread but placing here in case others stumble across it like i did. The census has a very good section with several examples of the pitfalls for aggregating MOE. See pg 25 in American Community Survey Multiyear Accuracy of the Data (5-year 2012-2016…
  • RE: cost of utilities

    Gwendolyn - 

    The BEA RPPs are relative costs - how much more or less this state pays than other states.  For actual dollar costs, the BEA Personal Consumption Expenditures (PCEs) are probably more appropriate. There is a table: SAPCE3 Personal consumption…

  • RE: Local Area Profiles of Elderly Population

    Well, if you need any info on how we get our senior data, or formulas for deriving various indicators, just let me know. Much of it comes from ACS or other federal sources, so could easily be used for Mass.

  • 2013 PUMS error and re-release of data

    Users should note that there was an error in the original 2013 1-year and 3-year ACS PUMS files affecting the "MV" variable (when the householder moved into this house or apartment).

    The files are being re-released.
    Users should replace any…
  • Inconsistencies in ACS 2022 5-Year Estimates: A Case Study of BYUI Gender Ratios

    Hello ACS Data Community,

    I recently stumbled upon a perplexing issue in the 2022 ACS 5-year estimates that I believe warrants discussion. According to the official enrollment statistics provided by BYU-Idaho (byui.edu/executive-strategy-and-planning…

  • US Census table DP03 Data Suppression?

    Hello, I wanted to ask about US Census table DP03. I am interested pulling US Census poverty figures at the Census tract level. How can I know if a data point is suppressed. For example, a Census tract 2604.03 in Baltimore City has a margin of error of…

  • RE: Is the spouse of a grandparent also a grandparent? Why have spouse as it seems like it could be the spouse of the parent (which is also the parent)?

    Question 26 only covers this from the standpoint of the grandparent, so references to the grandchild (which they have) is not based on the relation to the person filling out the form.  A number of fields do not relate directly to the person filling out…