Edrftgyihu jiuh
Spreadsheet Modeling and
Decision Analysis: A Practical
ST
Introduction to Business
UV
Analytics, 9th Edition
TEST BANK
IA
_A
Cliff Ragsdale
PP
Comprehensive Test Bank for Instructors
RO
and Students
||| ||| || ||| || | || ||| | || ||| |
VE
9780357132098
© Cliff Ragsdale. All rights reserved.
D?
Reproduction or distribution without permission is
prohibited.
© MEDGEEK
, TABLE OF CONTENTS
Test Bank – Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business
Analytics (9th Edition)
Author: Cliff Ragsdale
ST
ISBN: 9780357132098
PART I: OPTIMIZATION AND LINEAR PROGRAMMING
Chapter 1: Introduction to Modeling and Decision Analysis
UV
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
Chapter 6: Integer Linear Programming
Chapter 7: Goal Programming and Multiple Objective Optimization
IA
Chapter 8: Nonlinear Programming and Evolutionary Optimization
PART II: DATA ANALYTICS AND FORECASTING
_A
Chapter 9: Regression Analysis
Chapter 10: Data Mining
Chapter 11: Time Series Forecasting
PART III: PROBABILISTIC MODELS AND DECISION MAKING
PP
Chapter 12: Introduction to Simulation Using Analytic Solver
Chapter 13: Queuing Theory
Chapter 14: Decision Analysis
RO
PART IV: PROJECT MANAGEMENT
Chapter 15: Project Management
VE
D?
, Name: Class: Date:
TEST BANK FOR
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics 9th
Edition Cliff Ragsdale Chapter 1-15
ST
Answers are at the end of each chapter
chapter 1
Indicate whether the statement is true or false.
UV
1. Because they simplify reality, models are generally not helpful in examining things that would be impossible to
do in reality.
a. True
b. False
IA
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.
a. True
_A
b. False
3. A mathematical model uses mathematical relationships to describe or represent an object or decision problem.
a. True
b. False
PP
4. In spreadsheet modeling of a problem, there is no direct correspondence between mathematical equation and the
spreadsheet.
a. True
b. False
RO
5. Humans usually do not make errors in estimation due to anchoring and framing effects.
a. True
b. False
6. Good decisions always result in good outcomes.
VE
a. True
b. False
7. Defining a problem well will often make it much easier to solve.
D?
a. True
b. False
8. OR/MS specialists do not deliver business value.
a. True
b. False
Indicate the answer choice that best completes the statement or answers the question.
Copyright Cengage Learning. Powered by Cognero. Page 1
, Name: Class: Date:
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.
ST
d. will lead to developing the best model.
10. Business opportunities can be viewed and formulated as
a. decision problems.
UV
b. analytical models.
c. empirical models.
d. testing tools.
11. In a spreadsheet, input cells correspond conceptually to
IA
a. dependent variables.
b. functions.
c. independent variables.
d. output cells.
_A
12. Solutions to which of the following categories of modeling techniques indicate a course of action to the decision
maker?
a. Descriptive models
b. Predictive models
PP
c. Prescriptive models
d. Preventive models
13. A factor that plays a role in determining whether a good or bad outcome occurs is called
a. luck.
RO
b. intuition.
c. certainty.
d. predictability.
14. In a model Y=f(x1, x2), Y is called:
VE
a. a dependent variable.
b. an independent variable.
c. a confounded variable.
d. a convoluted variable.
D?
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
16. The essence of decision analysis is:
Copyright Cengage Learning. Powered by Cognero. Page 2
Spreadsheet Modeling and
Decision Analysis: A Practical
ST
Introduction to Business
UV
Analytics, 9th Edition
TEST BANK
IA
_A
Cliff Ragsdale
PP
Comprehensive Test Bank for Instructors
RO
and Students
||| ||| || ||| || | || ||| | || ||| |
VE
9780357132098
© Cliff Ragsdale. All rights reserved.
D?
Reproduction or distribution without permission is
prohibited.
© MEDGEEK
, TABLE OF CONTENTS
Test Bank – Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business
Analytics (9th Edition)
Author: Cliff Ragsdale
ST
ISBN: 9780357132098
PART I: OPTIMIZATION AND LINEAR PROGRAMMING
Chapter 1: Introduction to Modeling and Decision Analysis
UV
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
Chapter 6: Integer Linear Programming
Chapter 7: Goal Programming and Multiple Objective Optimization
IA
Chapter 8: Nonlinear Programming and Evolutionary Optimization
PART II: DATA ANALYTICS AND FORECASTING
_A
Chapter 9: Regression Analysis
Chapter 10: Data Mining
Chapter 11: Time Series Forecasting
PART III: PROBABILISTIC MODELS AND DECISION MAKING
PP
Chapter 12: Introduction to Simulation Using Analytic Solver
Chapter 13: Queuing Theory
Chapter 14: Decision Analysis
RO
PART IV: PROJECT MANAGEMENT
Chapter 15: Project Management
VE
D?
, Name: Class: Date:
TEST BANK FOR
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics 9th
Edition Cliff Ragsdale Chapter 1-15
ST
Answers are at the end of each chapter
chapter 1
Indicate whether the statement is true or false.
UV
1. Because they simplify reality, models are generally not helpful in examining things that would be impossible to
do in reality.
a. True
b. False
IA
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.
a. True
_A
b. False
3. A mathematical model uses mathematical relationships to describe or represent an object or decision problem.
a. True
b. False
PP
4. In spreadsheet modeling of a problem, there is no direct correspondence between mathematical equation and the
spreadsheet.
a. True
b. False
RO
5. Humans usually do not make errors in estimation due to anchoring and framing effects.
a. True
b. False
6. Good decisions always result in good outcomes.
VE
a. True
b. False
7. Defining a problem well will often make it much easier to solve.
D?
a. True
b. False
8. OR/MS specialists do not deliver business value.
a. True
b. False
Indicate the answer choice that best completes the statement or answers the question.
Copyright Cengage Learning. Powered by Cognero. Page 1
, Name: Class: Date:
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.
ST
d. will lead to developing the best model.
10. Business opportunities can be viewed and formulated as
a. decision problems.
UV
b. analytical models.
c. empirical models.
d. testing tools.
11. In a spreadsheet, input cells correspond conceptually to
IA
a. dependent variables.
b. functions.
c. independent variables.
d. output cells.
_A
12. Solutions to which of the following categories of modeling techniques indicate a course of action to the decision
maker?
a. Descriptive models
b. Predictive models
PP
c. Prescriptive models
d. Preventive models
13. A factor that plays a role in determining whether a good or bad outcome occurs is called
a. luck.
RO
b. intuition.
c. certainty.
d. predictability.
14. In a model Y=f(x1, x2), Y is called:
VE
a. a dependent variable.
b. an independent variable.
c. a confounded variable.
d. a convoluted variable.
D?
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
16. The essence of decision analysis is:
Copyright Cengage Learning. Powered by Cognero. Page 2
