Status:Closed    Asked:Jul 26, 2018 - 01:20 PM

Median Income and unemployment on IPUMS CAR tool?

Is it possible to use the Computer-assisted Survey Methods Program to calculate the median "incwage" by "degfieldd" and "empstat" by "degfieldd"? I am trying to find a way to get at this information baseed on the 2016 ACS sample using either Data Ferret, IPUMS onsite analysis tool or Excel.

Do you have the same question? Follow this Question

Staff Answer


Jeff Bloem


Finding the median INCWAGE by groups will be a bit tricky to calculate in the IPUMS online analysis tool. The tool is really best suited for analysis of discrete variables in the form of cross tabulations. It may be easier to do this in Excel (or some other statistical software). For information on how to open IPUMS data in Excel, see this video tutorial. Once you open the data in Excel, you can calculate summary statistics and find the median INCWAGE based on various categories of DEGFIELDD. Remember to clean out the universe for the INCWAGE variable.

That said, tabulating EMPSTAT by DEGFIELDD is quite straightforward to tabulate in the online analysis tool. If you enter "empstat" in the Row and "degfieldd" in the Column, then you can filter based on specific values or ranges of values using the Selection Filters field.

I hope this helps.


Jul 26, 2018 - 04:13 PM

Report it


Thank you, Jeff.


Jul 27, 2018 - 10:38 AM

Report it


Can I use IPUMS's online data analysis tool to narrow ACS data to State Legis...
Matching ACS median household income?
Recode or calculate new variable data analysis tool
Do I need to factor in PERWT when calculating median/average INCWAGE for a sa...
Login   |   Register

Recently Active Members

View More »

Share |