Professional

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

### Overview

SPREADSHEET MODELING AND DECISION ANALYSIS, Seventh Edition, provides instruction in the most commonly used management science techniques and shows how these tools can be implemented using Microsoft® Office Excel® 2013.

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

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.