Written by students who passed Immediately available after payment Read online or as PDF Wrong document? Swap it for free 4.6 TrustPilot
logo-home
Exam (elaborations)

Solution Manual for Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics 9th Edition Cliff Ragsdale

Rating
-
Sold
-
Pages
642
Grade
A+
Uploaded on
03-06-2024
Written in
2023/2024

Solution Manual for Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics 9th Edition Cliff Ragsdale

Institution
Solution Manual For Spreadsheet Modeling And Decis
Course
Solution Manual for Spreadsheet Modeling And Decis

Content preview

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

,Name: Class: Date:



c. it replicates all aspects of the object or decision.
d. the left-hand and right-hand sides of expressions are equal.

31. A situation when decision quality is good and the resulting outcome quality is bad is referred to as
a. pure luck.
b. deserved success.
c. bad luck.
d. poetic justice.

32. There are a variety of problems a manager might face. While presenting and defending your approach, how would you
complete this thought?
Several different modeling techniques are available to solve managerial decision problems,
a. the wrong choice of modeling technique is a common source of implementation difficulties.
b. students should develop a strong preference and expertise in one technique so when faced with problems as
managers they can formulate them as a model that can be solved by their favorite technique.
c. fundamental characteristics of the problem guide the selection of an appropriate modeling technique.
d. most problems faced by managers are fundamentally the same.

33. Which of the following categories of modeling techniques involves determining the value of a dependent variable
based on specific values of independent variables?
a. Biased models.
b. Descriptive models.
c. Predictive models.
d. Prescriptive models.

34. In order to be useful to a decision-maker, decision problems need to be
a. valid.
b. analyzed.
c. simplified.
d. tested.

35. Why would someone wish to use a spreadsheet model?
a. To implement a computer model.
b. Because spreadsheets are convenient.
c. To analyze decision alternatives.
d. All of these.

36. Which of the following is true of "What if?" analysis?
a. A well-designed spreadsheet facilitates "What if?" analysis.
b. It is not very useful when working with non mathematical models.
c. "What if?" analysis is an efficient optimization technique.
d. "What if?" analysis is useful in creating a well-defined problem statement.

37. Which step of the problem-solving process is considered the most important?
a. Identify problem.
Copyright Cengage Learning. Powered by Cognero. Page 5

,Name: Class: Date:



b. Analyze model.
c. Test results.
d. Implement solution.

38. The categories of modeling techniques presented in this book include all of the following except:
a. descriptive models.
b. predictive models.
c. prescriptive models.
d. preventive models.

39. The textbook figure of the problem-solving process is an example of a
a. mental model.
b. prescriptive model.
c. graphical model.
d. visual model.

40. Better decision making due to using a modeling process is achieved due to
a. the interaction with the spreadsheet.
b. the visualization of the system being studied.
c. the insight gained through the process.
d. the timeliness of the results obtained.

41. In a decision-making framework presented in Chapter One, the term "bad luck" 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.

42. Which of the following fields of study is defined in Chapter One as the one that "uses computers, statistics, and
mathematics to solve business problems"?
a. Accounting
b. Information systems
c. Business analytics
d. Scientific management

43. If we do not identify the correct problem, the best we can hope for is:
a. wasted time and effort.
b. useful experience in problem definition efforts.
c. a descriptive model.
d. the right answer to the wrong question.

44. In a decision-making problem, anchoring effects occur when
a. decision makers are tied too closely to previous decisions.
b. organizations refuse to consider new alternatives.
Copyright Cengage Learning. Powered by Cognero. Page 6

,Name: Class: Date:



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.

45. In the following expression, which is (are) the dependent variable(s)?
PROFIT = REVENUE − EXPENSES
a. Profit
b. Revenue
c. Expenses
d. (b) and (c)

46. In a decision-making framework presented in Chapter One, the term "dumb luck" 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.

47. A situation when decision quality is bad and the resulting outcome quality is good is referred to as
a. dumb luck.
b. deserved success.
c. bad luck.
d. poetic justice.

48. To be effective, a modeler must
a. be an effective presenter of results.
b. collect the proper input data for the model.
c. understand how modeling fits into the problem-solving process.
d. apply the correct modeling technique.

49. The notion that every problem is also an opportunity is reflected in the term
a. probortunity.
b. formulation.
c. simulation.
d. business opportunity.

50. Beneficial uses of the testing process include all of the following except:
a. double checking the validity the model.
b. finding that some important assumption has been left out of the model.
c. giving no new insights into the nature of the problem.
d. improving solutions after the implementation step.

51. Which of the following problem-solving steps is often considered the most difficult?
a. Identify the problem.
b. Analyze the model.
Copyright Cengage Learning. Powered by Cognero. Page 7

,Name: Class: Date:



c. Test results.
d. Implement the solution.

52. In which step of the problem-solving process is the main focus to generate and evaluate alternatives?
a. Identify problem
b. Formulate model
c. Use model to analyze problem
d. Test results

53. 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.
d. is in a position to influence decision makers.

