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.