Part 4: Excluding Low Quality Responses The "caffeinated hamburger meat" concept wasn't a real conceptit was just a check to see if people were paying attention to the survey. Although it is possible that someone would have a high purchase intent for that concept, the concept was included to help screen out people who were not taking the survey seriously. When people took the survey, the response for "Definitely would" was the closest to the "advance to the next screen" button, so people who were just trying to speed through the survey would be more likely to give that response. The company also wants to screen out people who didn't answer all the questions. l) Find the average purchase intent responses, excluding "low quality" responses. By definition, a low quality response is a response in any row in the data set that meets at least one of these criteria: a response of 3, 4, or 5 for purchase intent on Concept 7 (INTENT(7)) failure to answer all twenty-one INTENT, UNIQ, and FREQ questions. There are many ways to exclude the low quality responses. Try to avoid using a manual process like deleting each of the low quality rows. (Imagine if the data set had 150,000 rows instead of 150: you wouldn't want to go through all of them, one by one.) Purchase Intent, Excludin Low Qualit Res onses 2 3 4 5 6 7 Concept Caffeinated chocolate bar Caffeinated cookies Caffeinated chocolates Caffeinated potato chips Caffeinated water Caffeinated cereal/granola Caffeinated hamburger meat Average Purchase Intent 2.50 2.01 1.74 Number Of Res onses 125 2) Complete CANVAS Homework "Module 7 Part 4