(a) Spreadsheet software allows you to create tiny charts (heat maps, line charts and bar charts) within the individual cells of a spreadsheet, using functionality such as conditional formatting and sparklines. Imagine that you have a dataset that contains 50 categorical variables (examples are a person’s name, gender and occupation) and one million records. How would you use those tiny charts to provide an overview of the dataset, with each variable limited to one row of a spreadsheet? You may find it useful to illustrate your answer with a diagram. Show transcribed image text (a) Spreadsheet software allows you to create tiny charts (heat maps, line charts and bar charts) within the individual cells of a spreadsheet, using functionality such as conditional formatting and sparklines. Imagine that you have a dataset that contains 50 categorical variables (examples are a person’s name, gender and occupation) and one million records. How would you use those tiny charts to provide an overview of the dataset, with each variable limited to one row of a spreadsheet? You may find it useful to illustrate your answer with a diagram.
Expert Answer
Answer to (a) Spreadsheet software allows you to create tiny charts (heat maps, line charts and bar charts) within the individual …