tabulating and analyzing survey data

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?

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.

bob wrote:
>
> 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