Details
  • Views 5086 views
  • Replies 5 replies
  • Subscribers 542 subscribers
  • Users 0 members are here
Labels
Related Census Bureau Resources
Related Forum Threads

Aggregating median HH income and calculating MOEs

Adam Bickford
over 4 years ago

I am attempting to aggregate the median household value for a set of tracts using the 2014-2018 ACS 5-year.  The base data is from table B19013, which reports the median household values in dollars for each census tract.  

I'm doing my analysis in R.

What is the accepted methodology for aggregating median values?  How should one calculate the MOEs for this aggregated medians?

 

I found this reference for re-calculating a median, but it is based on the range of household values:

http://www.dof.ca.gov/Forecasting/Demographics/Census_Data_Center_Network/documents/How_to_Recalculate_a_Median.pdf

Is there an approach to aggregating the median using the median values?

I'll post the code once I find a solution.

Thanks

Adam B.

Parents
  • over 4 years ago
    Hello ex-neighbor,

    The approach we take in our MCDC web apps is to estimate the medians by taking their weighted averages. The result is a weighted average of the medians of the components, but it is not the median of the aggregate. It may not be the actual median, but it is still a not bad measure of the typical, middle value of the distribution.

    If you need the actual median, I think Beth's comment below is the best way to go.
Reply
  • over 4 years ago
    Hello ex-neighbor,

    The approach we take in our MCDC web apps is to estimate the medians by taking their weighted averages. The result is a weighted average of the medians of the components, but it is not the median of the aggregate. It may not be the actual median, but it is still a not bad measure of the typical, middle value of the distribution.

    If you need the actual median, I think Beth's comment below is the best way to go.
Children
No Data
For more information about the American Community Survey Census Bureau Website