Data Prepping Tutorial: Cleaning Data

This tutorial covers the ten step process for cleaning data and preparing it for analysis for an undergraduate Marketing Research class. Please note: Due to time constraints and the undergraduate level of this workshop shortcuts were taken that are not recommended for more advance research. For example, I deleted the survey start, finish,completion dates and survey completion time. I used a quick and easy heuristic that if they finished the entire survey, that the data was good. It is important to know that this may create errors in the data. I recommend methodically reviewing any variables before deleting them. For example, variables like completion times that are too short (outliers or more than 3 standard deviations below the mean) may indicate a lack of involvement of the respondent and that the data is made up and not thoughtful.