Question 1

Which of the following Excel functions is NOT used to facilitate quick accuracy checks on the extreme values?

Accepted Answer

A)  MIN 
B)  SMALL 
C)  MEDIAN 
D)  MAX 
E)  LARGE 
A)  MIN 
B)  SMALL 
C)  MEDIAN 
D)  MAX 
E)  LARGE C

Question 2

Digital data can be collected from web sites, credit cards, point-of-sale records, social media, and operational environments.

Accepted Answer

A) True 
 B)False  True

Question 3

Explain neural networks and machine learning.

Accepted Answer

Neural networks are computer systems, which, guided by statistical techniques, take large volumes of data and potential variables to form groupings of variables to identify complex paths and associations. Machine learning often builds on these paths and associations to make science fiction a reality by creating speech recognition and self-driving cars. As applied to analytics, machine learning provides a vehicle to sift through vast amounts of big data to provide insight.

Question 4

One terabyte equals approximately one billion bytes.

Accepted Answer

A) True 
 B)False

Question 5

________ is an Excel tool to visually identify characteristics of data using formatting.

Accepted Answer

Conditiona

Question 6

Define three categories of analytics.

Accepted Answer

The three categories of analytics are de

Question 7

Which of the following business analytics tools identifies and organizes data into groups with similar attributes?

Accepted Answer

A)  linear programming 
B)  cohort analysis 
C)  opinion mining 
D)  mapping and tracking 
E)  cluster analysis 
A)  linear programming 
B)  cohort analysis 
C)  opinion mining 
D)  mapping and tracking 
E)  cluster analysis

Question 8

Data completeness refers to the degree to which all required data are present.

Accepted Answer

A) True 
 B)False

Question 9

What Excel formula should be used to count the number of empty cells in the following dataset?

Accepted Answer

A)  COUNTIF(A6:H17, "") 
B)  COUNTIF(A1:H17, "") 
C)  COUNTIF(A6:H17, 0) 
D)  COUNTIF(A1:H17, Empty) 
E)  COUNT(A6:H17, "") 
A)  COUNTIF(A6:H17, "") 
B)  COUNTIF(A1:H17, "") 
C)  COUNTIF(A6:H17, 0) 
D)  COUNTIF(A1:H17, Empty) 
E)  COUNT(A6:H17, "")

Question 10

Which of the following data visualization graphs uses arcs and nodes to provide a representation of flow through a system?

Accepted Answer

A)  bar graph 
B)  line graph 
C)  slope graph 
D)  network diagram 
E)  scatter diagram 
A)  bar graph 
B)  line graph 
C)  slope graph 
D)  network diagram 
E)  scatter diagram

Question 11

Descriptive analytics characterizes and summarizes data to facilitate understanding.

Accepted Answer

A) True 
 B)False

Question 12

Perform a visual inspection on the following dataset. Identify the number of cells that need to be cleaned in Column D.

Accepted Answer

A)  0 
B)  1 
C)  2 
D)  4 
E)  5 
A)  0 
B)  1 
C)  2 
D)  4 
E)  5

Question 13

Which of the following business analytics tools is designed to explore very large datasets, looking for relevant patterns or relationships?

Accepted Answer

A)  data mining 
B)  cluster analysis 
C)  mapping and tracking 
D)  cohort analysis 
E)  linear programming 
A)  data mining 
B)  cluster analysis 
C)  mapping and tracking 
D)  cohort analysis 
E)  linear programming

Question 14

In a ________, the highest and lowest values are highlighted.

Accepted Answer

A)  PivotTable 
B)  heat map 
C)  color map 
D)  heat zone 
E)  visual inspection 
A)  PivotTable 
B)  heat map 
C)  color map 
D)  heat zone 
E)  visual inspection

Question 15

Which of the following data visualization graphs illustrates relative increases or decreases of categories in time or at points of comparison?

Accepted Answer

A)  bar graph 
B)  line graph 
C)  slope graph 
D)  network diagram 
E)  scatter diagram 
A)  bar graph 
B)  line graph 
C)  slope graph 
D)  network diagram 
E)  scatter diagram

