Solutions for Business Analytics, 5th Edition (All
Chapters )with Verified Answers 100%|2025/2026
Brand
_____________________________________________________________________________________
In Excel, which of the following methods can be used to find extreme values outside of a reasonable
range?
Outlier detection using the COUNTIF function
Which of the following is a precursor to data wrangling?
Raw data input
What kind of record can be combined by using one-to-one merger?
Unique
Which of the following is the main purpose of creating a scatter chart in data visualization?
To show the relationship between two quantitative variables
What is the main purpose of adding a trendline to scatter charts and line charts in data visualization?
To show an approximation of the relationship between two variables over time
What is a clustered column in data visualization?
A type of bar chart that displays data as clusters of columns
What is the primary purpose of KPI data visualization?
To deliver summary information with live monitoring and alerting
Which of the following should be considered when designing a table for business analytics purposes?
Eliminating unnecessary ink usage
When should tables be used in business analytics?
To refer to specific numerical value
What is the data-ink ratio in data visualization?
The ratio of data-ink to non-data ink in a table or chart
Treemaps are used in data visualization to
represent categorical data.
What is the purpose of adding a trend line?
To provide an approximation of the relationship between the variables
, Which of the following is an example of a data dashboard in data visualization?
Tableau
Which of the following best describes a bubble chart?
A graphical means of visualizing three variables in a two-dimensional graph
What is a stacked column chart?
A type of bar chart that displays data as stacked bars
What is the purpose of a bar chart?
To display the magnitude of the quantitative data
Which of the following is a choropleth map used to create?
Geographic thematic map
Which of the following best describes a cartogram?
A color-coded map that represents data as areas or proportions
Which of the following is best used to visualize relationships between multiple variables?
Scatter chart matrix
What type of visualization tool is a heat map?
2D color plot
What role do preattentive attributes play in business analytics?
Reducing the cognitive load required by the user to interpret the visualization
How many axes does a sparkline typically contain?
No axes
What is the purpose of line charts in data visualization?
To show the change in one variable over time
Every day, logistics companies such as United Parcel Service (UPS) must decide how to route their
trucks, that is, the order in which to deliver the packages that have been loaded on a truck. UPS
developed a system called ORION (On-Road Integrated Optimization and Navigation) which
dynamically routes its trucks based on packages on the truck and traffic conditions. It is estimated
that ORION saves UPS about 10 million gallons of fuel per year. Is ORION an example of descriptive,
predictive, or prescriptive analytics? Explain.
Because ORION dynamically --- truck route based on packages and traffic conditions, it is an example
of --- analytics.
yields the best, prescriptive
Chapters )with Verified Answers 100%|2025/2026
Brand
_____________________________________________________________________________________
In Excel, which of the following methods can be used to find extreme values outside of a reasonable
range?
Outlier detection using the COUNTIF function
Which of the following is a precursor to data wrangling?
Raw data input
What kind of record can be combined by using one-to-one merger?
Unique
Which of the following is the main purpose of creating a scatter chart in data visualization?
To show the relationship between two quantitative variables
What is the main purpose of adding a trendline to scatter charts and line charts in data visualization?
To show an approximation of the relationship between two variables over time
What is a clustered column in data visualization?
A type of bar chart that displays data as clusters of columns
What is the primary purpose of KPI data visualization?
To deliver summary information with live monitoring and alerting
Which of the following should be considered when designing a table for business analytics purposes?
Eliminating unnecessary ink usage
When should tables be used in business analytics?
To refer to specific numerical value
What is the data-ink ratio in data visualization?
The ratio of data-ink to non-data ink in a table or chart
Treemaps are used in data visualization to
represent categorical data.
What is the purpose of adding a trend line?
To provide an approximation of the relationship between the variables
, Which of the following is an example of a data dashboard in data visualization?
Tableau
Which of the following best describes a bubble chart?
A graphical means of visualizing three variables in a two-dimensional graph
What is a stacked column chart?
A type of bar chart that displays data as stacked bars
What is the purpose of a bar chart?
To display the magnitude of the quantitative data
Which of the following is a choropleth map used to create?
Geographic thematic map
Which of the following best describes a cartogram?
A color-coded map that represents data as areas or proportions
Which of the following is best used to visualize relationships between multiple variables?
Scatter chart matrix
What type of visualization tool is a heat map?
2D color plot
What role do preattentive attributes play in business analytics?
Reducing the cognitive load required by the user to interpret the visualization
How many axes does a sparkline typically contain?
No axes
What is the purpose of line charts in data visualization?
To show the change in one variable over time
Every day, logistics companies such as United Parcel Service (UPS) must decide how to route their
trucks, that is, the order in which to deliver the packages that have been loaded on a truck. UPS
developed a system called ORION (On-Road Integrated Optimization and Navigation) which
dynamically routes its trucks based on packages on the truck and traffic conditions. It is estimated
that ORION saves UPS about 10 million gallons of fuel per year. Is ORION an example of descriptive,
predictive, or prescriptive analytics? Explain.
Because ORION dynamically --- truck route based on packages and traffic conditions, it is an example
of --- analytics.
yields the best, prescriptive
