Data Analysis - Question and answers

For my university thesis on customer satisfaction in e-commerce, I conducted an online survey with 300 respondents and in-depth interviews with 15 customers. The survey suggests high satisfaction scores, but interviews reveal underlying frustrations with shipping times. I've tried basic cross-tabulation in SPSS, but the discrepancies persist. I'm looking for practical methods to reconcile this data without oversimplifying.

I work as an HR analyst for a company with over 1,000 employees. We use an HRM system that collects engagement survey data quarterly, but the responses have a lot of missing entries and varying scales (e.g., some use 1-5, others use 1-10). I've tried manual cleaning in Excel, but it's error-prone and time-consuming. I need a systematic approach to handle this big collection of data for accurate insights.

I'm a sociology researcher focusing on youth culture and digital interactions. I plan to investigate how social media affects teenagers' social behaviors, but I'm unsure whether to use structured surveys (quantitative) or in-depth interviews (qualitative). I've read about both methods, but I need practical advice on which yields better insights for proposing community interventions. My constraints include a limited budget and a sample size of about 200 participants from urban schools.