Business Analytics: The Art of Modeling With Spreadsheets, 5th Edition
Stephen G. Powell; Kenneth R. Baker, ""
English | ISBN: 1119298423 | 2016 | PDF | 552 pages | 17 MB
Now in its fifth edition, Powell and Baker’s Business Analytics: The Art of Modeling with Spreadsheets provides students and business analysts with the technical knowledge and skill needed to develop real expertise in business modeling. In this book, the authors cover spreadsheet engineering, management science, and the modeling craft. The briefness & accessibility of this title offers opportunities to integrate other materials –such as cases -into the course. It can be used in any number of courses or departments where modeling is a key skill.
Table of Contents Chapter 1 Introduction 1
Chapter 2 Modeling In a Problem-Solving Framework 15
Chapter 3 Spreadsheet Engineering 49
Chapter 4 Analysis Using Spreadsheets 71
Chapter 5 Data Exploration and Preparation 89
Chapter 6 Classification and Prediction Methods 117
Chapter 7 Short-Term Forecasting 187
Chapter 8 Nonlinear Optimization 207
Chapter 9 Linear Optimization 239
Chapter 10 Optimization of Network Models 277
Chapter 11 Integer Optimization 309
Chapter 12 Optimization of Nonsmiith Models 335
Chapter 13 Decision Analysis 357
Chapter 14 Monte Carlo Simulation 383
Chapter 15 Optimization in Simulation 435
Modeling Cases 463
Appendix 1 479
Appendix 2 507
Appendix 3 515