MAKING SENSE OF MESSY SURVEYS
Proposed by: Jenny Carleo
Presenter: Carleo, J. , Agricultural Agent, Rutgers Cooperative Extension, Cape May Court House, NJ 08210
So you’ve done a survey and you received a great response. Now what do you do? Collecting and tabulating survey data can be a daunting task. This is particularly true if the survey was done hastily or had errors in it. This seminar will address some of the problems tabulating those not-so-perfect surveys and how you can use Microsoft Excel to accurately and usefully collect and process the data before statistical analysis. We will discuss dealing with yes or no answers, weighted responses, blanks and open-ended questions. The objective of this presentation is to assist you in dealing with those problematic survey responses as well as using mistakes to learn how to make better surveys the next time.