Question 1

Which of the following investigates what should occur and suggest the best course of action for the future?
A)Predictive analytics
B)Prescriptive analytics
C)Productive analytics
D)Descriptive analytics

Accepted Answer

Prescriptive analytics investigates what should occur and suggests the best course of action for the future. It combines historical data, real-time data, and predictive analytics to provide recommendations on what steps to take to achieve a desired outcome. Predictive analytics analyzes historical data to make future predictions, descriptive analytics summarizes past data, and productive analytics is not a common term in the field of analytics.

Question 2

Treemaps that use color to represent the value of a second variable,thereby increasing the data density of the displays,is an example of chartjunk.

Accepted Answer

Treemaps that use color to represent a second variable do not necessarily increase chartjunk, as this can help to provide additional information and insights. However, it is important to use color in a meaningful and appropriate way, rather than simply adding unnecessary complexity to the visualization.

Question 3

Some business analytics involve starting with many variables,followed by filtering the data by exploring specific combinations of categorical values or numerical range.In Excel,this approach is mimicked by using a slicer.

Accepted Answer

This statement is true. Slicers in Excel allows the user to filter data by exploring specific combinations of categorical values or numerical range.

Question 4

Dashboards may contain all but which of the following?
A)Treemaps
B)Gauges
C)Contingency table
D)Bullet graphs

Accepted Answer

The answer of Dashboards may contain all but which of...

Question 5

Dashboards may contain all but which of the following?
A)Contingency table
B)Sparklines
C)Gauges
D)Bullet graphs

Accepted Answer

Dashboards typically contain visual representations of data such as sparklines, gauges, and bullet graphs in order to provide quick and easy insights. While contingency tables are useful for presenting categorical data, they are not typically included in dashboards due to their text-heavy nature and limited ability to quickly convey information.

Question 6

Bullet graphs that use color to represent the value of a second variable,thereby increasing the data density of the displays,is an example of chartjunk.

Accepted Answer

Bullet graphs that use color to represent a second variable are not considered chartjunk, as they serve a purpose in increasing the data density of the display.

Question 7

Some business analytics are performed by adding variables to see if unforeseen relationships are uncovered.

Accepted Answer

This is true. Adding variables can help identify unexpected patterns and relationships in the data. This is commonly referred to as exploratory data analysis.

Question 8

Some consider bullet graphs little more than examples of chartjunk,even as many decision makers request them due to their visual appeal,due to the amount of the space they consume.

Accepted Answer

Bullet graphs are highly regarded for their efficiency and effectiveness in displaying performance data in a compact space, making them popular among decision makers for their clarity and ability to facilitate quick comparisons, rather than being considered chartjunk.

Question 9

Some business analytics involve starting with many variables,followed by filtering the data by exploring specific combinations of categorical values or numerical range.In Excel,this approach is mimicked by using a drill-down.

Accepted Answer

Drill-down in Excel typically refers to navigating from a summary view to more detailed data, not filtering by specific combinations or ranges.

Question 10

In real-world business analytics,filtering is typically performed on large data based on complex conditional relationships.

Accepted Answer

Filtering in real-world business analytics often involves analyzing large datasets with intricate conditional relationships.

Question 11

Some consider gauges little more than examples of chartjunk,even as many decision makers request them due to their visual appeal,due to the amount of the space it consumes.

Accepted Answer

Gauges are often criticized for being little more than chartjunk and not providing meaningful information, even though decision makers may request them for their visual appeal. Additionally, gauges can take up a lot of space on a dashboard or report.

Question 12

Some business analytics involve starting with many variables,followed by filtering the data by exploring specific combinations of categorical values or numerical range.

Accepted Answer

This is true because many business analytics projects involve collecting large amounts of data, and then using filters and exploratory analysis to narrow down the data to specific subsets that are relevant to the problem being analyzed. This process often involves looking at combinations of categorical values (such as product categories or customer segments) or numerical ranges (such as sales revenue or customer satisfaction ratings).

Question 13

Which of the following is NOT among the three broad categories of analytic methods?
A)Predictive analytics
B)Prescriptive analytics
C)Productive analytics
D)Descriptive analytics

Accepted Answer

The three broad categories of analytic methods are predictive analytics, prescriptive analytics, and descriptive analytics. Productive analytics is not a recognized category of analytic methods.

Question 14

Which of the following finds relationships in data that may not be readily apparent?
A)Predictive analytics
B)Prescriptive analytics
C)Productive analytics
D)Descriptive analytics

Accepted Answer

Predictive analytics uses statistical techniques and algorithms to identify patterns and relationships in data, helping to forecast future outcomes or behaviors.

Question 15

Which of the following explores business activities that have occurred or are occurring in the present moment?
A)Predictive analytics
B)Prescriptive analytics
C)Productive analytics
D)Descriptive analytics

Accepted Answer

Descriptive analytics explores business activities that have occurred or are occurring in the present moment. Descriptive analytics uses past data to analyze historical patterns and gives insights into what has happened in the past.

Question 16

Which of the following disciplines is typically NOT involved in business analytics?
A)Economics
B)Statistics
C)Information system
D)Management science

Accepted Answer

Economics, while it can provide valuable insights for business analytics through understanding market trends and economic principles, is not typically considered a core discipline of business analytics. Business analytics more directly involves the application of statistics, information systems, and management science to analyze and interpret data for business decision-making.

Question 17

Some business analytics involve starting with many variables,followed by filtering the data by exploring specific combinations of categorical values or numerical range.In Excel,this approach is mimicked by using gauges.

Accepted Answer

The statement is incorrect. In Excel, this approach can be mimicked by using pivot tables and filtering capabilities, not gauges.

Question 18

You can compute any of the numerical descriptive statistics for the variables of the new worksheet that a drill-down in a PivotTable creates.

Accepted Answer

Yes, you can compute any of the numerical descriptive statistics such as mean, median, mode, standard deviation, range, etc. for the variables in a worksheet that is created by drilling down into a PivotTable.

Question 19

Most information design specialists prefer bullet graphs over gauges because bullet graphs foster the direct comparison of each measurement.

Accepted Answer

Bullet graphs are preferred over gauges for direct comparison of measurements.

Question 20

Double-clicking a cell in a PivotTable causes Excel to drill down and display the underlying data in a new worksheet.

Accepted Answer

The answer of Double-clicking a cell in a PivotTable causes...

Quiz 17: Business Analytics

Which of the following investigates what should occur and suggest the best course of action for the future?