Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics

by Cliff Ragsdale

Overview

Master key spreadsheet and business analytics skills with SPREADSHEET MODELING AND DECISION ANALYSIS: A PRACTICAL INTRODUCTION TO BUSINESS ANALYTICS, 9E, written by respected business analytics innovator Cliff Ragsdale. This edition's clear presentation, realistic examples, fascinating topics and valuable software provide everything you need to become proficient in today's most widely used business analytics techniques using the latest version of Excel in Microsoft Office 365 or Office 2019. Become skilled in the newest Excel functions as well as Analytic Solver and Data Mining add-ins. This edition helps you develop both algebraic and spreadsheet modeling skills. Step-by-step instructions and annotated, full-color screen images make examples easy to follow and show you how to apply what you learn about descriptive, predictive and prescriptive analytics to real business situations. WebAssign online tools and author-created videos further strengthen understanding.

Product Details

ISBN-13:	9780357132098
Publisher:	Cengage Learning
Publication date:	09/28/2021
Series:	MindTap Course List
Edition description:	New Edition
Pages:	864
Product dimensions:	7.95(w) x 10.16(h) x 1.50(d)

About the Author

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. 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 supervised benefit finance and 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 numerous publications, including Decision Sciences; Naval Research Logistics; Omega: The International Journal of Management Science; Computers & Operations Research; Operations Research Letters and Personal Financial Planning. 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 (DSI) 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).