DAC Data Tools and Visualization 3

Question 1

What does a boxplot primarily communicate about a dataset?

Accepted Answer

Distribution, median, and outliers

Answer

A boxplot shows the median, quartiles, spread, and outliers of a distribution.

Question 2

In Excel, which feature creates an interactive summary table that can be quickly re-arranged by dragging fields?

Accepted Answer

PivotTable

Answer

A PivotTable summarizes and reorganizes data interactively by dragging fields.

Question 3

Which Python library is most commonly used for statistical data visualization built on top of matplotlib?

Accepted Answer

Seaborn

Answer

Seaborn builds on matplotlib to simplify statistical visualizations.

Question 4

A stacked bar chart is best used to show what?

Accepted Answer

Composition of a total across categories

Answer

Stacked bars show how a total is composed of subcategories across categories.

Question 5

In dashboard design, what does the term 'data-ink ratio' encourage?

Accepted Answer

Removing non-essential visual clutter

Answer

A high data-ink ratio means removing clutter so ink represents actual data.

Data Analytics Certifications (DAC) Practice Test