TEST BANK
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business
Analytics, 9th edition
By Cliff Ragsdale
SC
O
R
EG
U
ID
ES
, Table of Content
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
SC
Chapter 5. Network Modeling
Chapter 6. Integer Linear Programming
Chapter 7. Goal Programming and Multiple Objective Optimization
O
Chapter 8. Nonlinear Programming and Evolutionary Optimization
R
Chapter 9. Regression Analysis
Chapter 10. Data Mining
EG
Chapter 11. Time Series Forecasting
Chapter 12. Introduction to Simulation Using Analytic Solver
Chapter 13. Queuing Theory
U
Chapter 14. Decision Analysis
ID
Chapter 15. Project Management
ES
, ..
Name: Class: Date:
Chapter 01 Introduction to Modeling and Decision Analysis
1. The essence of decision analysis is
a. breaking down complex situations into manageable elements.
b. choosing the best course of action among alternatives.
c. finding the root cause of why something has gone wrong.
d. thinking ahead to avoid negative consequences.
SC
ANSWER: b
2. All of the following are reasons why someone would wish to use a spreadsheet model except
a. to implement a computer model.
b. because spreadsheets are convenient.
c. to analyze decision alternatives.
O
d. because spreadsheets lead to increased opportunities.
ANSWER: d
3. Which of the following fields of study uses computers, statistics, and mathematics to solve business problems?
R
a. Accounting
b. Information systems
c. Business analytics
EG
d. Scientific management
ANSWER: c
4. Anchoring effects occur in decision-making problems when
a. decision makers are tied too closely to previous decisions.
b. organizations refuse to consider new alternatives.
U
c. a seemingly trivial factor serves as a starting point for estimations.
d. a person in a position of authority exerts his or her opinion very forcefully.
ANSWER: c
ID
5. Virtually everyone who uses a spreadsheet today for model building and decision making
a. is a practitioner of business analytics.
b. possesses an advanced knowledge of mathematics and computer programming languages.
c. is a CPA.
ES
d. is in a position to influence decision makers.
ANSWER: a
6. Which of the following statements is true of using models in problem solving and decision analysis?
a. It is a fairly new idea.
b. It is required in order to find good solutions.
c. It is something virtually everyone has done before.
d. It is tied to the use of computers.
ANSWER: c
7. A road map is an example of a
a. mathematical model.
, ..
Name: Class: Date:
Chapter 01 Introduction to Modeling and Decision Analysis
b. mental model.
c. physical model.
d. visual model.
ANSWER: d
SC
8. The textbook figure shown below of the problem-solving process is an example of a
O
a. mental model.
b. prescriptive model.
R
c. graphical model.
d. visual model.
ANSWER: d
EG
9. Which of the following is most likely to be used when faced with the decision of how to arrange furniture in a room?
a. Mathematical model
b. Mental model
c. Physical model
d. Visual model
ANSWER: b
U
10. To illustrate how a complex system will be built, an engineer will likely use a
a. mathematical model.
b. mental model.
ID
c. physical model.
d. visual model.
ANSWER: d
ES
11. 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
ANSWER: a
12. The best models
a. accurately reflect relevant characteristics of the real-world object or decision.
b. are mathematical models.
c. replicate all aspects of the real-world object or decision.
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business
Analytics, 9th edition
By Cliff Ragsdale
SC
O
R
EG
U
ID
ES
, Table of Content
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
SC
Chapter 5. Network Modeling
Chapter 6. Integer Linear Programming
Chapter 7. Goal Programming and Multiple Objective Optimization
O
Chapter 8. Nonlinear Programming and Evolutionary Optimization
R
Chapter 9. Regression Analysis
Chapter 10. Data Mining
EG
Chapter 11. Time Series Forecasting
Chapter 12. Introduction to Simulation Using Analytic Solver
Chapter 13. Queuing Theory
U
Chapter 14. Decision Analysis
ID
Chapter 15. Project Management
ES
, ..
Name: Class: Date:
Chapter 01 Introduction to Modeling and Decision Analysis
1. The essence of decision analysis is
a. breaking down complex situations into manageable elements.
b. choosing the best course of action among alternatives.
c. finding the root cause of why something has gone wrong.
d. thinking ahead to avoid negative consequences.
SC
ANSWER: b
2. All of the following are reasons why someone would wish to use a spreadsheet model except
a. to implement a computer model.
b. because spreadsheets are convenient.
c. to analyze decision alternatives.
O
d. because spreadsheets lead to increased opportunities.
ANSWER: d
3. Which of the following fields of study uses computers, statistics, and mathematics to solve business problems?
R
a. Accounting
b. Information systems
c. Business analytics
EG
d. Scientific management
ANSWER: c
4. Anchoring effects occur in decision-making problems when
a. decision makers are tied too closely to previous decisions.
b. organizations refuse to consider new alternatives.
U
c. a seemingly trivial factor serves as a starting point for estimations.
d. a person in a position of authority exerts his or her opinion very forcefully.
ANSWER: c
ID
5. Virtually everyone who uses a spreadsheet today for model building and decision making
a. is a practitioner of business analytics.
b. possesses an advanced knowledge of mathematics and computer programming languages.
c. is a CPA.
ES
d. is in a position to influence decision makers.
ANSWER: a
6. Which of the following statements is true of using models in problem solving and decision analysis?
a. It is a fairly new idea.
b. It is required in order to find good solutions.
c. It is something virtually everyone has done before.
d. It is tied to the use of computers.
ANSWER: c
7. A road map is an example of a
a. mathematical model.
, ..
Name: Class: Date:
Chapter 01 Introduction to Modeling and Decision Analysis
b. mental model.
c. physical model.
d. visual model.
ANSWER: d
SC
8. The textbook figure shown below of the problem-solving process is an example of a
O
a. mental model.
b. prescriptive model.
R
c. graphical model.
d. visual model.
ANSWER: d
EG
9. Which of the following is most likely to be used when faced with the decision of how to arrange furniture in a room?
a. Mathematical model
b. Mental model
c. Physical model
d. Visual model
ANSWER: b
U
10. To illustrate how a complex system will be built, an engineer will likely use a
a. mathematical model.
b. mental model.
ID
c. physical model.
d. visual model.
ANSWER: d
ES
11. 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
ANSWER: a
12. The best models
a. accurately reflect relevant characteristics of the real-world object or decision.
b. are mathematical models.
c. replicate all aspects of the real-world object or decision.
