Cleaning Survey Data

#1

Export data

Export the responses and download file in .xlsx format

#2

Format in Excel

Open the data in Excel and start formatting:

- Add ID coulumn

- remove outliers

- remove unnecessary column data

#3

Change the variable names to fit with measurable requirements

Changing Variable names

Import into SPSS and start formatting the variables to fit the requirements for doing statistics

#4

import to spss

Change the measurements to fit with the factors being measured

#5

Remove missing data

#6

Do descriptive statistics

Choose how and what you want to measure and output it

And you're done!