Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203
Business Analytics
Third Edition
Jeffrey D. Camm
Wake Forest University
James J. Cochran
University of Alabama
Michael J. Fry
University of Cincinnati
Jeffrey W. Ohlmann
University of Iowa
David R. Anderson
University of Cincinnati
Dennis J. Sweeney
University of Cincinnati
Thomas A. Williams
Rochester Institute
of Technology
Australia • Brazil • Mexico • Singapore • United Kingdom • United States
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
Analytic Solver®
www.solver.com/aspe
Your new textbook, Business Analytics, 3e, uses this software in the eBook
(MindTap Reader). Here’s how to get it for your course.
For Instructors:
Setting Up the Course Code
To set up a course code for your course, please email Frontline Systems at
academic@solver.com, or call 775-831-0300, press 0, and ask for the Academic
Coordinator. Course codes MUST be set up each time a course is taught.
A course code is free, and it can usually be issued within 24 to 48 hours (often
the same day). It will enable your students to download and install Analytic Solver,
use the software free for 2 weeks, and continue to use the software for 20 weeks
(a typical semester) for a small charge, using the course code to obtain a steep
discount. It will enable Frontline Systems to assist students with installation, and
provide technical support to you during the course.
Please give the course code, plus the instructions on the reverse side, to your
students. If you’re evaluating the book for adoption, you can use the course code
yourself to download and install the software as described on the reverse.
Instructions for Students: See reverse.
Installing Analytic Solver
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203
For Students:
Installing Analytic Solver®
1) To download and install Analytic Solver (also called Analytic Solver® Basic) from Frontline Systems
to work with Microsoft® Excel® for Windows®, please visit:
www.solver.com/student
2) Fill out the registration form on this page, supplying your name, school, email address
(key information will be sent to this address), course code (obtain this from your instructor), and
textbook code (enter CCFOEBA3).
3) On the download page, click the Download Now button, and save the downloaded file
(SolverSetup.exe).
4) Close any Excel® windows you have open. Make sure you’re still connected to the Internet.
5) Run SolverSetup.exe to install the software. Be patient – all necessary files will be down-
loaded and installed.
If you have problems downloading or installing, your best options in order are to (i) visit www.solver.
com and click the Live Chat link at the top; (ii) email support@solver.com and watch for a reply;
(iii) call 775-831-0300 and press 4 (tech support). Say that you have Analytic Solver for Education,
and have your course code and textbook code available.
If you have problems setting up or solving your model, or interpreting the results, please ask your
instructor for assistance. Frontline Systems cannot help you with homework problems.
If you have this textbook but you aren’t enrolled in a course, visit www.solver.com or call
775-831-0300 and press 0 for advice on courses and software licenses.
If you have a Mac, your options are to (i) use a version of Analytic Solver through a web
browser at https://analyticsolver.com, or (ii) install “dual-boot” or VM software, Microsoft
Windows®, and Excel® for Windows®. Excel® for Mac will NOT work.
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203
This is an electronic version of the print textbook. Due to electronic rights restrictions,
some third party content may be suppressed. Editorial review has deemed that any suppressed
content does not materially affect the overall learning experience. The publisher reserves the right
to remove content from this title at any time if subsequent rights restrictions require it. For
valuable information on pricing, previous editions, changes to current editions, and alternate
formats, please visit www.cengage.com/highered to search by ISBN#, author, title, or keyword for
materials in your areas of interest.
Important Notice: Media content referenced within the product description or the product
text may not be available in the eBook version.
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203
Business Analytics, Third Edition
Jeffrey D. Camm, James J. Cochran,
Michael J. Fry, Jeffrey W. Ohlmann,
David R. Anderson, Dennis J. Sweeney,
Thomas A. Williams
Senior Vice President, Higher Ed Product,
Content, and Market Development: Erin Joyner
Vice President, B&E, 4LTR, and Support
Programs: Mike Schenk
Senior Product Team Manager: Joe Sabatino
Senior Product Manager: Aaron Arnsparger
Senior Digital Content Designer: Brandon Foltz
Content Developer: Anne Merrill
© 2019, 2017 Cengage Learning, Inc.
Unless otherwise noted, all content is © Cengage.
ALL RIGHTS RESERVED. No part of this work covered by the copyright herein
may be reproduced or distributed in any form or by any means, except as
permitted by U.S. copyright law, without the prior written permission of the
copyright owner.
For product information and technology assistance, contact us at
Cengage Customer & Sales Support, 1-800-354-9706 or
support.cengage.com.
For permission to use material from this text or product,
submit all requests online at www.cengage.com/permissions.
Content Project Manager: D. Jean Buttrom
Screenshots are ©Microsoft Corporation unless otherwise noted.
Product Assistant: Renee Schnee
Senior Marketing Manager: Nathan Anderson
Production Service: SPi Global
Senior Art Director: Michelle Kunkler
Cover and Text Designer: Beckmeyer Design
Cover Image: iStockPhoto.com/tawanlubfah
Intellectual Property Analyst: Reba Frederics
Intellectual Property Project Manager:
Nick Barrows
Library of Congress Control Number: 2017963667
ISBN: 978-1-337-40642-0
Cengage
20 Channel Center Street
Boston, MA 02210
USA
Cengage is a leading provider of customized learning solutions with
employees residing in nearly 40 different countries and sales in more
than 125 countries around the world. Find your local representative at
www.cengage.com.
Cengage products are represented in Canada by
Nelson Education, Ltd.
To learn more about Cengage platforms and services,
visit www.cengage.com.
To register or access your online learning solution or purchase materials
for your course, visit www.cengagebrain.com.
Printed in the United States of America
Print Number: 01 Print Year: 2018
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203
Brief Contents
ABOUT THE AUTHORS XIX
PREFACE XXIII
Introduction 2
Descriptive Statistics 18
Data Visualization 82
Descriptive Data Mining 138
Probability: An Introduction to Modeling Uncertainty 166
Statistical Inference 220
Linear Regression 294
Time Series Analysis and Forecasting 372
Predictive Data Mining 422
Spreadsheet Models 464
CHAPTER 1
CHAPTER 2
CHAPTER 3
CHAPTER 4
CHAPTER 5
CHAPTER 6
CHAPTER 7
CHAPTER 8
CHAPTER 9
CHAPTER 10
CHAPTER 11 Monte Carlo Simulation 500
CHAPTER 12
CHAPTER 13
CHAPTER 14 Nonlinear Optimization Models 646
CHAPTER 15 Decision Analysis 678
APPENDIX A
APPENDIX B
APPENDIX C
Linear Optimization Models 556
Integer Linear Optimization Models 606
Basics of Excel 724
Database Basics with Microsoft Access 736
Solutions to Even-Numbered Questions (MindTap Reader)
REFERENCES
INDEX
774
776
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203
Fit your coursework
into your hectic life.
Make the most of your time by learning
your way. Access the resources you need to
succeed wherever, whenever.
Study with digital flashcards, listen to audio
textbooks, and take quizzes.
Review your current course grade and compare
your progress with your peers.
Get the free MindTap Mobile App and learn
wherever you are.
Break Limitations. Create your
own potential, and be unstoppable
with MindTap.
MINDTAP. POWERED BY YOU.
cengage.com/mindtap
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).
Editorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
Copyright 2019 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. WCN 02-200-203