This edition of SPREADSHEET MODELING AND DECISION ANALYSIS, written by business analytics expert Cliff Ragsdale, equips readers with essential spreadsheet and business analytics skills. With clear explanations, practical examples, and relevant software, you'll gain proficiency in the latest business analytics techniques using Excel® in Microsoft® Office 365 or Office 2019. This book presents both algebraic and spreadsheet modeling methods, providing step-by-step instructions and real-world applications of descriptive, predictive, and prescriptive analytics. WebAssign online tools and author-created videos further strengthen understanding.
- Content highlights frontline systems’ analytic solver® and data mining add-ins for excel.
- A thoroughly revised and carefully crafted set of PowerPoint® slides and Excel solution files, prepared by the text author, reduce your preparation time while providing tools to clarify concepts in your course.
- Updated content highlights the latest excel for Microsoft office 365 and office 2019.
- Step-by-step instructions and numerous annotated screenshots make examples easy to follow and understand.
- Powerful tools in the Analytic Solver for Excel enable students to perform optimization, simulation, data mining, and work with decision trees in spreadsheets.
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.
13. Queuing Theory.
14. Decision Analysis.
15. Project Management (Online).
Cliff Ragsdale
A leading 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.
