Nelson Higher Education

Higher Education

Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics, 8th Edition

  • Cliff Ragsdale
  • ISBN-10: 130594741X
  • ISBN-13: 9781305947412
  • 864 Pages | Hardcover
  • Previous Editions: 2015, 2011, 2008
  • COPYRIGHT: 2018 Published
Request a Copy for Review

Overview

About the Product

Written by the innovator of the spreadsheet teaching revolution and highly regarded leader in business analytics, Cliff Ragsdale’s new edition of SPREADSHEET MODELING AND DECISION ANALYSIS: A PRACTICAL INTRODUCTION TO BUSINESS ANALYTICS retains the elements and philosophy of past success while now helping your students transition to business analytics. SPREADSHEET MODELING AND DECISION ANALYSIS, 8E’s updates work seamlessly with Microsoft® Office Excel® 2016. Succinct instruction highlights the most commonly used business analytics techniques and clearly demonstrates how to implement these tools with the most current version of Excel® for Windows. This text focuses on developing both algebraic and spreadsheet modeling skills. This edition now features Analytic Solver and XLMiner Platforms with powerful tools for performing optimization, simulation and decision analysis in Excel, as well as complete tools for performing data mining in Excel and techniques for predictive analytics.

Features

  • UPDATED CONTENT REFLECTS MICROSOFT® OFFICE EXCEL® 2016. This timely coverage provides students with the most current information for dealing with key business analytics decision making problems.

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

  • ANALYTIC SOLVER PLATFORM PROVIDES HANDS-ON EXPERIENCE WITH STATE-OF-THE-ART BUSINESS ANALYTICS SOFTWARE. Powerful tools in the Analytic Solver Platform enable students to perform optimization and simulation and work with decision trees in Excel. This tool also provides the capabilities for performing simulation optimization and robust optimization methods.

  • XLMINER PLATFORM OFFERS A COMPLETE SUITE OF TOOLS FOR HANDS-ON EXPERIENCE. This leading business analytics software provides a variety of data mining tools and techniques including data import and cleansing, data exploration and visualization, feature selection, clustering, affinity analysis. Students also find a variety of techniques for predictive analytics including discriminant analysis, neural networks, logistic regression, classification and regression trees, k-nearest neighbor, naïve Bayes, and times-series analysis.

  • AUTHOR-CREATED TEACHING RESOURCES ENHANCE CLASS PRESENTATION AND REDUCE PREPARATION. A thorough 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.

About the Author

Cliff Ragsdale

A recognized 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. 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.

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

New to this edition

  • NEW MINDTAP® DIGITAL LEARNING SOLUTION HELPS YOU ENGAGE TODAY’S STUDENTS. This all-digital version of the book enhances student learning in each chapter with an engagement video and discussion, a quiz with rich feedback, videos by the author that explain chapter concepts, and end-of-chapter assignments that are tailored to work well digitally.
  • THE LATEST VERSION OF MICROSOFT EXCEL 2016 IS FEATURED THROUGHOUT. All screen shots and instructions throughout this edition reflect the latest version of Excel to prepare your students with the contemporary skills they will need.
  • EXPANDED DISCUSSION EMPHASIZES GOOD DECISION MAKING. This key discussion in Chapter 1 clearly defines good decision making while updated examples highlight successful applications of business analytics in large organizations.
  • NEW COVERAGE HIGHLIGHTS THE LINE BALANCING PROBLEM. New, key material in Chapter 6 (Integer Linear Programming) provides a new example of integer programming that is interesting, challenging, and practical.
  • MAJOR UPDATES REFLECT CHANGES IN THE XLMINER PLATFORM SOFTWARE. Coverage in Chapter 10 (Data Mining) now also covers ROC and AUC graphs as well as the concepts of precision, recall, specificity, and the F1 score.
  • NEW AND REVISED END-OF-CHAPTER QUESTIONS CHECK READER UNDERSTANDING. New question and application opportunities throughout the book ensure students understand key principles.

Supplements

All supplements have been updated in coordination with the Main title.
Please see Main title page for new to this edition information.

Instructor Supplements

Instructor’s Companion Website  (ISBN-10: 1337274828 | ISBN-13: 9781337274821)

Find everything you need for your course in one place. This collection of product-specific lecture and class tools is available online via the instructor resource center at www.cengage.com/login. You'll be able to access and download materials, such as PowerPoint® presentations, images, instructor’s manual, videos, and more.

