MSIS 3223 Exam Questions with Verified
Correct Answers
False
Descriptive analytics helps detect hidden patterns in large quantities of data to group data into
sets to predict behavior (T/F).
False
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
Prescriptive analytics can help a company address the best way of shipping goods from their
factories to minimize costs (T/F).
False
Analyzing the problem is the first phase in decision making (T/F).
True
Product mix is determined by top managers (T/F).
True
A deterministic model is one in which all model input information is either known or
assumed to be known with certainty (T/F).
True
The demand for professionals with analytics expertise has skyrocketed (T/F).
True
,Modern business analytics can be viewed as an integration of Business Intelligence,
Information Systems, statistics, and modeling and optimization (T/F).
True
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
Decision models typically have three types of input: Data, uncontrollable inputs, and decision
options (T/F).
True
AND(condition 1, condition 2...) is a logical function that returns TRUE if all conditions are
true and FALSE if not (T/F).
True
The Pareto principle is often called the "80--20 rule" (T/F).
False
The filter tool extracts records meeting the specified criteria, deleting any records that don't
match the criteria (T/F).
True
Three useful logical functions in business analytics applications are IF, AND, and OR
followed by conditions in parentheses (T/F).
True
, 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
PivotTables may be used to facilitate data visualization and statistical analysis of data sets
(T/F).
False
Excel has a tool called 'dicers' for drilling down data in a PivotTable to display as subject of
that data (T/F).
True
A database is a collection of related files (tables) containing records on people, places, or
things (T/F).
False
Empirical data is data that comes from an organization's daily operations (T/F).
True
A data set is simply a collection of data (T/F).
True
Dashboards may include tabular as well as visual data to help a manager to quickly locate key
information (T/F).
True
Excel distinguishes between vertical and horizontal bar charts, calling the former column
charts and the latter bar charts (T/F).
Correct Answers
False
Descriptive analytics helps detect hidden patterns in large quantities of data to group data into
sets to predict behavior (T/F).
False
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
Prescriptive analytics can help a company address the best way of shipping goods from their
factories to minimize costs (T/F).
False
Analyzing the problem is the first phase in decision making (T/F).
True
Product mix is determined by top managers (T/F).
True
A deterministic model is one in which all model input information is either known or
assumed to be known with certainty (T/F).
True
The demand for professionals with analytics expertise has skyrocketed (T/F).
True
,Modern business analytics can be viewed as an integration of Business Intelligence,
Information Systems, statistics, and modeling and optimization (T/F).
True
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
Decision models typically have three types of input: Data, uncontrollable inputs, and decision
options (T/F).
True
AND(condition 1, condition 2...) is a logical function that returns TRUE if all conditions are
true and FALSE if not (T/F).
True
The Pareto principle is often called the "80--20 rule" (T/F).
False
The filter tool extracts records meeting the specified criteria, deleting any records that don't
match the criteria (T/F).
True
Three useful logical functions in business analytics applications are IF, AND, and OR
followed by conditions in parentheses (T/F).
True
, 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
PivotTables may be used to facilitate data visualization and statistical analysis of data sets
(T/F).
False
Excel has a tool called 'dicers' for drilling down data in a PivotTable to display as subject of
that data (T/F).
True
A database is a collection of related files (tables) containing records on people, places, or
things (T/F).
False
Empirical data is data that comes from an organization's daily operations (T/F).
True
A data set is simply a collection of data (T/F).
True
Dashboards may include tabular as well as visual data to help a manager to quickly locate key
information (T/F).
True
Excel distinguishes between vertical and horizontal bar charts, calling the former column
charts and the latter bar charts (T/F).
