Analyzing survey data in Excel
The goal of this lesson is to introduce students to several data manipulation and analysis features in Excel. Starting with a .csv of survey results exported from Qualtrics, participants will format the data for analysis, create derived variables, and generate descriptive statistics using formulas and pivot tables.
Download sample_data.csv and save it somewhere accessible.
Outline
This is your session. If you have a question or feel we are going too fast, please let the instructor know. We can decide as a group what to cover.
| Time | Content |
|---|---|
| 0:00 | Setting the stage |
| 0:10 | Exploring your data |
| 0:20 | Formulas |
| 0:35 | Pivot tables |
| 0:55 | Wrap-up |
Actual schedule may vary depending on group needs