Edrftgyihu jiuh
TU S
Spreadsheet Modeling and
Decision Analysis: A Practical
VI U
Introduction to Business
T
A_V
Analytics, 9th Edition
MIA
TEST BANK
E_DA
Cliff Ragsdale
CPO
PNR
Comprehensive Test Bank for Instructors
and Students
NOO
||| ||| || ||| || | || ||| | || ||| |
VIESS
9780357132098
© Cliff Ragsdale. All rights reserved.
DE?U
Reproduction or distribution without permission is
prohibited.
R?
© MEDGEEK
,TU S
TABLE OF CONTENTS
Test Bank – Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business
Analytics (9th Edition)
Author: Cliff Ragsdale
VI U
ISBN: 9780357132098
PART I: OPTIMIZATION AND LINEAR PROGRAMMING
T
A_V
Chapter 1: Introduction to Modeling and Decision Analysis
Chapter 2: Introduction to Optimization and Linear Programming
Chapter 3: Modeling and Solving LP Problems in a Spreadsheet
Chapter 4: Sensitivity Analysis and the Simplex Method
Chapter 5: Network Modeling
MIA
Chapter 6: Integer Linear Programming
Chapter 7: Goal Programming and Multiple Objective Optimization
Chapter 8: Nonlinear Programming and Evolutionary Optimization
E_DA
PART II: DATA ANALYTICS AND FORECASTING
Chapter 9: Regression Analysis
Chapter 10: Data Mining
Chapter 11: Time Series Forecasting
CPO
PART III: PROBABILISTIC MODELS AND DECISION MAKING
Chapter 12: Introduction to Simulation Using Analytic Solver
PNR
Chapter 13: Queuing Theory
Chapter 14: Decision Analysis
PART IV: PROJECT MANAGEMENT
NOO
Chapter 15: Project Management
VIESS
DE?U
R?
, Name: Class: Date:
TU S
TEST BANK FOR
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics 9th
Edition Cliff Ragsdale Chapter 1-15
VI U
Answers are at the end of each chapter
T
chapter 1
A_V
Indicate whether the statement is true or false.
1. Because they simplify reality, models are generally not helpful in examining things that would be impossible to
do in reality.
a. True
MIA
b. False
2. The proliferation of powerful PCs and the development of easy-to-use electronic spreadsheets have made the tools of
business analytics far more practical and available to a much larger audience.
E_DA
a. True
b. False
3. A mathematical model uses mathematical relationships to describe or represent an object or decision problem.
CPO
a. True
b. False
4. In spreadsheet modeling of a problem, there is no direct correspondence between mathematical equation and the
spreadsheet.
PNR
a. True
b. False
5. Humans usually do not make errors in estimation due to anchoring and framing effects.
NOO
a. True
b. False
6. Good decisions always result in good outcomes.
VIESS
a. True
b. False
7. Defining a problem well will often make it much easier to solve.
DE?U
a. True
b. False
8. OR/MS specialists do not deliver business value.
a. True
b. False
R?
Indicate the answer choice that best completes the statement or answers the question.
Copyright Cengage Learning. Powered by Cognero. Page 1
, Name: Class: Date:
TU S
9. Identifying the real problems faced by the decision maker
a. is not important since the decision maker has already defined the problem.
b. requires insight, some imagination, time and a good bit of detective work.
c. first requires a well-defined problem statement.
VI U
d. will lead to developing the best model.
T
10. Business opportunities can be viewed and formulated as
A_V
a. decision problems.
b. analytical models.
c. empirical models.
d. testing tools.
MIA
11. In a spreadsheet, input cells correspond conceptually to
a. dependent variables.
b. functions.
E_DA
c. independent variables.
d. output cells.
12. Solutions to which of the following categories of modeling techniques indicate a course of action to the decision
maker?
CPO
a. Descriptive models
b. Predictive models
c. Prescriptive models
d. Preventive models
PNR
13. A factor that plays a role in determining whether a good or bad outcome occurs is called
a. luck.
b. intuition.
NOO
c. certainty.
d. predictability.
14. In a model Y=f(x1, x2), Y is called:
VIESS
a. a dependent variable.
b. an independent variable.
c. a confounded variable.
d. a convoluted variable.
DE?U
15. Which of the following is the type of model used throughout this textbook?
a. Mathematical model
b. Mental model
c. Physical model
d. Visual model
R?
16. The essence of decision analysis is:
Copyright Cengage Learning. Powered by Cognero. Page 2
TU S
Spreadsheet Modeling and
Decision Analysis: A Practical
VI U
Introduction to Business
T
A_V
Analytics, 9th Edition
MIA
TEST BANK
E_DA
Cliff Ragsdale
CPO
PNR
Comprehensive Test Bank for Instructors
and Students
NOO
||| ||| || ||| || | || ||| | || ||| |
VIESS
9780357132098
© Cliff Ragsdale. All rights reserved.
DE?U
Reproduction or distribution without permission is
prohibited.
R?
© MEDGEEK
,TU S
TABLE OF CONTENTS
Test Bank – Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business
Analytics (9th Edition)
Author: Cliff Ragsdale
VI U
ISBN: 9780357132098
PART I: OPTIMIZATION AND LINEAR PROGRAMMING
T
A_V
Chapter 1: Introduction to Modeling and Decision Analysis
Chapter 2: Introduction to Optimization and Linear Programming
Chapter 3: Modeling and Solving LP Problems in a Spreadsheet
Chapter 4: Sensitivity Analysis and the Simplex Method
Chapter 5: Network Modeling
MIA
Chapter 6: Integer Linear Programming
Chapter 7: Goal Programming and Multiple Objective Optimization
Chapter 8: Nonlinear Programming and Evolutionary Optimization
E_DA
PART II: DATA ANALYTICS AND FORECASTING
Chapter 9: Regression Analysis
Chapter 10: Data Mining
Chapter 11: Time Series Forecasting
CPO
PART III: PROBABILISTIC MODELS AND DECISION MAKING
Chapter 12: Introduction to Simulation Using Analytic Solver
PNR
Chapter 13: Queuing Theory
Chapter 14: Decision Analysis
PART IV: PROJECT MANAGEMENT
NOO
Chapter 15: Project Management
VIESS
DE?U
R?
, Name: Class: Date:
TU S
TEST BANK FOR
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics 9th
Edition Cliff Ragsdale Chapter 1-15
VI U
Answers are at the end of each chapter
T
chapter 1
A_V
Indicate whether the statement is true or false.
1. Because they simplify reality, models are generally not helpful in examining things that would be impossible to
do in reality.
a. True
MIA
b. False
2. The proliferation of powerful PCs and the development of easy-to-use electronic spreadsheets have made the tools of
business analytics far more practical and available to a much larger audience.
E_DA
a. True
b. False
3. A mathematical model uses mathematical relationships to describe or represent an object or decision problem.
CPO
a. True
b. False
4. In spreadsheet modeling of a problem, there is no direct correspondence between mathematical equation and the
spreadsheet.
PNR
a. True
b. False
5. Humans usually do not make errors in estimation due to anchoring and framing effects.
NOO
a. True
b. False
6. Good decisions always result in good outcomes.
VIESS
a. True
b. False
7. Defining a problem well will often make it much easier to solve.
DE?U
a. True
b. False
8. OR/MS specialists do not deliver business value.
a. True
b. False
R?
Indicate the answer choice that best completes the statement or answers the question.
Copyright Cengage Learning. Powered by Cognero. Page 1
, Name: Class: Date:
TU S
9. Identifying the real problems faced by the decision maker
a. is not important since the decision maker has already defined the problem.
b. requires insight, some imagination, time and a good bit of detective work.
c. first requires a well-defined problem statement.
VI U
d. will lead to developing the best model.
T
10. Business opportunities can be viewed and formulated as
A_V
a. decision problems.
b. analytical models.
c. empirical models.
d. testing tools.
MIA
11. In a spreadsheet, input cells correspond conceptually to
a. dependent variables.
b. functions.
E_DA
c. independent variables.
d. output cells.
12. Solutions to which of the following categories of modeling techniques indicate a course of action to the decision
maker?
CPO
a. Descriptive models
b. Predictive models
c. Prescriptive models
d. Preventive models
PNR
13. A factor that plays a role in determining whether a good or bad outcome occurs is called
a. luck.
b. intuition.
NOO
c. certainty.
d. predictability.
14. In a model Y=f(x1, x2), Y is called:
VIESS
a. a dependent variable.
b. an independent variable.
c. a confounded variable.
d. a convoluted variable.
DE?U
15. Which of the following is the type of model used throughout this textbook?
a. Mathematical model
b. Mental model
c. Physical model
d. Visual model
R?
16. The essence of decision analysis is:
Copyright Cengage Learning. Powered by Cognero. Page 2
