MSIS 3223 - Exam 1 (Chapters 1-4)
questions and answers already
passed
Descriptive analytics helps detect hidden patterns in large quantities of data to group data unto
sets to predict behavior. - correct answer ✔✔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. - correct answer
✔✔False.
Prescriptive analytics can help a company address the best way of shipping goods from their
factories to minimize costs. - correct answer ✔✔True.
Analyzing the problem is the first phase in decision making. - correct answer ✔✔False.
A deterministic model is one in which all model input information is wither known or assumed
to be known with certainty. - correct answer ✔✔True.
The demand for professionals with analytics expertise has skyrocketed. - correct answer
✔✔True.
Modern business analytics can be viewed as an integration of Business Intelligence, Information
Systems, statistics, and modeling and optimization. - correct answer ✔✔True.
Statistics has a long 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. -
correct answer ✔✔True.
, Decision models typically have three types of input: Data, Uncontrollable Inputs, and Decision
Options. - correct answer ✔✔True.
A body weight scale is used to weigh patients in a clinic, but it reads weights one pound below
the true value. Which of the following is true about the data collected by this scale? - correct
answer ✔✔Data are valid.
AND(condition 1, condition 2...) is a logical function that returns TRUE if all conditions are true
and FALSE if not. - correct answer ✔✔True.
The Pareto principle is often called the "80--20 rule." - correct answer ✔✔True.
The filter tool extracts records meeting the specified criteria, deleting any records that don't
match the criteria. - correct answer ✔✔False.
Three useful logical functions in business analytics applications are IF, AND, and OR followed by
conditions in parentheses. - correct answer ✔✔True.
Form controls are buttons, boxes, and other mechanisms for inputting or changing data on
spreadsheets easily and used to design user-friendly spreadsheets. - correct answer ✔✔True.
PivotTables may be used to facilitate data visualization and statistical analysis of data sets. -
correct answer ✔✔True.
Excel has a tool called 'dicers' for drilling down data in a PivotTable to display as subset of that
data. - correct answer ✔✔False.
questions and answers already
passed
Descriptive analytics helps detect hidden patterns in large quantities of data to group data unto
sets to predict behavior. - correct answer ✔✔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. - correct answer
✔✔False.
Prescriptive analytics can help a company address the best way of shipping goods from their
factories to minimize costs. - correct answer ✔✔True.
Analyzing the problem is the first phase in decision making. - correct answer ✔✔False.
A deterministic model is one in which all model input information is wither known or assumed
to be known with certainty. - correct answer ✔✔True.
The demand for professionals with analytics expertise has skyrocketed. - correct answer
✔✔True.
Modern business analytics can be viewed as an integration of Business Intelligence, Information
Systems, statistics, and modeling and optimization. - correct answer ✔✔True.
Statistics has a long 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. -
correct answer ✔✔True.
, Decision models typically have three types of input: Data, Uncontrollable Inputs, and Decision
Options. - correct answer ✔✔True.
A body weight scale is used to weigh patients in a clinic, but it reads weights one pound below
the true value. Which of the following is true about the data collected by this scale? - correct
answer ✔✔Data are valid.
AND(condition 1, condition 2...) is a logical function that returns TRUE if all conditions are true
and FALSE if not. - correct answer ✔✔True.
The Pareto principle is often called the "80--20 rule." - correct answer ✔✔True.
The filter tool extracts records meeting the specified criteria, deleting any records that don't
match the criteria. - correct answer ✔✔False.
Three useful logical functions in business analytics applications are IF, AND, and OR followed by
conditions in parentheses. - correct answer ✔✔True.
Form controls are buttons, boxes, and other mechanisms for inputting or changing data on
spreadsheets easily and used to design user-friendly spreadsheets. - correct answer ✔✔True.
PivotTables may be used to facilitate data visualization and statistical analysis of data sets. -
correct answer ✔✔True.
Excel has a tool called 'dicers' for drilling down data in a PivotTable to display as subset of that
data. - correct answer ✔✔False.
