Question 1

What is big data?

Accepted Answer

Big data is the huge amount of

Question 2

Which of the following business analytics tools take(s) large volumes of data and potential variables to form groupings of variables to identify complex paths and associations?

Accepted Answer

A)  neural networks 
B)  cohort analysis 
C)  opinion mining 
D)  mapping and tracking 
E)  cluster analysis 
A)  neural networks 
B)  cohort analysis 
C)  opinion mining 
D)  mapping and tracking 
E)  cluster analysis

Question 3

Data consistency refers to the degree of conformity of a measure to a standard value.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following statements is TRUE?

Accepted Answer

A)  Predictive analytics invokes advanced optimization tools to recommend a strategy or action. 
B)  Descriptive analytics analyzes past data to predict the future. 
C)  Prescriptive analytics characterizes and summaries data to facilitate understanding. 
D)  Descriptive analytics characterizes and summaries data to facilitate understanding. 
E)  Prescriptive analytics analyzes past data to predict the future. 
A)  Predictive analytics invokes advanced optimization tools to recommend a strategy or action. 
B)  Descriptive analytics analyzes past data to predict the future. 
C)  Prescriptive analytics characterizes and summaries data to facilitate understanding. 
D)  Descriptive analytics characterizes and summaries data to facilitate understanding. 
E)  Prescriptive analytics analyzes past data to predict the future.

Question 5

An analytics manager, Carole, is reviewing the performance data of fifteen branch stores. She wants to create a heat map using the color scale Green-White-Red.
a. Help Carole create the color map. What steps are required?
b. What color will Branch 1's cell be? Branch 9's cell?

Accepted Answer

a. Select B4:B18; Conditional

Question 6

An analytics manager, Lauren, is reviewing the performance data of fifteen branch stores. She wants to create a heat map with symbols as in the figure below. What tool should she use?

Accepted Answer

A)  Select B4:B18; PivotTable 
B)  Select B4:B18; Conditional Formatting; Highlight Cells Rules 
C)  Select B4:B18; Conditional Formatting; Icon Sets 
D)  Select B1:B18; Conditional Formatting; Icon Sets 
E)  Select B4:B18; Conditional Formatting; Data Bars 
A)  Select B4:B18; PivotTable 
B)  Select B4:B18; Conditional Formatting; Highlight Cells Rules 
C)  Select B4:B18; Conditional Formatting; Icon Sets 
D)  Select B1:B18; Conditional Formatting; Icon Sets 
E)  Select B4:B18; Conditional Formatting; Data Bars

Question 7

Which of the following is NOT one of the four categories (areas) to click-and-drag fields into when using the PivotTable function?

Accepted Answer

A)  Filters 
B)  Rows 
C)  Columns 
D)  Values 
E)  Buckets 
A)  Filters 
B)  Rows 
C)  Columns 
D)  Values 
E)  Buckets

Question 8

What tool does UPS use to analyze more than 1 billion data points each day?

Accepted Answer

A)  predictive analytics 
B)  descriptive analytics 
C)  prescriptive analytics 
D)  descriptive statistics 
E)  variance analysis 
A)  predictive analytics 
B)  descriptive analytics 
C)  prescriptive analytics 
D)  descriptive statistics 
E)  variance analysis

Question 9

Data management is about using tools and techniques to convert data into summary information and business insights for decision making.

Accepted Answer

A) True 
 B)False

Question 10

The management task with business analytics is all about gathering as much data as possible.

Accepted Answer

A) True 
 B)False

Question 11

An analytics manager, Mark, highlighted all empty cells using Excel's Conditional Formatting tool for the following dataset. What steps did he take?

Accepted Answer

A)  Select A6:H17; Rule type: Format only cells that contain, select Blanks; Color yellow. 
B)  Select A6:H17; Rule type: Format only cells that contain, select 0; Color yellow. 
C)  Select A1:H12; Rule type: Format only cells that contain, select Blanks; Color yellow. 
D)  Select A1:H12; Rule type: Format only top or bottom ranked values, select bottom 10%; Color yellow. 
E)  Select A6:H17; Rule type: Format only top or bottom ranked values, select bottom 5%; Color yellow. 
A)  Select A6:H17; Rule type: Format only cells that contain, select Blanks; Color yellow. 
B)  Select A6:H17; Rule type: Format only cells that contain, select 0; Color yellow. 
C)  Select A1:H12; Rule type: Format only cells that contain, select Blanks; Color yellow. 
D)  Select A1:H12; Rule type: Format only top or bottom ranked values, select bottom 10%; Color yellow. 
E)  Select A6:H17; Rule type: Format only top or bottom ranked values, select bottom 5%; Color yellow.

Question 12

Explain the three requirements of data integrity.

Accepted Answer