Question 16

The huge amount of production, consumer, and social media data collected in digital form is called ________.

Accepted Answer

A)  petabytes 
B)  big data 
C)  the big bang theory 
D)  prescriptive analytics 
E)  business analytics 
A)  petabytes 
B)  big data 
C)  the big bang theory 
D)  prescriptive analytics 
E)  business analytics

Question 17

A ________ in Excel's Conditional Formatting changes the Fill color of every cell by using a gradation of two or three different colors. ________ means more extreme.

Accepted Answer

A)  color scale; Darker 
B)  heat map; Darker 
C)  color map; Lighter 
D)  color scale; Lighter 
E)  color map; Darker 
A)  color scale; Darker 
B)  heat map; Darker 
C)  color map; Lighter 
D)  color scale; Lighter 
E)  color map; Darker

Question 18

Speech recognition and self-driving cars are applications of:

Accepted Answer

A)  machine learning 
B)  cohort analysis 
C)  opinion mining 
D)  mapping and tracking 
E)  cluster analysis 
A)  machine learning 
B)  cohort analysis 
C)  opinion mining 
D)  mapping and tracking 
E)  cluster analysis

Question 19

________ is a tool to facilitate in-depth analysis of numeric data by applying filters and providing summary computations for categories and subcategories of the dataset.

Accepted Answer

A)  COUNTIF 
B)  PivotTable 
C)  Graphical analysis 
D)  Visual inspection 
E)  Conditional Formatting 
A)  COUNTIF 
B)  PivotTable 
C)  Graphical analysis 
D)  Visual inspection 
E)  Conditional Formatting

Question 20

Data integrity requires that data be complete, consistent, and abundant.

Accepted Answer

A) True 
 B)False

Exam 23: Applying Analytics to Big Data in Operations Management

Which of the following Excel functions is NOT used to facilitate quick accuracy checks on the extreme values?

Digital data can be collected from web sites, credit cards, point-of-sale records, social media, and operational environments.

Explain neural networks and machine learning.

One terabyte equals approximately one billion bytes.

________ is an Excel tool to visually identify characteristics of data using formatting.

Define three categories of analytics.

Which of the following business analytics tools identifies and organizes data into groups with similar attributes?

Data completeness refers to the degree to which all required data are present.

What Excel formula should be used to count the number of empty cells in the following dataset?

Which of the following data visualization graphs uses arcs and nodes to provide a representation of flow through a system?

Descriptive analytics characterizes and summarizes data to facilitate understanding.

Perform a visual inspection on the following dataset. Identify the number of cells that need to be cleaned in Column D.

Which of the following business analytics tools is designed to explore very large datasets, looking for relevant patterns or relationships?

In a ________, the highest and lowest values are highlighted.

Which of the following data visualization graphs illustrates relative increases or decreases of categories in time or at points of comparison?

The huge amount of production, consumer, and social media data collected in digital form is called ________.

A ________ in Excel's Conditional Formatting changes the Fill color of every cell by using a gradation of two or three different colors. ________ means more extreme.

Speech recognition and self-driving cars are applications of:

________ is a tool to facilitate in-depth analysis of numeric data by applying filters and providing summary computations for categories and subcategories of the dataset.

Data integrity requires that data be complete, consistent, and abundant.

Operations and Productivity

Operations Strategy in a Global Environment

Project Management

Forecasting

Design of Goods and Services

Managing Quality

Process Strategies

Location Strategies

Human Resources, Job Design, and Work Measurement

Supply Chain Management

Inventory Management

Aggregate Planning and Sop

Material Requirements Planning Mrp and Erp

Short-Term Scheduling

Lean Operations

Maintenance and Reliability

Decision-Making Tools

Linear Programming

Transportation Models

Waiting-Line Models

Learning Curves

Simulation

Filters

A in Excel's Conditional Formatting changes the Fill color of every cell by using a gradation of two or three different colors. means more extreme.