MEDSTUDY.COM
Test Bank for Spreadsheet Modeling and Decision Analysis A
Practical Introduction To Business Analytics 9th Edition
M Cliff Ragsdale
ED
ST
U
D
Y
,MEDSTUDY.COM
TABLE OF CONTENTS
1. Introduction to Modeling and Decision Analysis.
2. Introduction to Optimization and Linear Programming.
3. Modeling and Solving LP Problems in a Spreadsheet.
4. Sensitivity Analysis andthe Simplex Method.
5. Network Modeling.
M
6. Integer Linear Programming.
7. Goal Programming and Multiple Objective Optimization.
ED
8. Nonlinear Programming & Evolutionary Optimization.
9. Regression Analysis.
ST
10. Data Mining.
11. Time Series Forecasting.
U
12. Introduction to Simulation.
13. Queuing Theory.
D
14. Decision Analysis.
Y
15. Project Management (Online).
,MEDSTUDY.COM
Chapter 1 Introduction to Modeling and Decision Analysis.
Answers Are At The End Of Each Chapter
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
todoin reality.
a. True
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.
M
a. True
b. False
ED
3. A mathematical model uses mathematical relationships to describe or representan object or decision problem.
a. True
b. False
4. In spreadsheet modeling of a problem, there is no direct correspondence between mathematical equation and
ST
thespreadsheet.
a. True
b. False
5. Humans usually do not make errors in estimation due to anchoring and framing effects.
U
a. True
b. False
D
6. Good decisions always result in good outcomes.
a. True
b. False
Y
7. Defining a problem well will often make it much easier to solve.
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.
,MEDSTUDY.COM
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.
d. will lead to developing the bestmodel.
10. Business opportunities can be viewed and formulated as
a. decision problems.
b. analytical models.
c. empirical models.
d. testing tools.
M
11. Ina spreadsheet, input cells correspond conceptually to
a. dependent variables.
b. functions.
ED
c. independent variables.
d. output cells.
12. Solutions to which of the following categories of modeling techniques indicate a course of action to the
decisionmaker?
a. Descriptive models
ST
b. Predictive models
c. Prescriptive models
d. Preventive models
13. A factor that playsa role in determining whether a good or badoutcome occurs is called
U
a. luck.
b. intuition.
D
c. certainty.
d. predictability.
Y
14. Ina model Y=f(x1, x2), Y is called:
a. a dependent variable.
b. an independent variable.
c. a confounded variable.
d. a convoluted variable.
15. Which of the following is the type of model used throughout this textbook?
a. Mathematical model
b. Mental model
c. Physical model
d. Visualmodel
Test Bank for Spreadsheet Modeling and Decision Analysis A
Practical Introduction To Business Analytics 9th Edition
M Cliff Ragsdale
ED
ST
U
D
Y
,MEDSTUDY.COM
TABLE OF CONTENTS
1. Introduction to Modeling and Decision Analysis.
2. Introduction to Optimization and Linear Programming.
3. Modeling and Solving LP Problems in a Spreadsheet.
4. Sensitivity Analysis andthe Simplex Method.
5. Network Modeling.
M
6. Integer Linear Programming.
7. Goal Programming and Multiple Objective Optimization.
ED
8. Nonlinear Programming & Evolutionary Optimization.
9. Regression Analysis.
ST
10. Data Mining.
11. Time Series Forecasting.
U
12. Introduction to Simulation.
13. Queuing Theory.
D
14. Decision Analysis.
Y
15. Project Management (Online).
,MEDSTUDY.COM
Chapter 1 Introduction to Modeling and Decision Analysis.
Answers Are At The End Of Each Chapter
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
todoin reality.
a. True
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.
M
a. True
b. False
ED
3. A mathematical model uses mathematical relationships to describe or representan object or decision problem.
a. True
b. False
4. In spreadsheet modeling of a problem, there is no direct correspondence between mathematical equation and
ST
thespreadsheet.
a. True
b. False
5. Humans usually do not make errors in estimation due to anchoring and framing effects.
U
a. True
b. False
D
6. Good decisions always result in good outcomes.
a. True
b. False
Y
7. Defining a problem well will often make it much easier to solve.
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.
,MEDSTUDY.COM
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.
d. will lead to developing the bestmodel.
10. Business opportunities can be viewed and formulated as
a. decision problems.
b. analytical models.
c. empirical models.
d. testing tools.
M
11. Ina spreadsheet, input cells correspond conceptually to
a. dependent variables.
b. functions.
ED
c. independent variables.
d. output cells.
12. Solutions to which of the following categories of modeling techniques indicate a course of action to the
decisionmaker?
a. Descriptive models
ST
b. Predictive models
c. Prescriptive models
d. Preventive models
13. A factor that playsa role in determining whether a good or badoutcome occurs is called
U
a. luck.
b. intuition.
D
c. certainty.
d. predictability.
Y
14. Ina model Y=f(x1, x2), Y is called:
a. a dependent variable.
b. an independent variable.
c. a confounded variable.
d. a convoluted variable.
15. Which of the following is the type of model used throughout this textbook?
a. Mathematical model
b. Mental model
c. Physical model
d. Visualmodel
