Question 1

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

Accepted Answer

A)  identify a particular type of problem by the call volume. 
B)  identify a particular type of problem by location. 
C)  identify different types of problems (Email, Internet, or Software) in the call center. 
D)  identify the frequency of each problem in the call center. 
A)  identify a particular type of problem by the call volume. 
B)  identify a particular type of problem by location. 
C)  identify different types of problems (Email, Internet, or Software) in the call center. 
D)  identify the frequency of each problem in the call center.

Question 2

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

Accepted Answer

A)  histogram 
B)  bar chart 
C)  pie chart 
D)  scatter chart 
A)  histogram 
B)  bar chart 
C)  pie chart 
D)  scatter chart

Question 3

Consider the following survey results regarding marital status by age:
   
a. Construct a stacked column chart to display the survey data on marital status. Use Age Category as the variable on the horizontal axis.
b. Construct a clustered column chart to display the survey data. Use Age Category as the variable on the horizontal axis.
c. What can you infer about the relationship between age and marital status from the column charts in parts a and b? Which column chart (stacked or clustered) is best for interpreting this relationship? Why?

Accepted Answer

a.
 @#IMG-DLM& 
b.
 @#IMG-DLM& c. Younger respondents are mo

Question 4

An effective way to show both trend and magnitude is achieved by using a combination of a

Accepted Answer

A)  time series plot and sparklines. 
B)  line chart and trendlines. 
C)  heat map and sparklines. 
D)  bubble chart and trendlines. 
A)  time series plot and sparklines. 
B)  line chart and trendlines. 
C)  heat map and sparklines. 
D)  bubble chart and trendlines.

Question 5

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

Accepted Answer

A)  does not help in conveying the data to the audience. 
B)  helps in presenting data when the audience need not know exact values. 
C)  is necessary to convey the meaning of the data to the audience. 
D)  increases the Non-data-ink ratio. 
A)  does not help in conveying the data to the audience. 
B)  helps in presenting data when the audience need not know exact values. 
C)  is necessary to convey the meaning of the data to the audience. 
D)  increases the Non-data-ink ratio.

Question 6

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

Accepted Answer

A)  bar charts and scatter charts. 
B)  scatter charts and line charts. 
C)  bar charts and column charts. 
D)  column charts and line charts. 
A)  bar charts and scatter charts. 
B)  scatter charts and line charts. 
C)  bar charts and column charts. 
D)  column charts and line charts.

Question 7

A useful type of table for describing data of two variables is a

Accepted Answer

A)  data table. 
B)  bubble chart. 
C)  crosstabulation. 
D)  scatter chart. 
A)  data table. 
B)  bubble chart. 
C)  crosstabulation. 
D)  scatter chart.

Question 8

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

Accepted Answer

A)  The heat map 
B)  The geographic information system 
C)  A geographical map 
D)  The statistical information system 
A)  The heat map 
B)  The geographic information system 
C)  A geographical map 
D)  The statistical information system

Question 9

Tables should be used when

Accepted Answer

A)  the reader need not refer to specific numerical values. 
B)  the reader need not make precise comparisons between different values and not just relative comparisons. 
C)  the values being displayed have different units or very different magnitudes. 
D)  the reader need not differentiate the columns and rows. 
A)  the reader need not refer to specific numerical values. 
B)  the reader need not make precise comparisons between different values and not just relative comparisons. 
C)  the values being displayed have different units or very different magnitudes. 
D)  the reader need not differentiate the columns and rows.

Question 10

A line chart displaying the data values collected over a period of time is termed as a

Accepted Answer

A)  boxplot. 
B)  frequency graph. 
C)  dot plot 
D)  time series plot. 
A)  boxplot. 
B)  frequency graph. 
C)  dot plot 
D)  time series plot.

Question 11

The income levels vary by race and educational attainment. To examine this inequality in the income, data have been collected for 7 different years on the median income earned by an individual based on the race and education.

a. Sort the PivotTable data to display the years with the smallest sum of median income on top and the largest on the bottom. Which year had the smallest sum of median income? What is the total income in the year with the smallest sum of median income?
b. Add the Racial Demographic to the Row Labels in the PivotTable. Sort the Racial Demographic by Sum of Median Income with the lowest values on top and the highest values on bottom. Filter the Row Labels so that only the year 2003 is displayed. Which Racial demography had the smallest sum of median income in the year 2003? Which Racial demography had the largest sum of median income in the year 2003?

Accepted Answer

To sort data in a PivotTable in Excel, r

