Hi all,
I'm using Decennial Census data on the tract level, and the dataset includes the number of households in each of 16 income brackets. I need to determine the share of households in a tract earning below a certain income threshold (which varies by tract and does not correspond with min and max income for the brackets). I have a variable for which the value is the income threshold. At first, I assumed all households in a bracket are consolidated at the midpoint of the bracket, and then computed the number of households below the threshold based on this and divided by total households.
I'm now hoping to use the mcib command but having trouble.
here is my current code:
mcib inc_ min max, mean(avg_hh_income) by(fips2000) s(results)
This code returns quartiles and deciles.
Is there any way to specify that I need the number of households falling below a certain threshold by tract? Is there another command I should be using? Is it best to just stick with the midpoint method?
Thanks!
I'm using Decennial Census data on the tract level, and the dataset includes the number of households in each of 16 income brackets. I need to determine the share of households in a tract earning below a certain income threshold (which varies by tract and does not correspond with min and max income for the brackets). I have a variable for which the value is the income threshold. At first, I assumed all households in a bracket are consolidated at the midpoint of the bracket, and then computed the number of households below the threshold based on this and divided by total households.
I'm now hoping to use the mcib command but having trouble.
here is my current code:
mcib inc_ min max, mean(avg_hh_income) by(fips2000) s(results)
This code returns quartiles and deciles.
Is there any way to specify that I need the number of households falling below a certain threshold by tract? Is there another command I should be using? Is it best to just stick with the midpoint method?
Thanks!
