I recently extracted a set of data for 1% density for 2012 ACS, 2013 ACS, 2014 ACS and 2015 ACS samples with HHWT and REPWT1…REPWT80.
My goal is to create a weighted mean of all housing units that lack a complete plumbing for these years–I cannot use a 5 year survey due to geographies changing (I am using PUMAs that have been redrawn boundaries).
If I add all the HHWT of houses without complete plumbing across all 4 years and divide by the total HHWT of all houses, would my weighted mean be accurate, or is each HHWT specific to year and would not be accurate if combined?
I have the same question if I was to combine REPWT1-80 accross the years to get my standard error.
Thanks in advance!