I collect data in the field and often face inconsistencies or missing values afterward. What’s your workflow for cleaning data efficiently?
Welcome to the community, @chickpeafilae! I would strongly advise starting by keeping your survey form well-structured. When designing the form, consider using strong constraints and validations, and apply skip logic where necessary. While this approach may slow down data collection slightly, it will significantly improve the overall quality of the data collected.
However, if you have already collected the data and are now in the data cleaning and processing phase, you may want to export the data to Excel and clean it thoroughly. Consider applying range checks, identifying outliers, and using cross-tabulations to verify that the data falls within the expected parameters.
