Using Excel for Analyzing Survey Questionaires

University of Wisconsin-Extension

This guide, provided by University of Wisconsin-Extension, is helpful for those unfamiliar with data analysis. It provides step-by-step instructions for using Microsoft Excel to: Create a database of responses, Code data, Display frequencies and percentages, Calculate average(mean), range, standard deviation, etc., and Create crosstabulations/pivot tables.

The link address is: http://learningstore.uwex.edu/pdf/G3658-14.pdf