From the course: Excel Weekly Challenge

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Check the quality of survey responses

Check the quality of survey responses - Microsoft Excel Tutorial

From the course: Excel Weekly Challenge

Start my 1-month free trial Buy for my team

Check the quality of survey responses

“

- [Instructor] All right. We've got to be really careful here. We've got this survey data and before we do any analysis, we need to be able to trust what we have here. Please use the ID to identify any duplicate submissions. Everybody should only have submitted one. Then, ID any mismatches, right? Because a good survey will kind of get people to out themselves for having put junk in or just didn't take the survey seriously. So it's designed such that we're going to compare Question Seven with the profession. If the profession is 2.A, Question Seven should have a two. If the profession is 4.C, Question Seven should have a Four. You get the picture. So flag any mismatches. Then finally, identify any surveys that have less than five responses for each of the questions. Okay. Check that quality. Come back and we'll do it together. Okay. Let's see what's what. First, I'm going to highlight the IDs and then go…

Contents