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


when trying to declare the IPUMS data as panel on stata there are repeated ti...
2010 5-year PUMA definition
Where can I find city populations, by age, San Diego, New Orleans, Atlanta, C...
Hi, it has been over 4 hours for my data extract and I was wondering if there...
When I take several Nov Supplements, the weighted number of voters equals pub...
Are there aggregate categories for OCC/OCCLY in CPS?
Login   |   Register

Recently Active Members

View More »

Share |