Status:Closed    Asked:Jul 26, 2018 - 05:47 PM

Recode or calculate new variable data analysis tool

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.

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


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.


Jul 27, 2018 - 09:35 AM

Report it


What is the file orgin?


Jul 27, 2018 - 10:45 AM

Report it


Does FTOTINC (family income variable) include results for households with a s...
income variable
Median Income and unemployment on IPUMS CAR tool?
Login   |   Register

Recently Active Members

View More »

Share |