MA Chapter 3

A bubble chart is a graphical presentation that

has two axes that represent two variables, and the magnitude of the third variable is given by the size of the bubble.

A PivotTable

is a crosstabulation created in Excel that is interactive.

A PivotChart

is a graphical presentation created in Excel that functions similar to a PivotTable.

A Key Performance Indicator (KPI)

is a metric that is crucial for understanding the current performance of an organization.

A heat map

is a two-dimensional graphical presentation of data in which color shadings indicate magnitudes.

A Geographic Information System (GIS)

merges maps and statistics to present data collected over different geographies.

To better understand the relationship between advertising dollars spent and the subsequent sales, I could create a ________________ chart.

scatter chart

Increasing the "white space" in a table by removing unnecessary lines increases all of the following except

the table's size

Which of the following types of graphs is useful for visualizing hierarchical data along multiple dimensions?

treemap

An approximation of the linear relationship between variables in a chart can be represented with a

trendline

Edward Tufte introduced the idea of the data-ink ratio, as a way of quantifying the proportion of "data-ink" to the total amount of ink used in a table or chart. Which of the following options would increase the data-ink ratio of a table?

Adding a title to the table

The KPIs displayed in a data dashboard should do all of the following except

Be displayed across multiple screens.

DJ needs to display data over time. Which of the following charts should DJ use?

Line chart

Natalie needs to compare values across different categories. Which of the following charts should Natalie use?

Column (bar chart)

A Dashboard is a visualization tool that

Updates in real time and gives multiple outputs.

A tabular summary of data for two variables is referred to as a

crosstabulation

Of the options below, which graphical display can be used to compare categorical data?

bar chart

A crosstabulation in Excel is called a

pivot table

A bar chart is a graphical presentation that

uses horizontal bars to display the magnitude of quantitative data.