Graded Quiz: Updating Advanced Charts :Data Visualization and Dashboards with Excel and Cognos (IBM Data Analyst Professional Certificate) Answers 2025
1. Question 1
What do treemaps use to represent hierarchical data categories?
-
❌ Treemaps use data points on a line.
-
✅ Treemaps use color, size, and closeness of shapes.
-
❌ Treemaps use interconnected circles.
-
❌ Treemaps use different shapes.
Explanation:
Treemaps visualize hierarchy using nested rectangles whose size and color reflect data values.
2. Question 2
Histograms can look like bar charts—what’s the key difference?
-
❌ Bar charts use horizontal bars.
-
❌ Histograms use bins. (true but incomplete)
-
❌ Histograms use Axis Options to change bin sizes.
-
✅ Bar charts compare data, and histograms show the distribution of data.
Explanation:
A histogram displays frequency distribution across bins, while bar charts compare categories.
3. Question 3
What kind of data works best with filled map charts?
-
❌ Raw data
-
✅ Data containing geographical regions
-
❌ Scientific data
-
❌ Complicated data
Explanation:
A filled map chart requires location-based data (states, countries, regions, ZIP codes).
4. Question 4
What are sparklines typically used for?
-
❌ To contrast numerical values
-
❌ To highlight a data range
-
✅ To show data trends
-
❌ To show regional information
Explanation:
Sparklines are mini-charts inside a cell that show trends over time at a glance.
🧾 Summary Table
| Q# | Correct Answer | Key Concept |
|---|---|---|
| 1 | Color, size, closeness of shapes | Treemaps show hierarchy |
| 2 | Bar = compare categories; Histogram = distribution | Difference between histogram & bar chart |
| 3 | Data with geographic regions | Filled map chart requirement |
| 4 | Show data trends | Sparkline purpose |