Higher Education

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

  • Cliff Ragsdale Virginia Polytechnic Institute and State University
  • ISBN-10: 1285418689  |  ISBN-13: 9781285418681
  • 840 Pages
  • Previous Editions: 2011, 2008, 2007
  • © 2015 | Published
  • College Bookstore Wholesale Price = $276.00

About

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.

Features and Benefits

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

Table of Contents

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

What's New

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

Meet the Author

Author Bio

Cliff Ragsdale

Cliff Ragsdale is the Bank of America Professor, Department of Business Information Technology in the Pamplin College of Business at Virginia Tech, where he has taught since 1990. He 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.