Hello, I’m using the data analysis tool and want to get median income and HH income for my region in addition to frequencies for hh income and income by age category for the region. For the income frequencies I would like to extract data by following income brackets: 0-24999, 25000-39999, 40000-54999, 55000-69999, 70000-84999, 85000-99999,100000+.
How should I go about this? Would I recode the variables (ftotinc - Total family income, incwage - Wage and salary income), create new variable or both? If so how? I’ve read through the documentation but can’t seem to figure it out. Any help would be greatly appreciated! Thanks in advance.
Some of these calculations are likely much more easily done in a statistical software (Stata, SPSS, SAS, or R) or in Excel. Computing summary statistics from continuous variables is not very straightforward in the online analysis tool. So, for most of these calculations, I’d suggest extracting the microdata using the data extract system. Several video tutorials helpful for using this system can be found here.
That being said, you should be able to calculate the binned income frequencies by using the recode variable option in the online analysis tool. For a measure of household income, you can recode the HHINCOME variable. FTOTINC measures family income (which is slightly different than household income) and INCWAGE is an individual measure of income from wages or salary.