Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|