100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached 4,6 TrustPilot
logo-home
Exam (elaborations)

TEST BANK for Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analytics, 8th Edition By Cliff Ragsdale

Rating
-
Sold
3
Pages
645
Grade
A+
Uploaded on
28-08-2024
Written in
2024/2025

TEST BANK for Spreadsheet Modeling and Decision Analysis A Practical Introduction to Business Analytics, 8th Edition By Cliff Ragsdale

Institution
Spreadsheet Modeling And Decision Analysis A Pract
Course
Spreadsheet Modeling and Decision Analysis A Pract











Whoops! We can’t load your doc right now. Try again or contact support.

Written for

Institution
Spreadsheet Modeling and Decision Analysis A Pract
Course
Spreadsheet Modeling and Decision Analysis A Pract

Document information

Uploaded on
August 28, 2024
Number of pages
645
Written in
2024/2025
Type
Exam (elaborations)
Contains
Questions & answers

Subjects

Content preview

,Name: Class: Date:

ch 1

Indicate whether the statement is true or false.

1. Defining a problem well will often make it much easier to solve.
a. True
b. False

2. Because they simplify reality, models are generally not helpful in examining things that would be impossible to
do in reality.
a. True
b. False

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

4. Humans usually do not make errors in estimation due to anchoring and framing effects.
a. True
b. False

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

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

7. OR/MS specialists do not deliver business value.
a. True
b. False

8. Good decisions always result in good outcomes.
a. True
b. False

Indicate the answer choice that best completes the statement or answers the question.

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

10. A situation when decision quality is good and the resulting outcome quality is good is referred to as
Copyright Cengage Learning. Powered by Cognero. Page 1

,Name: Class: Date:

ch 1

a. pure luck.
b. deserved success.
c. dumb luck.
d. poetic justice.

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

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

13. 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.
d. replicate the characteristics of a component in isolation from the rest of the system.

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

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

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

17. If results testing produces unsatisfactory results
a. the problem-solving process requires new formulation and implementation.
Copyright Cengage Learning. Powered by Cognero. Page 2

, Name: Class: Date:

ch 1

b. minor adjustments to the existing model.
c. checking the solution algorithm.
d. repeated testing.

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

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

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

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

23. Consider the spreadsheet model shown in the figure below. This is an example of a

A B C
1
2
3 Purchase price $32,500
4 less:
Copyright Cengage Learning. Powered by Cognero. Page 3

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.
AcademiContent Aalborg University
View profile
Follow You need to be logged in order to follow users or courses
Sold
3075
Member since
6 year
Number of followers
2133
Documents
1233
Last sold
19 hours ago

4.0

388 reviews

5
205
4
84
3
38
2
17
1
44

Why students choose Stuvia

Created by fellow students, verified by reviews

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

Didn't get what you expected? Choose another document

No worries! You can immediately select a different document that better matches what you need.

Pay how you prefer, start learning right away

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

Student with book image

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

Alisha Student

Frequently asked questions