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 |
All times are GMT +1. The time now is 09:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com