Cengage Testing, powered by Cognero® Instant Access  (ISBN-10: 1337274844 | ISBN-13: 9781337274845)

Cengage Learning Testing, powered by Cognero®, is a flexible, online system that allows you to import, edit, and manipulate content from the text’s test bank or elsewhere, including your own favorite test questions. Create multiple test versions in an instant and deliver tests from your LMS, your classroom, or wherever you want.

MindTap Business Analytics, 1 term (6 months) Instant Access for Ragsdale's Spreadsheet Modeling & Decision Analysis  (ISBN-10: 133756334X | ISBN-13: 9781337563345)

MindTap Business Analytics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition is the digital learning solution that helps instructors engage and transform today's students into critical thinkers. Through paths of dynamic assignments and applications that you can personalize, real-time course analytics, and an accessible reader, MindTap helps you turn cookie-cutter into cutting-edge, apathy into engagement, and memorizers into higher-level thinkers. As an instructor using MindTap, you have at your fingertips the right content and unique set of tools curated specifically for your course, all in an interface designed to improve workflow and save time when planning lessons and course structure. Every element of this MindTap product is new for 8e—there are quizzes with rejoinders to help your students prepare for tests, videos by the author that demonstrate and explain key concepts in detail, and flashcards that will help your students master the terminology that can be so challenging in this course. Excel data files that accompany the reading are built right into the MindTap reader, so your students have more of what they need all in one place. The control to build and personalize your course is all yours, focusing on the most relevant material while also lowering costs for your students. Stay connected and informed in your course through real-time student tracking that provides the opportunity to adjust the course as needed based on analytics of interactivity in the course.

MindTap Business Analytics, 2 terms (12 months) Instant Access for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th edition  (ISBN-10: 1337274879 | ISBN-13: 9781337274876)

MindTap Business Analytics Instant Access for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition is the digital learning solution that helps instructors engage and transform today's students into critical thinkers. Through paths of dynamic assignments and applications that you can personalize, real-time course analytics, and an accessible reader, MindTap helps you turn cookie-cutter into cutting-edge, apathy into engagement, and memorizers into higher-level thinkers. As an instructor using MindTap, you have at your fingertips the right content and unique set of tools curated specifically for your course, all in an interface designed to improve workflow and save time when planning lessons and course structure. The control to build and personalize your course is all yours, focusing on the most relevant material while also lowering costs for your students. Stay connected and informed in your course through real-time student tracking that provides the opportunity to adjust the course as needed based on analytics of interactivity in the course.

Student Supplements

MindTap Business Analytics, 1 term (6 months) Instant Access for Ragsdale's Spreadsheet Modeling & Decision Analysis  (ISBN-10: 133756334X | ISBN-13: 9781337563345)

It’s 1 AM, there are 20 tabs open on your computer, you lost your flashcards for the test, and you’re so tired you can’t even read. It’d be nice if someone came up with a more efficient way of studying. Luckily, someone did. With a single login for MindTap Business Analytics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition you can connect with your instructor, organize coursework, and have access to a range of study tools, including e-book and apps all in one place! All-new quizzes help you prepare for tests, and give you rich feedback when you mess up. We’ll point you to spots in the book where review will help you the most when you’re short on time. Manage your time and workload without the hassle of heavy books! The MindTap Reader keeps all your notes together, lets you print the material, and will even read text out loud. Need extra practice? Find pre-populated flashcards and the entire eBook in the MindTap Mobile App, as well as quizzes and important course alerts. The author himself has created videos that explain and demonstrate key course concepts. Want to know where you stand? Use the Progress app to track your performance in relation to other students.

MindTap Business Analytics, 2 terms (12 months) Instant Access for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th edition  (ISBN-10: 1337274879 | ISBN-13: 9781337274876)

It’s 1 AM, there are 20 tabs open on your computer, you lost your flashcards for the test, and you’re so tired you can’t even read. It’d be nice if someone came up with a more efficient way of studying. Luckily, someone did. With a single login for MindTap Business Analytics Instant Access for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition you can connect with your instructor, organize coursework, and have access to a range of study tools, including e-book and apps all in one place! Manage your time and workload without the hassle of heavy books! The MindTap Reader keeps all your notes together, lets you print the material, and will even read text out loud. Need extra practice? Find pre-populated flashcards and the entire eBook in the MindTap Mobile App, as well as quizzes and important course alerts. Want to know where you stand? Use the Progress app to track your performance in relation to other students.