54. The Chapter One "The World of Business Analytics" case reading discusses the relationship between OR/MS and IS
professionals. Which of the following statements is NOT true?
a. OR/MS analysts need IS professionals' data for their models.
b. OR/MS analysts need to take many of the IS customers.
c. The IS professional cannot use OR/MS tools in their applications.
d. The IS tools can start to recommend solutions using OR/MS skills.

55. A situation when decision quality is good and the resulting outcome quality is good is referred to as
a. pure luck.
b. deserved success.
c. dumb luck.
d. poetic justice.

56. Implementing solutions to problems involves people and change. Which of the following is a suggested approach to
effectively implement solutions?
a. Decision-making authority centralized to those who have specialized training in decision making.
b. Involve anyone affected by the decision in all steps of the problem-solving process.
c. Making decisions according to majority vote.
d. More skillful communication of management decisions.

57. The Chapter One "The World of Business Analytics" case reading offers the CEO alternatives to start the OR/MS
collaboration process. All the following are alternatives offered except:
a. Require the OR/MS group to save their yearly salary in every study.
b. Use OR/MS personnel as consultants.
c. Hire some OR/MS professionals and give them a problem to work.
d. Institute more participation from OR analysts.

58. In a model Y=f(x1, x2), x1 is called:
a. an independent variable.
b. a dependent variable.
Copyright Cengage Learning. Powered by Cognero. Page 8

,Name: Class: Date:



c. a confounded variable.
d. a convoluted variable.

59. In which of the following categories of modeling techniques are the specifications of the relationships between
dependent and independent variables unknown or ill-defined?
a. Descriptive models
b. Open models
c. Predictive models
d. Prescriptive models

60. Variables are termed independent when they satisfy which of the following?
a. The function value depends upon their values.
b. The decision maker has no control over them.
c. The variables have no relationship to one another.
d. The variable is described as an output of the spreadsheet model.

61. Consistently using a structured, model based process to make decisions
a. should produce good outcomes more frequently.
b. is less effective than making decisions in a haphazard manner.
c. is evidence that luck plays an important role in decision making.
d. always leads to well-deserved success in managerial decision making.

62. Which of the following categories of modeling techniques includes optimization techniques?
a. Capitalistic models
b. Descriptive models
c. Predictive models
d. Prescriptive models

63. Which of the following categories of modeling techniques addresses uncertainty in the values of the independent
variables?
a. Descriptive models
b. Predictive models
c. Prescriptive models
d. Scale models

64. In which of the following categories of modeling techniques do the independent variables have unknown or uncertain
values or coefficients?
a. Descriptive models
b. Predictive models
c. Prescriptive models
d. Probabilistic models

65. The best models
a. accurately reflect relevant characteristics of the real-world object or decision.
b. are mathematical models.
Copyright Cengage Learning. Powered by Cognero. Page 9

, Name: Class: Date:



c. replicate all aspects of the real-world object or decision.
d. replicate the characteristics of a component in isolation from the rest of the system.

66. In a decision-making framework presented in Chapter One, the term "poetic justice" 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.

67. The concept of "probortunity" is
a. the first step in the problem-solving process.
b. a decision support method.
c. part of testing results.
d. part of solution implementation.

68. In this text we use the term "mathematics" to encompass

i. familiar elements of math such as algebra.
ii. logic.

a. i only
b. ii only
c. Both i and ii
d. Neither i nor ii

69. All of the following are benefits of modeling except:
a. Modeling delivers needed information on a more timely basis.
b. Modeling finds the right answers to incorrect or flawed problem statements.
c. Modeling is helpful in examining things that would be impossible to do in reality.
d. Modeling is less expensive than implementing several alternative solutions.

70. If results testing produces unsatisfactory results
a. the problem-solving process requires new formulation and implementation.
b. minor adjustments to the existing model.
c. checking the solution algorithm.
d. repeated testing.

71. 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

72. Framing effect refers to:

Copyright Cengage Learning. Powered by Cognero. Page 10

Written for

Institution
Solution Manual for Spreadsheet Modeling And Decis
Course
Solution Manual for Spreadsheet Modeling And Decis

Document information

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

Subjects

$17.99
Get access to the full document:

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Get to know the seller

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
TUTORSFLIX Havard School
View profile
Follow You need to be logged in order to follow users or courses
Sold
39
Member since
2 year
Number of followers
11
Documents
214
Last sold
1 month ago
I have Accounting, Finance, Statistics, Computer Science, Nursing, Chemistry, Biology And All Other Subjects A+ solutions

A+ SOLUTIONS FOR FELLOW STUDENTS Nursing Being my main profession line, My mission is to be your LIGHT in the dark. If you're worried or having trouble in nursing school, I really want my notes to be your guide! I know they have helped countless others get through and that's all I want for YOU! I have essential guides that are Almost A+ graded, I am a very friendly person:

3.3

9 reviews

5
3
4
3
3
0
2
0
1
3

Recently viewed by you

Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions