Heat maps can be very useful for identifying missing data
Heat maps can be very useful for identifying missing data values in moderate to large data sets. The file Surveyresults contains the responses from a marketing survey: 108 individuals responded to the survey of 10 questions. Respondents provided answers of 1, 2, 3, 4, or 5 to each question, corresponding to the overall satisfaction on 10 different dimensions of quality. However, not all respondents answered every question.
a. To find the missing data values, create a heat map in Excel that shades the empty cells a different color. Use Excel’s Conditional Formatting function to create this heat map.
b. For each question, which respondents did not provide answers? Which question has the highest nonresponse rate?
Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help