United Nations - Guide to Presenting Statistics. Using Graphics to Report Evaluation Results. UF - Analyzing Survey Data. Using Excel for Analyzing Surveys. Analyzing Survey Data. Enter closed-ended survey responses into a program Enter closed-ended survey responses into a data file of an analysis program like Excel, Access, SPSS, or SAS, which can perform statistical analyses and create tables and graphs.
Often, you can import data from electronic surveys directly into the analysis software. Code the data by assigning a number for each response choice (for example, "strongly disagree" = 1, "disagree" = 2, etc.) and create a key explaining the coding for each question. Pell Institute - Analyzing Quantitative Data. The first thing you should do with your data is tabulate your results for the different variables in your data set.
This process will give you a comprehensive picture of what your data looks like and assist you in identifying patterns. The best ways to do this are by constructing frequency and percent distributions.