Heat maps can be very useful for identifying missing data values in moderate to large data sets.
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?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Essentials of Business Analytics
ISBN: 978-1285187273
1st edition
Authors: Jeffrey Camm, James Cochran, Michael Fry, Jeffrey Ohlmann, David Anderson, Dennis Sweeney, Thomas Williams
Question Posted: