I’m trying to replicate some custom analysis, but first wanted to check whether my basic numbers are right. To do that, I’m simply trying to recreate the median age of the United States, as published in the 2014 single year ACS (37.7 years).
To do this, I am using both the online IPUMS tool, and R. With both methods, I get the same result: mean of 38.13, mean of 37 (If I break the ties in R, I get a median of 36.7) .(Note: I get an accurate population estimate, so that is encouraging).
I’m using age in the row category, and a filter for 2014 on the online tool. Also, person weights.
Is it even possible to replicate this exactly using IPUMS data? Or am I just using the wrong methodology?