Master data analysis, modeling and the effective use of spreadsheets with the popular BUSINESS ANALYTICS: DATA ANALYSIS AND DECISION MAKING, 7E. The quantitative methods approach in this edition helps you maximize your success with a proven teach-by-example presentation, inviting writing style and complete integration of the latest version of Excel. The approach is also compatible with earlier versions of Excel for your convenience. This edition is more data-oriented than ever before with a new chapter on the two main Power BI tools in Excel -- Power Query and Power Pivot -- and a new section of data visualization with Tableau Public. Current problems and cases demonstrate the importance of the concepts you are learning. In addition, a useful Companion Website provides data and solutions files, SolverTable for optimization sensitivity analysis and Palisade DecisionTools Suite. MindTap online resources are also available.
- Offers practical technical tips throughout to help students apply concepts using tools like Excel, Solver, and @RISK.
- Includes 130+ real business examples with step-by-step, screenshot-supported solutions.
- Emphasizes modern data analysis tools, including Excel’s Power Query, Power Pivot, and Tableau Public.
- Provides 200 conceptual questions, 1,000 problems, and 40 cases with Excel-based solutions.
- MindTap resources include interactive tutorials, randomized homework, and Excel-based activities.
- Key concepts are highlighted with visual learning tools, margin notes, and “Fundamental Insight” boxes.
- Each chapter opens with engaging vignettes to show real-world relevance.
- New Excel activities in MindTap offer hands-on spreadsheet problem-solving with instant feedback.
- Fully compatible with Excel for Office 365, Windows, and Mac, including older versions.
- Chapter 1 now includes introductory Excel modeling and functions like IF, VLOOKUP, and Goal Seek.
- A free DADM_TOOLS Excel add-in offers simplified tools for analysis and simulation.
- New chapter overview videos introduce key themes and prepare students for success.
- Updated problems use current business data, with a searchable problem database for instructors.
- Probability content is streamlined into a single chapter for clarity and efficiency.
- New chapter on Power BI tools and data visualization enhances business analytics coverage.
1. Introduction to Business Analytics
Part 1: DATA ANALYSIS
2. Describing the Distribution of a Variable
3. Finding Relationships among Variables
4. Business Intelligence (BI) Tools for Data Analysis
Part 2: PROBABILITY AND DECISION MAKING UNDER UNCERTAINTY
5. Probability and Probability Distributions
6. Decision Making under Uncertainty
Part 3: STATISTICAL INFERENCE
7. Sampling and Sampling Distributions
8. Confidence Interval Estimation
9. Hypothesis Testing
Part 4: REGRESSION ANALYSIS AND TIME SERIES FORECASTING
10. Regression Analysis: Estimating Relationships
11. Regression Analysis: Statistical Inference
12. Time Series Analysis and Forecasting
Part 5: OPTIMIZATION AND SIMULATION MODELING
13. Introduction to Optimization Modeling
14. Optimization Models
15. Introduction to Simulation Modeling
16. Simulation Models
Part 6: ADVANCED DATA ANALYSIS
17. Data Mining
Part 7: BONUS ONLINE MATERIAL
18. Analysis of Variance and Experimental Design
19. Statistical Process Control
Appendix A: Statistical Reporting
S. Christian Albright
S. Christian Albright received both his B.S. degree in mathematics and his Ph.D. in operations research from Stanford.
Wayne L. Winston
Wayne L. Winston is Professor Emeritus of Decision Sciences at the Kelley School of Business at Indiana University and is now Professor of Decision and Information Sciences at the Bauer College at the University of Houston
