Question 1

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 2

A time series plot is also known as a

Accepted Answer

A) boxplot. 
B) frequency graph. 
C) dot plot 
D) line chart. 
A) boxplot. 
B) frequency graph. 
C) dot plot 
D) line chart.

Question 3

To generate a scatter chart matrix, we use

Accepted Answer

A) native Excel functionality. 
B) Excel Add-In XLMiner. 
C) Excel Add-In MegaStat. 
D) All of these are correct. 
A) native Excel functionality. 
B) Excel Add-In XLMiner. 
C) Excel Add-In MegaStat. 
D) All of these are correct.

Question 4

This bar chart displays the demographics of a Business Analysis class. How many male students are in the class? ​   ​

Accepted Answer

A) 30 
B) 50 
C) 80 
D) 130 
A) 30 
B) 50 
C) 80 
D) 130

Question 5

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

Accepted Answer

A) current sales measures and sales by region. 
B) current financial standing of the company. 
C) data on the company's call center. 
D) overall performance of the company's stock over the previous 52 weeks. 
A) current sales measures and sales by region. 
B) current financial standing of the company. 
C) data on the company's call center. 
D) overall performance of the company's stock over the previous 52 weeks.

Question 6

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

Accepted Answer

A) Stacked-column chart 
B) Scatter chart 
C) Pie chart 
D) Clustered-column chart 
A) Stacked-column chart 
B) Scatter chart 
C) Pie chart 
D) Clustered-column chart

Question 7

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

Accepted Answer

A) PivotCharts with PivotTables. 
B) stacked column charts with PivotTables. 
C) heat maps with trendlines. 
D) bubble charts with trendlines. 
A) PivotCharts with PivotTables. 
B) stacked column charts with PivotTables. 
C) heat maps with trendlines. 
D) bubble charts with trendlines.

Question 8

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 9

Construct a scatter chart for the following set of data. Describe the relationship between the two variables.
​
$\begin{array} { | l | l | l | l | l | l | } 
\hline V \text { AR1 } & 2 & 5 & 6 & 7 & 10 \
\hline V A R 2 & 3 & 6 & 8 & 13 & 15 \
\hline
\end{array}$
​

Accepted Answer

@#IMG-DLM& There is

Question 10

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 how often a problem is related to hardware. 
B) identify the frequency of a particular type of problem by location. 
C) identify which city contains the most customers. 
D) identify the percent of customers who do not have one of the listed problems. 
A) identify how often a problem is related to hardware. 
B) identify the frequency of a particular type of problem by location. 
C) identify which city contains the most customers. 
D) identify the percent of customers who do not have one of the listed problems.

Question 11

A useful chart for displaying multiple variables is the

Accepted Answer

A) stacked column and bar chart. 
B) scatter chart. 
C) scatter chart matrix. 
D) two-dimensional graph. 
A) stacked column and bar chart. 
B) scatter chart. 
C) scatter chart matrix. 
D) two-dimensional graph.

Question 12

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

Accepted Answer

A) increases the data-ink ratio. 
B) decreases the data-ink ratio. 
C) increases the non-data-ink ratio. 
D) does not affect the data-ink ratio. 
A) increases the data-ink ratio. 
B) decreases the data-ink ratio. 
C) increases the non-data-ink ratio. 
D) does not affect the data-ink ratio.

Question 13

Tables should be used instead of charts when ​

Accepted Answer

A) the reader needs relative comparisons of data. 
B) there are more than two columns of data. 
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 needs relative comparisons of data. 
B) there are more than two columns of data. 
C) the values being displayed have different units or very different magnitudes. 
D) the reader need not differentiate the columns and rows.

Question 14

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 15

In many cases, white space in a chart can improve

Accepted Answer

A) complexity. 
B) readability. 
C) functionality. 
D) stability. 
A) complexity. 
B) readability. 
C) functionality. 
D) stability.

Question 16

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? ​

Accepted Answer

A) It reduces the data-ink ratio. 
B) It increases the data-ink ratio. 
C) It doesn't change the data-ink ratio. 
D) The data-ink ratio becomes zero. 
A) It reduces the data-ink ratio. 
B) It increases the data-ink ratio. 
C) It doesn't change the data-ink ratio. 
D) The data-ink ratio becomes zero.

Question 17

An effective display of 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 18

Bar charts use

Accepted Answer

A) horizontal bars to display the magnitude of the quantitative variable. 
B) vertical bars to display the magnitude of the quantitative variable. 
C) horizontal and vertical bars to display the magnitude of the quantitative variable. 
D) vertical bars to display the magnitude of the categorical variable. 
A) horizontal bars to display the magnitude of the quantitative variable. 
B) vertical bars to display the magnitude of the quantitative variable. 
C) horizontal and vertical bars to display the magnitude of the quantitative variable. 
D) vertical bars to display the magnitude of the categorical variable.

Question 19

The software package most commonly used for creating simple charts is

Accepted Answer

A) Excel. 
B) XLMiner. 
C) SAS. 
D) R. 
A) Excel. 
B) XLMiner. 
C) SAS. 
D) R.

Question 20

The best way to differentiate chart elements is using

Accepted Answer

A) colors. 
B) labels. 
C) bubbles. 
D) chart titles. 
A) colors. 
B) labels. 
C) bubbles. 
D) chart titles.

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

A time series plot is also known as a

To generate a scatter chart matrix, we use

This bar chart displays the demographics of a Business Analysis class. How many male students are in the class?

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

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

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

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

Construct a scatter chart for the following set of data. Describe the relationship between the two variables. V AR1 2 5 6 7 10 VAR2 3 6 8 13 15

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 useful chart for displaying multiple variables is the

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

Tables should be used instead of charts when

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

In many cases, white space in a chart can improve

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?

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

Bar charts use

The software package most commonly used for creating simple charts is

The best way to differentiate chart elements is using

Introduction

Descriptive Statistics

Descriptive Data Mining

Probability: an Introduction to Modeling Uncertainty

Statistical Inference

Linear Regression

Time Series Analysis and Forecasting

Predictive Data Mining

Spreadsheet Models

Monte Carlo Simulation

Linear Optimization Models

Integer Linear Optimization Models

Nonlinear Optimization Models

Decision Analysis

Filters

Exam 3: Data Visualization

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

A time series plot is also known as a

To generate a scatter chart matrix, we use

This bar chart displays the demographics of a Business Analysis class. How many male students are in the class? ​ ​

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

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

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

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

Construct a scatter chart for the following set of data. Describe the relationship between the two variables. ​ V AR1 2 5 6 7 10 VAR2 3 6 8 13 15 ​

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 useful chart for displaying multiple variables is the

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

Tables should be used instead of charts when ​

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

In many cases, white space in a chart can improve

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? ​

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

Bar charts use

The software package most commonly used for creating simple charts is

The best way to differentiate chart elements is using

Introduction

Descriptive Statistics

Descriptive Data Mining

Probability: an Introduction to Modeling Uncertainty

Statistical Inference

Linear Regression

Time Series Analysis and Forecasting

Predictive Data Mining

Spreadsheet Models

Monte Carlo Simulation

Linear Optimization Models

Integer Linear Optimization Models

Nonlinear Optimization Models

Decision Analysis

Filters

This bar chart displays the demographics of a Business Analysis class. How many male students are in the class?

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

Construct a scatter chart for the following set of data. Describe the relationship between the two variables. V AR1 2 5 6 7 10 VAR2 3 6 8 13 15

Tables should be used instead of charts when

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?