MSIS 3223 QUIZZES WITH CORRECT
ANSWERS
False - Correct Answers -Descriptive analytics helps detect hidden patterns in large
quantities of data to group data into sets to predict behavior (T/F).
False - Correct Answers -A manager at Academy wishes to know the company's
revenue and profit in its previous quarter. Predictive analytics is what the manager
should use for this task (T/F).
True - Correct Answers -Prescriptive analytics can help a company address the best
way of shipping goods from their factories to minimize costs (T/F).
False - Correct Answers -Analyzing the problem is the first phase in decision making
(T/F).
True - Correct Answers -Product mix is determined by top managers (T/F).
True - Correct Answers -A deterministic model is one in which all model input
information is either known or assumed to be known with certainty (T/F).
True - Correct Answers -The demand for professionals with analytics expertise has
skyrocketed (T/F).
True - Correct Answers -Modern business analytics can be viewed as an integration of
Business Intelligence, Information Systems, statistics, and modeling and optimization
(T/F).
True - Correct Answers -Statistics has a long and rich history, yet only rather recently
has it been recognized as an important element of business, driven to a large extent by
the massive growth of data in today's world (T/F).
True - Correct Answers -Decision models typically have three types of input: Data,
uncontrollable inputs, and decision options (T/F).
True - Correct Answers -AND(condition 1, condition 2...) is a logical function that returns
TRUE if all conditions are true and FALSE if not (T/F).
True - Correct Answers -The Pareto principle is often called the "80--20 rule" (T/F).
, False - Correct Answers -The filter tool extracts records meeting the specified criteria,
deleting any records that don't match the criteria (T/F).
True - Correct Answers -Three useful logical functions in business analytics applications
are IF, AND, and OR followed by conditions in parentheses (T/F).
True - Correct Answers -Form controls are buttons, boxes, and other mechanisms for
inputting or changing data on spreadsheets easily and used to design user-friendly
spreadsheets (T/F).
True - Correct Answers -PivotTables may be used to facilitate data visualization and
statistical analysis of data sets (T/F).
False - Correct Answers -Excel has a tool called 'dicers' for drilling down data in a
PivotTable to display as subject of that data (T/F).
True - Correct Answers -A database is a collection of related files (tables) containing
records on people, places, or things (T/F).
False - Correct Answers -Empirical data is data that comes from an organization's daily
operations (T/F).
True - Correct Answers -A data set is simply a collection of data (T/F).
True - Correct Answers -Dashboards may include tabular as well as visual data to help
a manager to quickly locate key information (T/F).
True - Correct Answers -Excel distinguishes between vertical and horizontal bar charts,
calling the former column charts and the latter bar charts (T/F).
True - Correct Answers -Line charts provide a useful means for displaying data over
time (T/F).
True - Correct Answers -A bubble chart is a type of scatter chart that provides a way to
plot three variables in two dimensions (T/F).
True - Correct Answers -Color scales shade scales based on their numerical value
using a color palette. This is an option in the Conditional Formatting menu (T/F).
True - Correct Answers -Data visualization is the process of displaying data in a
meaningful fashion to provide insights that will support better decisions (T/F).
False - Correct Answers -An area chart combines the features of bubble charts with
those of line charts (T/F).
True - Correct Answers -Radar charts show multiple metrics on a spider web (T/F).
ANSWERS
False - Correct Answers -Descriptive analytics helps detect hidden patterns in large
quantities of data to group data into sets to predict behavior (T/F).
False - Correct Answers -A manager at Academy wishes to know the company's
revenue and profit in its previous quarter. Predictive analytics is what the manager
should use for this task (T/F).
True - Correct Answers -Prescriptive analytics can help a company address the best
way of shipping goods from their factories to minimize costs (T/F).
False - Correct Answers -Analyzing the problem is the first phase in decision making
(T/F).
True - Correct Answers -Product mix is determined by top managers (T/F).
True - Correct Answers -A deterministic model is one in which all model input
information is either known or assumed to be known with certainty (T/F).
True - Correct Answers -The demand for professionals with analytics expertise has
skyrocketed (T/F).
True - Correct Answers -Modern business analytics can be viewed as an integration of
Business Intelligence, Information Systems, statistics, and modeling and optimization
(T/F).
True - Correct Answers -Statistics has a long and rich history, yet only rather recently
has it been recognized as an important element of business, driven to a large extent by
the massive growth of data in today's world (T/F).
True - Correct Answers -Decision models typically have three types of input: Data,
uncontrollable inputs, and decision options (T/F).
True - Correct Answers -AND(condition 1, condition 2...) is a logical function that returns
TRUE if all conditions are true and FALSE if not (T/F).
True - Correct Answers -The Pareto principle is often called the "80--20 rule" (T/F).
, False - Correct Answers -The filter tool extracts records meeting the specified criteria,
deleting any records that don't match the criteria (T/F).
True - Correct Answers -Three useful logical functions in business analytics applications
are IF, AND, and OR followed by conditions in parentheses (T/F).
True - Correct Answers -Form controls are buttons, boxes, and other mechanisms for
inputting or changing data on spreadsheets easily and used to design user-friendly
spreadsheets (T/F).
True - Correct Answers -PivotTables may be used to facilitate data visualization and
statistical analysis of data sets (T/F).
False - Correct Answers -Excel has a tool called 'dicers' for drilling down data in a
PivotTable to display as subject of that data (T/F).
True - Correct Answers -A database is a collection of related files (tables) containing
records on people, places, or things (T/F).
False - Correct Answers -Empirical data is data that comes from an organization's daily
operations (T/F).
True - Correct Answers -A data set is simply a collection of data (T/F).
True - Correct Answers -Dashboards may include tabular as well as visual data to help
a manager to quickly locate key information (T/F).
True - Correct Answers -Excel distinguishes between vertical and horizontal bar charts,
calling the former column charts and the latter bar charts (T/F).
True - Correct Answers -Line charts provide a useful means for displaying data over
time (T/F).
True - Correct Answers -A bubble chart is a type of scatter chart that provides a way to
plot three variables in two dimensions (T/F).
True - Correct Answers -Color scales shade scales based on their numerical value
using a color palette. This is an option in the Conditional Formatting menu (T/F).
True - Correct Answers -Data visualization is the process of displaying data in a
meaningful fashion to provide insights that will support better decisions (T/F).
False - Correct Answers -An area chart combines the features of bubble charts with
those of line charts (T/F).
True - Correct Answers -Radar charts show multiple metrics on a spider web (T/F).
