Request for consultation

Thanks for your request. You’ll soon be chatting with a consultant to get the answers you need.
{{formPostErrorMessage.message}} [{{formPostErrorMessage.code}}]
First Name is required. 'First Name' must contain at least 0 characters 'First Name' cannot exceed 0 characters Please enter a valid First Name
Last Name is required. 'Last Name' must contain at least 0 characters 'Last Name' cannot exceed 0 characters Please enter a valid Last Name
Institution is required.
Discipline is required.
Why are you contacting us today? is required. 'Why are you contacting us today?' must contain at least 0 characters 'Why are you contacting us today?' cannot exceed 0 characters Please enter a valid Why are you contacting us today?

Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics 7th Edition

Cliff Ragsdale

  • Published
  • Previous Editions 2011, 2008, 2007
  • 840 Pages

Overview

Cliff Ragsdale is an innovator of the spreadsheet teaching revolution and is highly regarded in the field of management science. The seventh edition of SPREADSHEET MODELING AND DECISION ANALYSIS: A PRACTICAL INTRODUCTION TO BUSINESS ANALYTICS retains the elements and philosophy that has made its past editions so successful and includes elements that assist in the transition to business analytics. This version of SPREADSHEET MODELING AND DECISION ANALYSIS has been updated for use with Microsoft® Office Excel® 2013. It provides succinct instruction in the most commonly used management science techniques and shows how these tools can be implemented using the most current version of Excel® for Windows. This text also focuses on developing both algebraic and spreadsheet modeling skills. Analytic Solver Platform replaces Risk Solver Platform in the seventh edition. Analytic Solver Platform includes all of the capabilities of Risk Solver for risk analysis and Monte Carlo simulation, all of the capabilities of Premium Solver Platform for optimization, and new capabilities for finding robust optimal decisions using simulation, optimization, stochastic programming, and robust optimization methods.

Cliff Ragsdale, Virginia Polytechnic Institute and State University

A recognized innovator in spreadsheet instruction and highly regarded pioneer in business analytics, Dr. Cliff Ragsdale is the Bank of America Professor of Business Information Technology and Academic Director of the Center for Business Intelligence and Analytics in the Pamplin College of Business at Virginia Tech, where he has taught since 1990. Dr. Ragsdale received his Ph.D. in Management Science and Information Technology from the University of Georgia. He also holds an M.B.A. in Finance and B.A. in Psychology from the University of Central Florida. Before pursuing his Ph.D., he was supervisor of Benefit Finance & Qualified Plans at the international headquarters of Red Lobster, Inc. He has served as an information systems and statistical consultant for a variety of companies and as an expert witness in the area of spreadsheet forensics. Dr. Ragsdale's primary areas of research interest include applications of artificial intelligence, mathematical programming, and applying statistics to business problems. His research has appeared in Decision Sciences, Naval Research Logistics, Omega: The International Journal of Management Science, Computers & Operations Research, Operations Research Letters, Personal Financial Planning, and other publications. He has received both the Pamplin award for excellence in teaching and the Outstanding Doctoral Educator Award from the Pamplin College of Business Administration at Virginia Tech. Dr. Ragsdale is a Fellow of the Decision Sciences Institute and active member of DSI and INFORMS.
  • This edition of Spreadsheet Modeling and Decision Analysis has been updated for use with Microsoft® Office Excel® 2013.
  • NEW! Analytic Solver Platform replaces Risk Solver Platform in the seventh edition. Analytic Solver Platform includes all of the capabilities of Risk Solver for risk analysis and Monte Carlo simulation, all of the capabilities of Premium Solver Platform for optimization, and new capabilities for finding robust optimal decisions using simulation, optimization, stochastic programming, and robust optimization methods.
  • NEW! The chapter on Discriminant Analysis has been replaced with a new chapter on Data Mining. The data mining software package known as XLMiner now comes with the book, providing easy access to all major data mining techniques from within Excel.
  • New, more automated techniques for ad hoc sensitivity analysis are featured in Chapter 4.
  • Updated content reflects Microsoft® Office Excel® 2013 coverage, providing students with the most current information for dealing with key management science decision making.
  • Algebraic formulations and spreadsheets are used side-by-side to help develop conceptual thinking skills. Step-by-step instructions and numerous annotated screenshots make examples easy to follow and understand.
  • A new chapter on Data Mining extends and replaces the chapter on Discriminant Analysis in earlier editions of Spreadsheet Modeling and Decision Analysis. The data mining software package called XLMiner now comes with the book, providing easy access to all major data mining techniques from within Excel.
  • Analytic Solver Platform replaces Risk Solver Platform in the seventh edition. Analytic Solver Platform includes all of the capabilities of Risk Solver Platform for risk analysis and Monte Carlo simulation, all of the capabilities of Premium Solver Platform for optimization, and new capabilities for finding robust optimal decisions using simulation, optimization, stochastic programming, and robust optimization methods.
  • Simplified approaches for ad hoc sensitivity analysis are integrated in Chapter 4, featuring new capabilities available in Analytic Solver Platform.
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 and the Simplex Method.
5. Network Modeling.
6. Integer Linear Programming.
7. Goal Programming and Multiple Objective Optimization.
8. Nonlinear Programming & Evolutionary Optimization.
9. Regression Analysis.
10. Data Mining.
11. Time Series Forecasting.
12. Introduction to Simulation Using Analytic Solver Platform.
13. Queuing Theory.
14. Decision Analysis.
15. Project Management (Online).

Textbook Only Options

Traditional eBook and Print Options

{{collapseContainerClosed['detail_0'] ? 'Show More' : 'Show Less'}}
z

  • ISBN-10: 1305152077
  • ISBN-13: 9781305152076
  • STARTING AT $27.49

  • STARTING AT $48.49

  • ISBN-10: 1285418689
  • ISBN-13: 9781285418681
  • Bookstore Wholesale Price $243.75
  • RETAIL $324.95

Cengage provides a range of supplements that are updated in coordination with the main title selection. For more information about these supplements, contact your Learning Consultant.

FOR INSTRUCTORS

Instructor’s Companion Website

ISBN: 9781337274821
Find everything you need for your course in one place. This collection of product-specific lecture and class tools is available online via the instructor resource center at www.cengage.com/login. You'll be able to access and download materials, such as PowerPoint® presentations, images, instructor’s manual, videos, and more.

Cengage Learning Testing, powered by Cognero® Instant Access

ISBN: 9781337274845
Cengage Learning Testing, powered by Cognero®, is a flexible, online system that allows you to import, edit, and manipulate content from the text’s test bank or elsewhere, including your own favorite test questions. Create multiple test versions in an instant and deliver tests from your LMS, your classroom, or wherever you want.