Status:Closed    Asked:Jun 06, 2014 - 04:04 PM

Is there an easy way to look at multi-year trends using 1-year estimates using the online data analysis system?

I am interested in looking at changes in the demographic characteristics of people who bike and walk to work over time. At its simplest it would be great to see any changes in sex or race over time, but I am also interested in socio-economic characteristics. Ideally, I'd like to be able to set it up so I can just plug in a demographic characteristic and see how it changed over the years that data is available for the American Community Survey.

Right now, my understanding is that I would have to use the online data analysis tool to create a table for each characteristic I am interested for each year and then combine them. I do not have access to a stastical program and do not really understand the data extract system. If the data extract system is more appropriate for what I would like to do then I would want an output in Excel.

I hope this question makes sense.

Do you have the same question? Follow this Question

Staff Answer




It is possible for the extract system to output data in CSV format, which can be read into excel, but generally the files are too large for excel to open all at once. Using the online data analysis tool, you can select the "ACS, 2001-2012" dataset and include year as a control to get descriptive tables by year. For example, to see how sex relates to biking to work between 2001 and 2012 using the online data analysis tool, you could put tranwork in the "Row:" box, sex in the "Column:" box and year in the "Control:" box (leaving perwt as the weight variable). The resulting tables will show (among other things) what percentage (bold number) of the male population biked to work in each year as well as what percentage of the female population biked to work in each year. You could also select to display Row Percentages in the Table Options box to see what percentage of bikers are male vs. female in each year.

I hope this helps.



Jun 09, 2014 - 11:17 AM

Report it


I am looking for the Kessler 6 variable in IPUMS-MEPS
Reason for missing MIGSTA1 values in ASEC files for 1985 (and 1995)
India Area-level data (geo2) inconsistent for total population, urban share, ...
Does anyone have a method for handling missing data in CPS "EDUC" variable? 2...
How do I find the data file:Ipumsi_00001.dat for the 1974
Variables from Full Year Consolidated Files currently not included in IPUMS-M...
Login   |   Register

Recently Active Members

View More »

Share |