Using Excel for Analyzing Survey Questionnaires
3 years ago 3 years agoThis toolkit was developed by Jennifer Leahy at Program Development and Evaluation, University of Wisconsin-Madison Division of Extension (formerly University of Wisconsin-Extension).
HERE’S HOW THE AUTHORS DESCRIBE THIS TOOLKIT:
You have created, tested, and implemented a survey, and now you would like to see the results of your work. This guide will help you set up a simple database in Microsoft Excel 2002® to analyze your survey data. Some steps may be slightly different in other versions of Microsoft Excel.*
This guide is organized in five steps:
- Step 1: Create an Excel database
- Step 2: Code your data
- Step 3: Enter your data
- Step 4: Clean your data
- Step 5: Analyze your data
Leahy, J. (2004). Using Excel for Analyzing Survey Questionnaires. Program Development and Evaluation, University of Wisconsin-Madison Division of Extension. https://cdn.shopify.com/s/files/1/0145/8808/4272/files/G3658-14.pdf
Filed under:
Gallery image
No gallery image found.
Categorised in: Toolkit