Question 1

To generate scatter chart matrix, we use

Accepted Answer

A)  native Excel functionality. 
B)  Excel Add-In XLMiner. 
C)  Excel Add-In MegaStat. 
D)  all of the above. 
A)  native Excel functionality. 
B)  Excel Add-In XLMiner. 
C)  Excel Add-In MegaStat. 
D)  all of the above. B

Question 2

If the scatter chart indicates a positive linear relationship between two variables, then their correlation coefficient is

Accepted Answer

A)  equal to -1. 
B)  greater than 1. 
C)  between 0 and +1. 
D)  between -1 and 0. 
A)  equal to -1. 
B)  greater than 1. 
C)  between 0 and +1. 
D)  between -1 and 0. C

Question 3

A survey on the average pass percentage achieved by 4 of the top-ranked colleges of a city for 5 different years was conducted to rate the quality of teaching in each of these colleges.
   
a. Construct a line chart for the time series data for years 1 through 5 showing the average pass percentage in each college. Show the time series for all four colleges on the same graph.
b. What does the line chart indicate about the average pass percentage of the colleges between years 1 through 5? Discuss.
c. Construct a clustered column chart showing average pass percentage in each college using the years 1 through 5 data. Represent the years along the horizontal axis, and cluster the average pass percentages for the four colleges in each year. Which college is leading in each year?

Accepted Answer

a.
   
b. College 3 has the highest average pass percentage between years 1 through 5 followed by College 2, College 1, and College 4. This performance has been consistent throughout the 5 years.
c.
   We observe that, College 3 is leading in each year consistently.

Question 4

The best way to differentiate chart elements is using

Accepted Answer

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

Question 5

The owner of the grocery store is interested in providing a better service to his customers with respect to the wait time at the billing counter. The data on 20 waiting customers are given below:
   
a. Use XLMiner to create a scatter chart matrix for these data. Include the variables wait time, purchase amount, customer age, and credit score.
b. What can you infer about the relationships between these variables from the scatter chart matrix?

Accepted Answer

a.
 @#IMG-DLM& b. The waiting time appea

Question 6

To avoid problems in interpreting the differences in color, _____ can be added.

Accepted Answer

A)  a bubble chart. 
B)  a pie chart. 
C)  the heat maps. 
D)  the sparklines. 
A)  a bubble chart. 
B)  a pie chart. 
C)  the heat maps. 
D)  the sparklines.

Question 7

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 8

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 qualitative 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 qualitative variable.

Question 9

A research was conducted on a sample of 1000 males and 1000 females to study the kind of movie most men and women prefer to watch. The results are shown in the table below:
   
a. Construct a clustered column chart with the type of movie as the horizontal variable. 
b. What can we infer from the clustered bar chart in part a?

Accepted Answer

a.
 @#IMG-DLM& b. From the chart, we observe that

Question 10

A _____ is useful for visualizing hierarchical data along multiple dimensions.

Accepted Answer

A)  heat map 
B)  hierarchical map 
C)  tree map 
D)  map of multiple hierarchy 
A)  heat map 
B)  hierarchical map 
C)  tree map 
D)  map of multiple hierarchy

Question 11

The following table is an example on the profit made by Hydro America, a water servicing company, for 5 different years.
   
Reformat the table to improve readability and to help the manager identify the year with the highest profit.

Accepted Answer

To improve the readability of the table,

Question 12

Consider the below data on 30 different investments and their maturity values after 15 years.
   
a. Prepare a scatter diagram to show the relationship between the variables Investment and Future value. Comment on any relationship between the variables.
b. Create a trendline for the relationship between Investment and Future value.
What does the trendline indicate about this relationship?

Accepted Answer

a.
 @#IMG-DLM& 
There appears to be a positive lin

Question 13

A line chart that has no axes but is used to provide information on overall trends for time series data is called a

Accepted Answer

A)  time series plot. 
B)  sparkline. 
C)  trendline. 
D)  bubble chart. 
A)  time series plot. 
B)  sparkline. 
C)  trendline. 
D)  bubble chart.

Question 14

_____ helps in designing effective tables and charts for data visualization.

Accepted Answer

A)  Data-ink ratio 
B)  Crosstabulation 
C)  PivotTable 
D)  Scatter charts 
A)  Data-ink ratio 
B)  Crosstabulation 
C)  PivotTable 
D)  Scatter charts

Question 15

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 16

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 17

A useful chart for displaying multiple variables is the

Accepted Answer

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

Question 18

A PivotChart, in few instances, is same as a

Accepted Answer

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

Question 19

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)  vehicle's current speed, fuel level, and engine temperature. 
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)  vehicle's current speed, fuel level, and engine temperature. 
D)  overall performance of the company's stock over the previous 52 weeks.

Question 20

______ are visual methods of displaying data.

Accepted Answer

A)  Tables 
B)  Charts 
C)  Pivot tables 
D)  Crosstabs 
A)  Tables 
B)  Charts 
C)  Pivot tables 
D)  Crosstabs

To generate scatter chart matrix, we use

If the scatter chart indicates a positive linear relationship between two variables, then their correlation coefficient is

The best way to differentiate chart elements is using

To avoid problems in interpreting the differences in color, _____ can be added.

In many cases, white space in a chart can improve _____.

Bar charts use

A _____ is useful for visualizing hierarchical data along multiple dimensions.

The following table is an example on the profit made by Hydro America, a water servicing company, for 5 different years. Reformat the table to improve readability and to help the manager identify the year with the highest profit.

A line chart that has no axes but is used to provide information on overall trends for time series data is called a

_____ helps in designing effective tables and charts for data visualization.

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

The software package most commonly used for creating simple charts is

A useful chart for displaying multiple variables is the

A PivotChart, in few instances, is same as a

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

______ are visual methods of displaying data.

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

To generate scatter chart matrix, we use

If the scatter chart indicates a positive linear relationship between two variables, then their correlation coefficient is

The best way to differentiate chart elements is using

To avoid problems in interpreting the differences in color, _____ can be added.

In many cases, white space in a chart can improve _____.

Bar charts use

A _____ is useful for visualizing hierarchical data along multiple dimensions.

The following table is an example on the profit made by Hydro America, a water servicing company, for 5 different years. Reformat the table to improve readability and to help the manager identify the year with the highest profit.

A line chart that has no axes but is used to provide information on overall trends for time series data is called a

_____ helps in designing effective tables and charts for data visualization.

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

The software package most commonly used for creating simple charts is

A useful chart for displaying multiple variables is the

A PivotChart, in few instances, is same as a

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

______ are visual methods of displaying data.

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