Question 12

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

Accepted Answer

A)  line chart 
B)  sparkline 
C)  trendline 
D)  gridline 
A)  line chart 
B)  sparkline 
C)  trendline 
D)  gridline

Question 13

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

Accepted Answer

A)  a data table. 
B)  a metrics table. 
C)  the GIS. 
D)  a data dashboar
D)  
A)  a data table. 
B)  a metrics table. 
C)  the GIS. 
D)  a data dashboar
D)

Question 14

The size of the bubble in a bubble chart can represent the

Accepted Answer

A)  two categorical variables. 
B)  z-axis value. 
C)  area covered by the categorical variables. 
D)  intersection of the x-axis and the y-axis values. 
A)  two categorical variables. 
B)  z-axis value. 
C)  area covered by the categorical variables. 
D)  intersection of the x-axis and the y-axis values.

Question 15

The total number of runs scored by the players in the previous problem is 198. The following pie chart shows the percentage of runs scored by each player:
   
a. What are the problems with using a pie chart to display these data?
b. What type of chart would be preferred for displaying the data in this pie chart?
c. Use a different type of chart to display the percentage of runs scored by each player that conveys the data better than the pie chart. Format the chart and add data labels to improve the chart's readability.

Accepted Answer

a. In the pie chart, it is difficult to

Question 16

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

Accepted Answer

A)  column chart. 
B)  line chart. 
C)  two-dimensional graph. 
D)  three-dimensional chart. 
A)  column chart. 
B)  line chart. 
C)  two-dimensional graph. 
D)  three-dimensional chart.

Question 17

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

Accepted Answer

A)  2-D chart. 
B)  3-D chart. 
C)  bubble chart. 
D)  column chart. 
A)  2-D chart. 
B)  3-D chart. 
C)  bubble chart. 
D)  column chart.

Question 18

The data on the runs scored in a match by top 5 players of a cricket team are given below:
   
a. Create a column chart to display the information in the table above. Format the column chart to best display the data by adding axes labels, a chart title, etc.
b. Sort the values in Excel so that the column chart is ordered from most runs scored to fewest.
c. Insert data labels to display the runs scored by each player above the columns in the column chart obtained in part b.

Accepted Answer

a.
 @#IMG-DLM& 
b. Sorting can be done by selectin

Question 19

We create multiple dashboards

Accepted Answer

A)  to help the user scroll vertically and horizontally to see the entire dashboard. 
B)  so that each dashboard can be viewed on a single screen. 
C)  to make sure the KPIs are not displayed in the data dashboard. 
D)  so that all dashboards can be viewed on a single screen. 
A)  to help the user scroll vertically and horizontally to see the entire dashboard. 
B)  so that each dashboard can be viewed on a single screen. 
C)  to make sure the KPIs are not displayed in the data dashboard. 
D)  so that all dashboards can be viewed on a single screen.

Question 20

A chart similar to a scatter chart, but uses a line to connect the points in the chart is called the

Accepted Answer

A)  line chart. 
B)  scatter plot. 
C)  trendline. 
D)  bar chart. 
A)  line chart. 
B)  scatter plot. 
C)  trendline. 
D)  bar 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

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

An effective way to show both trend and magnitude is achieved by using a combination of a

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

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

A useful type of table for describing data of two variables is a

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

Tables should be used when

A line chart displaying the data values collected over a period of time is termed as a

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

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

The size of the bubble in a bubble chart can represent the

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

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

We create multiple dashboards

A chart similar to a scatter chart, but uses a line to connect the points in the chart is called the

Introduction

Descriptive Statistics

Linear Regression

Time Series Analysis and Forecasting

Data Mining

Spreadsheet Models

Linear Optimization Models

Integer Linear Optimization Models

Nonlinear Optimization Models

Monte Carlo Simulation

Decision Analysis

Filters

Exam 3: Data Visualization

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

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

An effective way to show both trend and magnitude is achieved by using a combination of a

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

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

A useful type of table for describing data of two variables is a

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

Tables should be used when

A line chart displaying the data values collected over a period of time is termed as a

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

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

The size of the bubble in a bubble chart can represent the

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

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

We create multiple dashboards

A chart similar to a scatter chart, but uses a line to connect the points in the chart is called the

Introduction

Descriptive Statistics

Linear Regression

Time Series Analysis and Forecasting

Data Mining

Spreadsheet Models

Linear Optimization Models

Integer Linear Optimization Models

Nonlinear Optimization Models

Monte Carlo Simulation

Decision Analysis

Filters