Survey Data Cleaning & Reliability Analysis: Public Sector Employee Wellbeing

This case study presents a rigorous, end-to-end data preparation workflow for Likert-scale survey research, highlighting the critical steps required before any statistical analysis can be considered valid. Using a simulated dataset of 353 public sector employees in Gauteng, the study examines Perceived Supervisor Support, Burnout, and Intention to Leave. It demonstrates best practices in data cleaning, descriptive analysis, normality testing, and reliability and validity assessment, ultimately producing a clean, defensible dataset with strong internal consistency across all constructs. Designed as a practical template, it equips postgraduate students with a clear, structured approach to preparing survey data that can withstand academic scrutiny.