So a local group I've just joined is about to look at the results of a paper based survey recently completed. I think there must be an easier way than how they are trying to table this. Basically c500 responses to 40 questions with a 1-5 answer rating. Profiles include gender and age range. What's the best application to build this in to for later analysis in terms of being to ask questions like, how did ladies in this range range answer question 5?

Any help appreciated.

James

Manually enter the data into an access database? Record all the results to each question relative to the demographics of the individual who submitted the response.... you could then write queries to do as you propose..

Or just in Excel - then use pivot tables to interpret/filter the results.

Or enter it all into SurveyMonkey and use the analysis tools within it...

I would use a Access database, it is very versatile to add different queries once the data is in a table.