Business Analytics Chapter 3

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 table borders increasing the row heights and column widths for all rows and columns in the table rounding off the data to reduce excessive decimal precision adding a title to the table

adding a title to the table

Of the options below, which graphical display can be used to compare categorical data? line chart bar chart box and whisker graph scatter chart

bar chart

The KPIs displayed in a data dashboard should do all of the following except convey meaning to its user. be related to the decisions the user makes. be important to the user be displayed across multiple screens.

be displayed across multiple screens.

Natalie needs to compare values across different categories. Which of the following charts should Natalie use? pie chart column (bar) chart bubble chart heat map

column (bar) chart

A tabular summary of data for two variables is referred to as a table. crosstabulation. map. chart.

crosstabulation

A bubble chart is a graphical presentation that uses horizontal bars to display the magnitude of quantitative data. has two axes that represent two variables, and the magnitude of the third variable is given by the size of the bubble. updates in real time and gives multiple outputs. indicates the trend of data but not magnitude.

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. uses horizontal bars to display the magnitude of quantitative data. updates in real time and gives multiple outputs. indicates the trend of data but not magnitude.

is a crosstabulation created in Excel that is interactive.

A PivotChart updates in real time and gives multiple outputs. is a metric that is crucial for understanding the current performance of an organization. is a graphical presentation created in Excel that functions similar to a PivotTable. merges maps and statistics to present data collected over different geographies.

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

A Key Performance Indicator (KPI) updates in real time and gives multiple outputs. is a metric that is crucial for understanding the current performance of an organization. is a graphical presentation created in Excel that functions similar to a PivotTable. merges maps and statistics to present data collected over different geographies.

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

A heat map merges maps and statistics to present data collected over different geographies. is a two-dimensional graphical presentation of data in which color shadings indicate magnitudes. updates in real time and gives multiple outputs. indicates the trend of data but not magnitude.

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

DJ needs to display data over time. Which of the following charts should DJ use? pie chart clustered column (bar) chart bubble chart line chart

line chart

A Geographic Information System (GIS) merges maps and statistics to present data collected over different geographies. is a two-dimensional graphical presentation of data in which color shadings indicate magnitudes. updates in real time and gives multiple outputs. indicates the trend of data but not magnitude.

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

A graphical presentation used to examine more than two variables in which each variable is represented by a different vertical axis is called a heat map. treemap. trendline. parallel coordinates plot.

parallel coordinates plot.

A crosstabulation in Excel is called a chart. crosstabulation. pivot table. table.

pivot table

To better understand the relationship between advertising dollars spent and the subsequent sales, I could create a ________________ chart. pie chart clustered column (bar) chart scatter chart line chart

scatter chart

Which of the following can be used to show overall trend? pie charts heat maps sparklines bar charts

sparklines

Increasing the "white space" in a table by removing unnecessary lines increases all of the following except the table's readability. the table's size. the data-ink ratio. the simplicity in conveying information to the reader.

the table's size.

Which of the following types of graphs is useful for visualizing hierarchical data along multiple dimensions? a. heat map b. treemap c. trendline d. parallel coordinates plot

treemap

An approximation of the linear relationship between variables in a chart can be represented with a data dashboard. crosstabulation. trendline. bar chart.

trendline.

A Dashboard is a visualization tool that uses horizontal bars to display the magnitude of quantitative data. has two axes that represent two variables, and the magnitude of the third variable is given by the size of the bubble. updates in real time and gives multiple outputs. indicates the trend of data but not magnitude.

updates in real time and gives multiple outputs.

A bar chart is a graphical presentation that uses horizontal bars to display the magnitude of quantitative data. has two axes that represent two variables, and the magnitude of the third variable is given by the size of the bubble. updates in real time and gives multiple outputs. indicates the trend of data but not magnitude.

uses horizontal bars to display the magnitude of quantitative data.