Exam (elaborations)

TEST BANK FOR Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analysis 9th Edition by Cliff Ragsdale Chapters 1-15

0 purchase

Institution
Anderson University

Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List) 9th Edition

[Show more]

Preview 4 out of 642 pages

View example

Uploaded on November 7, 2023
Number of pages 642
Written in 2023/2024
Type Exam (elaborations)
Contains Questions & answers

spreadsheet modeling and decision analysis
test bank for spreadsheet modeling and decision
test bank

NursingGuru Member since 1 year 186 documents sold

$13.00

Add to cart

Add to wishlist

100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached

.

Name: Class: Date:

TEST BANK FOR
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics 9th
Edition Cliff Ragsdale Chapter 1-15

Answers are at the end of each chapter
chapter 1

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
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.
a. True
b. False

3. A mathematical model uses mathematical relationships to describe or represent an object or decision problem.
a. True
b. False

4. In spreadsheet modeling of a problem, there is no direct correspondence between mathematical equation and the
spreadsheet.
a. True
b. False

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.
a. True
b. False

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.
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.
d. will lead to developing the best model.

10. Business opportunities can be viewed and formulated as
a. decision problems.
b. analytical models.
c. empirical models.
d. testing tools.

11. In a spreadsheet, input cells correspond conceptually to
a. dependent variables.
b. functions.
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?
a. Descriptive models
b. Predictive models
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.
b. intuition.
c. certainty.
d. predictability.

14. In a 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. Visual model

16. The essence of decision analysis is:
Copyright Cengage Learning. Powered by Cognero. Page 2

,Name: Class: Date:

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.

17. A road map is an example of
a. a mathematical model.
b. a mental model.
c. a physical model.
d. a visual model.

18. The mathematical modeling approaches presented in the textbook
a. are a subset of the total problem-solving process.
b. cover the entire spectrum of decision support approaches.
c. are exhaustive.
d. are complementary.

19. Operations Research got its start
a. during World War II.
b. with the first Univac computers in the early 1950's.
c. from roots in Operations Management.
d. from Frederick Taylor's Scientific Management.

20. Anchoring occurs when:
a. a trivial factor is used as a starting point for estimations in a decision-making problem.
b. a difficult factor is incorporated in a problem.
c. an easy solution is obtained to a difficult problem.
d. obtaining a solution is trivial.

21. Two of the effects associated with decision problems are:
a. anchoring and framing.
b. anchoring and loading.
c. framing and complacency.
d. anchoring and luck

22. In the textbook the words "opportunity" and "problem" are
a. disjoint.
b. used interchangeably.
c. mutually exclusive.
d. complementary.

23. A valid model:
a. accurately represents a decision problem being studied.
b. produces an optimal solution.

Copyright Cengage Learning. Powered by Cognero. Page 3

, Name: Class: Date:

c. produces a good solution.
d. produces a feasible solution.

24. In a decision-making framework presented in Chapter One, the term "deserved success" refers to a situation when the
following occur:
a. Good decision quality and good outcome quality.
b. Good decision quality and bad outcome quality.
c. Bad decision quality and good outcome quality.
d. Bad decision quality and bad outcome quality.

25. The goal of the modeling approach to problem solving is to
a. help individuals make good decisions.
b. ensure optimality of decisions.
c. determine a set of optimal decisions.
d. determine feasibility of decisions.

26. Business analytics focuses on
a. identifying and leveraging business opportunities.
b. formulating analytical models.
c. using models to analyze problem.
d. testing and implementing results.

27. Which of the following steps in the problem-solving process is most likely to incur resistance from people affected by
the proposed solution?
a. Formulate model
b. Use model to analyze problem
c. Test results
d. Implement solution

28. To illustrate how a complex system will be built, an engineer will likely use a
a. mathematical model.
b. mental model.
c. physical model.
d. visual model.

29. Chapter One discussed all of the following except:
a. how models of decision problems differ in a number of important characteristics.
b. how spreadsheet modeling and analysis fit into the problem-solving process.
c. how spreadsheet models of decision problems can be used to analyze the consequences of possible courses of
action.
d. how to implement a problem formulation as a spreadsheet model.

30. A mathematical model is considered to be "valid" when
a. it accurately represents the relevant characteristics of the object or decision.
b. it has passed a validation test.
Copyright Cengage Learning. Powered by Cognero. Page 4

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller NursingGuru. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $13.00. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

69052 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 15 years now

Start selling

Exam (elaborations)

TEST BANK FOR Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analysis 9th Edition by Cliff Ragsdale Chapters 1-15

Document information

Subjects

Connected book

More summaries for

Written for

Seller

Reviews received

Content preview