Status:Closed    Asked:Oct 24, 2015 - 09:03 PM

How do you compute median personal earnings on online IPUMS analysis interface?

Hi, I am trying to compute the median personal earnings for specific immigrant groups; however, the analysis states that there are too many cells for personal earnings variables. Can anyone please help!

Do you have the same question? Follow this Question

Staff Answer




Unfortunately, it is not possible for the online analysis tool to generate the median if the number of cells exceeds the limit. You could restrict your table to an interval of earnings that does not generate too many cells and then repeat this process with non-overlapping intervals (i.e. incearn(*-50000), incearn(51000-100000), etc.) until you have generated data for the full sample. Once you have the full sample represented, it is possible to determine the median income, as this will be the earnings value associated with the midpoint of the weighted population.

Alternatively, since the IPUMS-USA project provides microdata, it is probably easier to download an extract and manipulate the data in a statistical software package. You can also download the data in CSV format, which can be read into Excel. Keep in mind that very large files may be truncated due to Excel's row limits. IPUMS-USA has a number of video tutorials that walk user's through the process of creating, extracting, and opening a data file. Once the data has been read into your statistical software package or Excel, you can calculate medians.

Hope this helps.


Oct 28, 2015 - 10:29 AM

Report it


Wrong HH weight Tanzania 2012 census?
Assign Individuals to PUMAS, append dataset
Regarding: Does CLASSWKR in ASEC before 1988 include incorporated and non-inc...
Does using the INCLUGH variable over time requires correcting for the VERIFY=...
Does CLASSWKR in ASEC regarding self-employment (code 10) include incorporate...
I am trying to cross age, urban, and race. Which weight am I supposed to use?
Login   |   Register

Recently Active Members

View More »

Share |