Chap 3- Data Visualization

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

• does not help in conveying the data to the audience

• helps in presenting data when the audience need not know exact values

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

• increases the non-data-ink ratio

Tables should be used instead of charts when

• the reader needs relative comparisons of data

• there are more than two columns of data

• the values being displayed have different units or very different magnitudes.

• the reader need not differentiate the columns and rows

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

• PivotTables are also known as crosstabulation tables.

• PivotTables summarize data for two variables.

• PivotTables are interactive

• PivotTables can be built using data arrayed in rows

Which graphical presentation that can be used to identify the relationship between two quantitative variables.

• 
• 
• 
• 

The following image is a

• sparkline

• trendline

• gridline

• line chart

Making visual comparisons between categorical variables may be difficult in a

• 
• 
• 
• 

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

• heat map

• bubble chart

• column chart

• pie chart

Consider the clustered bar chart of the dashboard developed to monitor the performance of a call center. This chart allows the IT manager to:

• identify how often a problem is related to hardware

• identify the frequency of a particular type of problem by location

• identify which city contains the most customers

• identify the percent of customers who do not have one of the listed problems

This Excel bar chart displays the demographics of a Business Analysis class. Approximately how many students are in the class?

• 175

• 150

• 105

• 130

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

• a bubble chart

• a pie chart

• a scatter chart

• sparklines