Question 1

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

Accepted Answer

Filtering in business analytics often involves applying complex conditions to large datasets to extract relevant information for analysis.

Question 2

True or False: 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
consumes.

Accepted Answer

False

Question 3

Which of the following disciplines is typically NOT involved in business analytics?

Accepted Answer

Economics is typically not directly involved in business analytics. However, knowledge of economic principles may be useful in interpreting analytics results. Statistics, information systems, and management science are all important in business analytics.

Question 4

True or False: 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

Gauges in Excel are used for visualizing data, not for filtering or exploring combinations of variables. Filtering and exploring data typically involve using tools like pivot tables or filters, not gauges.

Question 5

True or False: 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

A slicer in Excel is a tool that allows users to filter data by selecting specific values or ranges, similar to the process of narrowing down variables in business analytics.

Question 6

True or False: 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

Chartjunk refers to unnecessary or distracting decorations in data visualization. Using color to represent a second variable in bullet graphs enhances data understanding rather than detracting from it.

Question 7

True or False: 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

The answer of True or False: Some business analytics involve...

Question 8

True or False: 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

Chartjunk refers to unnecessary or distracting decorations in data visualizations. Using color in treemaps to represent a second variable enhances the data's informational value rather than detracting from it.

Question 9

Which of the following finds relationships in data that may not be readily apparent?

Accepted Answer

Predictive analytics uses statistical algorithms and machine learning techniques to analyze historical data and make predictions about future events or trends. It can identify relationships between different variables that may not be immediately apparent, providing insights that can inform strategic decision-making. Prescriptive analytics, on the other hand, goes beyond predicting what will happen and recommends specific actions to take in order to achieve desired outcomes. Productive analytics is not a commonly recognized term, and descriptive analytics simply summarizes past data without necessarily identifying hidden relationships.

Question 10

True or False: 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 because they allow for direct comparison of measurements against a target, providing more context and clarity than gauges.

Question 11

Dashboards may contain all but which of the following?

Accepted Answer

Contingency table is not typically included in dashboards, as it is a table displaying the frequency distribution of two or more variables. The other options (Treemaps, Gauges, and Bullet graphs) are commonly used in dashboards to display information in a clear and concise manner.

Question 12

True or False: 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 can be considered chartjunk because they often use a lot of space for minimal information, but they are still popular for their visual appeal.

Question 13

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

Accepted Answer

Double-clicking a cell in a PivotTable in Excel will indeed drill down and display the underlying data in a new worksheet, showing the detailed records that make up the summarized data in that cell.

Question 14

Which of the following is NOT among the three broad categories of analytic methods?

Accepted Answer

The three broad categories of analytic methods are Descriptive analytics, Predictive analytics, and Prescriptive analytics. Productive Analytics is not a category of analytic methods.

Question 15

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

Accepted Answer

Prescriptive analytics investigates what should occur and suggests the best course of action for the future by using data, algorithms, and machine learning to recommend decisions.

Question 16

Dashboards may contain all but which of the following?

Accepted Answer

Dashboards can contain sparklines, gauges, and bullet graphs to visualize data, but a contingency table is not typically used in dashboards. Contingency tables are useful for showing the relationship between two categorical variables, but they are not as effective at providing a quick summary of overall data trends as other types of visualizations.

Question 17

True or False: 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

Business analytics often involves starting with a large dataset containing many variables and then filtering or narrowing down the data by exploring specific combinations of categorical values or numerical ranges to identify patterns, trends, or insights.

Question 18

Which of the following explores business activities that have occurred or are occurring in the
Present moment?

Accepted Answer

Descriptive analytics focuses on analyzing past and current data to understand what has happened or is happening in the present moment.

Question 19

True or False: Some business analytics are performed by adding variables to see if unforeseen
relationships are uncovered.

Accepted Answer

Adding variables in business analytics can help uncover unforeseen relationships by providing new perspectives and insights into the data.

Question 20

True or False: 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

A drill-down in a PivotTable creates a new worksheet with detailed data, allowing you to compute numerical descriptive statistics for its variables.

Quiz 17: Business Analytics

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

True or False: 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 consumes.

Which of the following disciplines is typically NOT involved in business analytics?

True or False: 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.

True or False: 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.

True or False: 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.

True or False: 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.

True or False: 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.

Which of the following finds relationships in data that may not be readily apparent?

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

Dashboards may contain all but which of the following?

True or False: 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.

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

Which of the following is NOT among the three broad categories of analytic methods?

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

Dashboards may contain all but which of the following?

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

Which of the following explores business activities that have occurred or are occurring in the Present moment?

True or False: Some business analytics are performed by adding variables to see if unforeseen relationships are uncovered.

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