MSIS 3223 Quizzes With Correct
Answers!!
False - ANSWERDescriptive analytics helps detect hidden patterns in large quantities of data to group
data into sets to predict behavior (T/F).
False - ANSWERA 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 - ANSWERPrescriptive analytics can help a company address the best way of shipping goods
from their factories to minimize costs (T/F).
False - ANSWERAnalyzing the problem is the first phase in decision making (T/F).
True - ANSWERProduct mix is determined by top managers (T/F).
True - ANSWERA deterministic model is one in which all model input information is either known or
assumed to be known with certainty (T/F).
True - ANSWERThe demand for professionals with analytics expertise has skyrocketed (T/F).
True - ANSWERModern business analytics can be viewed as an integration of Business Intelligence,
Information Systems, statistics, and modeling and optimization (T/F).
True - ANSWERStatistics 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 - ANSWERDecision models typically have three types of input: Data, uncontrollable inputs, and
decision options (T/F).
True - ANSWERAND(condition 1, condition 2...) is a logical function that returns TRUE if all conditions
are true and FALSE if not (T/F).
, True - ANSWERThe Pareto principle is often called the "80--20 rule" (T/F).
False - ANSWERThe filter tool extracts records meeting the specified criteria, deleting any records
that don't match the criteria (T/F).
True - ANSWERThree useful logical functions in business analytics applications are IF, AND, and OR
followed by conditions in parentheses (T/F).
True - ANSWERForm 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 - ANSWERPivotTables may be used to facilitate data visualization and statistical analysis of data
sets (T/F).
False - ANSWERExcel has a tool called 'dicers' for drilling down data in a PivotTable to display as
subject of that data (T/F).
True - ANSWERA database is a collection of related files (tables) containing records on people, places,
or things (T/F).
False - ANSWEREmpirical data is data that comes from an organization's daily operations (T/F).
True - ANSWERA data set is simply a collection of data (T/F).
True - ANSWERDashboards may include tabular as well as visual data to help a manager to quickly
locate key information (T/F).
True - ANSWERExcel distinguishes between vertical and horizontal bar charts, calling the former
column charts and the latter bar charts (T/F).
True - ANSWERLine charts provide a useful means for displaying data over time (T/F).
True - ANSWERA bubble chart is a type of scatter chart that provides a way to plot three variables in
two dimensions (T/F).
Answers!!
False - ANSWERDescriptive analytics helps detect hidden patterns in large quantities of data to group
data into sets to predict behavior (T/F).
False - ANSWERA 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 - ANSWERPrescriptive analytics can help a company address the best way of shipping goods
from their factories to minimize costs (T/F).
False - ANSWERAnalyzing the problem is the first phase in decision making (T/F).
True - ANSWERProduct mix is determined by top managers (T/F).
True - ANSWERA deterministic model is one in which all model input information is either known or
assumed to be known with certainty (T/F).
True - ANSWERThe demand for professionals with analytics expertise has skyrocketed (T/F).
True - ANSWERModern business analytics can be viewed as an integration of Business Intelligence,
Information Systems, statistics, and modeling and optimization (T/F).
True - ANSWERStatistics 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 - ANSWERDecision models typically have three types of input: Data, uncontrollable inputs, and
decision options (T/F).
True - ANSWERAND(condition 1, condition 2...) is a logical function that returns TRUE if all conditions
are true and FALSE if not (T/F).
, True - ANSWERThe Pareto principle is often called the "80--20 rule" (T/F).
False - ANSWERThe filter tool extracts records meeting the specified criteria, deleting any records
that don't match the criteria (T/F).
True - ANSWERThree useful logical functions in business analytics applications are IF, AND, and OR
followed by conditions in parentheses (T/F).
True - ANSWERForm 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 - ANSWERPivotTables may be used to facilitate data visualization and statistical analysis of data
sets (T/F).
False - ANSWERExcel has a tool called 'dicers' for drilling down data in a PivotTable to display as
subject of that data (T/F).
True - ANSWERA database is a collection of related files (tables) containing records on people, places,
or things (T/F).
False - ANSWEREmpirical data is data that comes from an organization's daily operations (T/F).
True - ANSWERA data set is simply a collection of data (T/F).
True - ANSWERDashboards may include tabular as well as visual data to help a manager to quickly
locate key information (T/F).
True - ANSWERExcel distinguishes between vertical and horizontal bar charts, calling the former
column charts and the latter bar charts (T/F).
True - ANSWERLine charts provide a useful means for displaying data over time (T/F).
True - ANSWERA bubble chart is a type of scatter chart that provides a way to plot three variables in
two dimensions (T/F).
