Chapter 3

The ratio of the amount of ink used in a table or chart that is necessary to convey information to the total amount of ink used in the table and chart is known as data-ink ratio. Using additional ink that is not necessary to convey information has what effect on the data-ink ratio?

It reduces the data-ink ratio.

A time series plot is also known as a _____.

Line chart

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

Line chart

To summarize and analyze data with both a crosstabulation and charting, Excel typically pairs _____.

PivotCharts with PivotTables

Which one of the following statements is not true concerning PivotTables in Excel?

PivotTables can be built using data arrayed in rows.

Which of the following graphs cannot be used to display categorical data?

Scatter chart

A line chart that has no axes but is used to provide information on overall trends for time series data is called a _____.

Sparkline

Susan would like to create a graph to display the number of males and females in her class who got an A, B, C, D, and F on the last test. Which of the following graphs could she use?

Stacked-column chart

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

The geographic information system

In order to visualize three variables in a two-dimensional graph, we use a _____.

bubble chart

Using multiple lines on a line chart or employing multiple charts is an alternative to a _____.

c. three-dimensional chart

An alternative for a stacked column chart when comparing more than a couple of quantitative variables in each category is a _____.

clustered column chart

A PivotChart, in few instances, is the same as a _____.

clustered-column chart

A graphical presentation that uses vertical bars to display the magnitude of quantitative data is known as a _____.

column chart

The data dashboard for a marketing manager may have KPIs related to _____.

current sales measures and sales by region

Never use a _____ chart when a _____ chart will suffice.

d. 3-D; 2-D

In many cases, white space in a chart can improve _____.

readability

A _____ is a graphical presentation of the relationship between two quantitative variables.

scatter chart

A useful chart for displaying multiple variables is the _____.

scatter chart matrix

We create multiple dashboards _____.

so that each dashboard can be viewed on a single screen

To avoid problems in interpreting the differences in color in a heat map, ____ can be added.

sparklines

Tables should be used instead of charts when _____

the values being displayed have different units or very different magnitudes

A _____ is useful for visualizing hierarchical data along multiple dimensions.

tree map

A _____ is a line that provides an approximation of the relationship between the variables.

trendline

_____ are visual methods of displaying data.

Charts

Natalie needs to compare the number of employees by job title for the last five years. Which of the following charts should Natalie use?

Clustered-column (bar) chart

The software package most commonly used for creating simple charts is _____.

Excel

To generate a scatter chart matrix, we use _____.

Excel Add-In XLMiner

A two-dimensional graph representing the data using different shades of color to indicate magnitude is called a _____.

Heat Map

An effective display of trend and magnitude is achieved by using a combination of a _____.

Heat map and spark lines

A data visualization tool that updates in real time and gives multiple outputs is called _____.

a data dashboard

A chart that is recommended as an alternative to a pie chart is a _____.

bar chart

The charts that are helpful in making comparisons between categorical variables are _____.

bar charts and column charts

Making visual comparisons between categorical variables may be difficult in a _____.

d. pie chart

Fields may be chosen to represent all of the following except _____ in the body of a PivotTable.

filters

Bar charts use _____.

horizontal bars to display the magnitude of the quantitative variable

Deleting the grid lines in a table and the horizontal lines in a chart _____.

increases the data-ink ratio

Data-ink is the ink used in a table or chart that _____.

is necessary to convey the meaning of the data to the audience.

A disadvantage of stacked-column charts and stacked-bar charts is that _____.

it can be difficult to perceive small differences in areas

In a business, the values indicating the business's current operating characteristics, such as its financial position, the inventory on hand, and customer service metrics, are typically known as _____.

key performance indicators

The best way to differentiate chart elements is by using _____.

labels

A _____ is used for examining data with more than two variables, and it includes a different vertical axis for each variable.

parallel-coordinates plot