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?