Data integrity requires that data be: co

Question 13

The three categories of analytics are ________, ________, and ________.

Accepted Answer

descriptiv

Question 14

It is impossible to include more than one field in the Rows area or the Columns area in a PivotTable.

Accepted Answer

A) True 
 B)False

Question 15

What is a PivotTable?

Accepted Answer

A PivotTable is a tool to faci

Question 16

An analytics manager, Lawrence, wants to clean the following dataset using Excel's Conditional Formatting tool. What steps should he take if he wants to make sure that any suppliers that have more than 8% returns should not receive a quality rating of 5? Highlight those cells using red.

Accepted Answer

A)  Select D6:D17; Rule type: Formula, enter =AND(F6=5,H6>0.08); Color red. 
B)  Select D6:F17; Rule type: Formula, enter =AND(F6=5,H6>0.08); Color red. 
C)  Select D6:D17; Rule type: Formula, enter =AND(F6=5,H60.08); Color red. 
E)  Select D1:D17; Rule type: Formula, enter =AND(F6=5,H6=0.08); Color red. 
A)  Select D6:D17; Rule type: Formula, enter =AND(F6=5,H6>0.08); Color red. 
B)  Select D6:F17; Rule type: Formula, enter =AND(F6=5,H6>0.08); Color red. 
C)  Select D6:D17; Rule type: Formula, enter =AND(F6=5,H60.08); Color red. 
E)  Select D1:D17; Rule type: Formula, enter =AND(F6=5,H6=0.08); Color red.

Question 17

An analytics manager, Petra, wants to clean the following dataset using Excel's Conditional Formatting tool. What steps should she take if she wants to highlight any percentages in Column E that are not between 0% and 100% using a light blue color?

Accepted Answer

A)  Select E6:E17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue. 
B)  Select A6:EH7; Rule type: Format only cells that contain, select Cell value, then less than, then 1; Color light blue. 
C)  Select E6:F17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue. 
D)  Select E1:E17; Rule type: Format only cells that contain, select Cell value, then more than, then 1; Color light blue. 
E)  Select C6:F17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue. 
A)  Select E6:E17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue. 
B)  Select A6:EH7; Rule type: Format only cells that contain, select Cell value, then less than, then 1; Color light blue. 
C)  Select E6:F17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue. 
D)  Select E1:E17; Rule type: Format only cells that contain, select Cell value, then more than, then 1; Color light blue. 
E)  Select C6:F17; Rule type: Format only cells that contain, select Cell value, then not between, then 0 and 1; Color light blue.

Question 18

Data can be stored three ways: ________, ________, or ________.

Accepted Answer

character,

Question 19

Data collection is so massive that it is now measured in megabytes.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following data visualization graphs represents percentages or portions of a whole?

Accepted Answer

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

Exam 23: Applying Analytics to Big Data in Operations Management

What is big data?

Which of the following business analytics tools take(s) large volumes of data and potential variables to form groupings of variables to identify complex paths and associations?

Data consistency refers to the degree of conformity of a measure to a standard value.

Which of the following statements is TRUE?

An analytics manager, Carole, is reviewing the performance data of fifteen branch stores. She wants to create a heat map using the color scale Green-White-Red. a. Help Carole create the color map. What steps are required? b. What color will Branch 1's cell be? Branch 9's cell?

An analytics manager, Lauren, is reviewing the performance data of fifteen branch stores. She wants to create a heat map with symbols as in the figure below. What tool should she use?

Which of the following is NOT one of the four categories (areas) to click-and-drag fields into when using the PivotTable function?

What tool does UPS use to analyze more than 1 billion data points each day?

Data management is about using tools and techniques to convert data into summary information and business insights for decision making.

The management task with business analytics is all about gathering as much data as possible.

An analytics manager, Mark, highlighted all empty cells using Excel's Conditional Formatting tool for the following dataset. What steps did he take?

Explain the three requirements of data integrity.

The three categories of analytics are ________, ________, and ________.

It is impossible to include more than one field in the Rows area or the Columns area in a PivotTable.

What is a PivotTable?

An analytics manager, Lawrence, wants to clean the following dataset using Excel's Conditional Formatting tool. What steps should he take if he wants to make sure that any suppliers that have more than 8% returns should not receive a quality rating of 5? Highlight those cells using red.

An analytics manager, Petra, wants to clean the following dataset using Excel's Conditional Formatting tool. What steps should she take if she wants to highlight any percentages in Column E that are not between 0% and 100% using a light blue color?

Data can be stored three ways: ________, ________, or ________.

Data collection is so massive that it is now measured in megabytes.

Which of the following data visualization graphs represents percentages or portions of a whole?

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

The three categories of analytics are , , and .

Data can be stored three ways: , , or .