Question 1

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

Accepted Answer

A) heat map. 
B) bubble chart. 
C) column chart. 
D) pie chart. 
A) heat map. 
B) bubble chart. 
C) column chart. 
D) pie chart.

Question 2

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

Accepted Answer

A) stacked bar chart. 
B) clustered column chart. 
C) pie chart. 
D) clustered bar chart. 
A) stacked bar chart. 
B) clustered column chart. 
C) pie chart. 
D) clustered bar chart.

Question 3

In order to visualize three variables in a 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 4

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 5

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

Accepted Answer

A) 175 
B) 150 
C) 105 
D) 130 
A) 175 
B) 150 
C) 105 
D) 130

Question 6

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

Accepted Answer

A) they do not include all the values of the variable. 
B) they cannot be used to compare relative values of quantitative variables for the same category. 
C) it can be difficult to perceive small differences in areas. 
D) they are only used when many quantitative variables need to be displayed. 
A) they do not include all the values of the variable. 
B) they cannot be used to compare relative values of quantitative variables for the same category. 
C) it can be difficult to perceive small differences in areas. 
D) they are only used when many quantitative variables need to be displayed.

Question 7

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

Accepted Answer

A) rows 
B) columns 
C) values 
D) filters 
A) rows 
B) columns 
C) values 
D) filters

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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 Excel bar chart displays the demographics of a Business Analysis class. Approximately how many students are in the class?