MAKING SENSE OF MESSY SURVEYS
Teaching & Educational Technologies
Jenny Carleo
Agricultural Agent
Rutgers NJAES Cooperative Extension
Cape May Court House
Abstract
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.
Authors: Carleo, J.
-
Carleo, J. Agricultural Agent, Rutgers Cooperative Extension, New Jersey, 08210