If you can use PUMS data, they have cost of utilities.
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…
Thank you! Beth. I will check PUMS.
I haven't used the variance replicate tables but I use replicate weights for PUMS data all the time. I think that all you do is take the 80 x 2 tables (2 tables for each replicate) take the difference
difference i = total population table i - in…
You need to use a PUMS file The vehicle question (household section of the ACS survey form) is #12 How many automobiles, vans, and trucks of one-ton capacity or less are kept at home for use by members of this household? Split the PUMS data by using None…
Depending on the size of your county/counties of interest, PUMS would work. Larger counties tend to have clear PUMA-to-County crosswalks. Smaller counties may have PUMAs that overlap with adjacent counties. Geocorr can produce the necessary crosswalk…
This a little advertisement for the Small Area Estimation package that is in my earlier post.
The variable Asian male & white female couples can be constructed using PUMS data so the SAE package will produce tract level data with this variable.
You…
Thank you for the suggestion, Beth. I have not before used the PUMS files, so that will be a new dataset for me to try!
Hi Everyone!
My goal is to find the 2019 mean travel time to work in the USA filtered for ages 20-64. I created a custom table employing the microdata access tool. If anyone could kindly review and confirm the validity of my calculations, it would greatly…
Additional comment. If you want people living alone with/without a phone you will need to use the PUMS (microdata) file. PUMS files don't go down to the county level only to the PUMA level (public use microdata area) These have to be at least 100,000…