tabulating and analyzing survey data

[bob]

I have about 80 comleted surveys with 75 items per
survey. Most items are 5 point scales , strongly agree to
strrongly disagree, plus age gendre etc. Ihave XP with
office 2002. what is a good approach to tallying and
cross referencing this info?

 

[Dave Peterson]

First, I'd put all the data on one worksheet.

Column A could hold the survey question.
B could hold the responder's id
C could hold the numeric response

Then maybe a bunch of pivottables/sumif()'s....

But after you have all the data in one spot, you can go from there.