Quantitative Methods for Decision Making Using Excel
Quantitative Methods for Decision Making Using Excel

Author: Glyn Davis

Publisher: Oxford University Press, USA

Published: 2012-11-22

Total Pages: 653

ISBN-13: 0199694060

DOWNLOAD EBOOK

Quantitative Methods for Decision Making is a comprehensive guide that provides students with the key techniques and methodology they will need to successfully engage with all aspects of quantitative analysis and decision making; both on their undergraduate course, and in the larger context of their future business environments. Organized in accordance with the enterprise functional structure where the decision making takes place, the textbook encompasses a broad range of functions, each detailed with clear examples illustrated through the single application tool Microsoft Excel. The authors approach a range of methods which are divided into major enterprise functions such as marketing, sales, business development, manufacturing, quality control and finance; illustrating how the methods can be applied in practice and translated into a working environment. Each chapter is packed with short case studies to exemplify the practical use of techniques, and contains a wealth of exercises after key sections and concepts, giving students the opportunity to monitor their own progress using the solutions at the back of the book. An Online Resource Centre accompanies the text and includes: For students: - Numerical skills workbook with additional exercises, questions and content - Data from the examples and exercises in the book - Online glossary of terms - Revision tips - Visual walkthrough videos covering the application of a range of quantitative methods - Appendices to the book For lecturers: - Instructor's manual including solutions from the text and a guide to structuring lectures and seminars - PowerPoint presentations - Test bank with questions for each chapter - Suggested assignment and examination questions

Quantitative Methods for Management
Quantitative Methods for Management

Author: Miguel Ángel Canela

Publisher: Springer

Published: 2019-07-03

Total Pages: 142

ISBN-13: 3030175545

DOWNLOAD EBOOK

This book focuses on the use of quantitative methods for both business and management, helping readers understand the most relevant quantitative methods for managerial decision-making. Pursuing a highly practical approach, the book reduces the theoretical information to a minimum, so as to give full prominence to the analysis of real business problems. Each chapter includes a brief theoretical explanation, followed by a real-life managerial case that needs to be solved, which is accompanied by a corresponding Microsoft Excel® dataset. The practical cases and exercises are solved using Excel, and for each problem, the authors provide an Excel file with the complete solution and corresponding calculations, which can be downloaded easily from the book’s website. Further, in an appendix, readers can find solutions to the same problems, but using the R statistical language. The book represents a valuable reference guide for postgraduate, MBA and executive education students, as it offers a hands-on, practical approach to learning quantitative methods in a managerial context. It will also be of interest to managers looking for a practical and straightforward way to learn about quantitative methods and improve their decision-making processes.

Quantitative Methods in Health Care Management
Quantitative Methods in Health Care Management

Author: Yasar A. Ozcan

Publisher: John Wiley & Sons

Published: 2009-04-20

Total Pages: 6

ISBN-13: 0470449039

DOWNLOAD EBOOK

Thoroughly revised and updated for Excel®, this second edition of Quantitative Methods in Health Care Management offers a comprehensive introduction to quantitative methods and techniques for the student or new administrator. Its broad range of practical methods and analysis spans operational, tactical, and strategic decisions. Users will find techniques for forecasting, decision-making, facility location, facility layout, reengineering, staffing, scheduling, productivity, resource allocation, supply chain and inventory management, quality control, project management, queuing models for capacity, and simulation. The book's step-by-step approach, use of Excel, and downloadable Excel templates make the text highly practical. Praise for the Second Edition "The second edition of Dr. Ozcan's textbook is comprehensive and well-written with useful illustrative examples that give students and health care professionals a perfect toolkit for quantitative decision making in health care on the road for the twenty-first century. The text helps to explain the complex health care management problems and offer support for decision makers in this field." Marion Rauner, associate professor, School of Business, Economics, and Statistics, University of Vienna. "Quantitative Methods in Health Care Administration, Second Edition covers a broad set of necessary and important topics. It is a valuable text that is easy to teach and learn from." David Belson, professor, Department of Industrial Engineering, Viterbi School of Engineering, University of Southern California.

Quantitative Finance
Quantitative Finance

Author: Matt Davison

Publisher: CRC Press

Published: 2014-05-08

Total Pages: 523

ISBN-13: 1439871698

DOWNLOAD EBOOK

Teach Your Students How to Become Successful Working Quants Quantitative Finance: A Simulation-Based Introduction Using Excel provides an introduction to financial mathematics for students in applied mathematics, financial engineering, actuarial science, and business administration. The text not only enables students to practice with the basic techniques of financial mathematics, but it also helps them gain significant intuition about what the techniques mean, how they work, and what happens when they stop working. After introducing risk, return, decision making under uncertainty, and traditional discounted cash flow project analysis, the book covers mortgages, bonds, and annuities using a blend of Excel simulation and difference equation or algebraic formalism. It then looks at how interest rate markets work and how to model bond prices before addressing mean variance portfolio optimization, the capital asset pricing model, options, and value at risk (VaR). The author next focuses on binomial model tools for pricing options and the analysis of discrete random walks. He also introduces stochastic calculus in a nonrigorous way and explains how to simulate geometric Brownian motion. The text proceeds to thoroughly discuss options pricing, mostly in continuous time. It concludes with chapters on stochastic models of the yield curve and incomplete markets using simple discrete models. Accessible to students with a relatively modest level of mathematical background, this book will guide your students in becoming successful quants. It uses both hand calculations and Excel spreadsheets to analyze plenty of examples from simple bond portfolios. The spreadsheets are available on the book’s CRC Press web page.

Quantitative Decision Making with Spreadsheet Applications
Quantitative Decision Making with Spreadsheet Applications

Author: Lawrence L. Lapin

Publisher: South Western Educational Publishing

Published: 2002

Total Pages: 858

ISBN-13:

DOWNLOAD EBOOK

Written for students with a background in algebra, this text provides a complete and modern treatment of basic management science methodology. The authors survey the variety and power of management science tools, working to alleviate students' apprehension about the subject and to enable students to recognize on-the-job situations in which management science methodology can be successfully employed. Emphasizing modeling skills for students of varying mathematical backgrounds, the authors explain how to use Microsoft Excel spreadsheets to build skills as they work through problems. In general, problems are broken into several parts to make difficult concepts easy for students to learn. This book's modular structure affords instructors maximum flexibility. This text contains a special student version of Palisade Corporation's DecisionTools Suite, containing @Risk, PrecisionTree, BestFit, TopRank and RiskView. This software is expressly provided for student use and requires student authorization to unlock the software for its full one year license. Professional customers may use the software for 30 days at which point they must contact Palisade Corporation for a professional version should they wish to continue using the software.

Data Analysis & Decision Making with Microsoft Excel
Data Analysis & Decision Making with Microsoft Excel

Author: Samuel Christian Albright

Publisher: South-Western Pub

Published: 2009

Total Pages: 1090

ISBN-13: 9780324663501

DOWNLOAD EBOOK

Master data analysis, modeling, and spreadsheet use with DATA ANALYSIS AND DECISION MAKING WITH MICROSOFT EXCEL! With a teach-by-example approach, student-friendly writing style, and complete Excel integration, this quantitative methods text provides you with the tools you need to succeed. Margin notes, boxed-in definitions and formulas in the text, enhanced explanations in the text itself, and stated objectives for the examples found throughout the text make studying easy. Problem sets and cases provide realistic examples that enable you to see the relevance of the material to your future as a business leader. The CD-ROMs packaged with every new book include the following add-ins: the Palisade Decision Tools Suite (@RISK, StatTools, PrecisionTree, TopRank, and RISKOptimizer); and SolverTable, which allows you to do sensitivity analysis. All of these add-ins have been revised for Excel 2007.

Operations Research Using Excel
Operations Research Using Excel

Author: Vikas Singla

Publisher: CRC Press

Published: 2021-09-16

Total Pages: 409

ISBN-13: 1000453448

DOWNLOAD EBOOK

The field of operations research provides a scientific approach to managerial decision making. In a contemporary, hypercompetitive ever-changing business world, a manager needs quantitative and factual ways of solving problems related to optimal allocation of resources, profit/loss, maximization/minimization etc. In this endeavor, the subject of doing research on how to manage and make operations efficient is termed as Operations Research. The reference text provides conceptual and analytical knowledge for various operations research techniques. Readers, especially students of this subject, are skeptic in dealing with the subject because of its emphasis on mathematics. However, this book has tried to remove such doubts by focusing on the application part of OR techniques with minimal usage of mathematics. The attempt was to make students comfortable with some complicated topics of the subject. It covers important concepts including sensitivity analysis, duality theory, transportation solution method, Hungarian algorithm, program evaluation and review technique and periodic review system. Aimed at senior undergraduate and graduate students in the fields of mechanical engineering, civil engineering, industrial engineering and production engineering, this book: • Discusses extensive use of Microsoft Excel spreadsheets and formulas in solving operations research problems • Provides case studies and unsolved exercises at the end of each chapter • Covers industrial applications of various operations research techniques in a comprehensive manner • Discusses creating spreadsheets and using different Excel formulas in an easy-to-understand manner • Covers problem-solving procedures for techniques including linear programming, transportation model and game theory

Health Services Research and Analytics Using Excel
Health Services Research and Analytics Using Excel

Author: Nalin Johri, PhD, MPH

Publisher: Springer Publishing Company

Published: 2020-02-01

Total Pages: 252

ISBN-13: 0826150284

DOWNLOAD EBOOK

Your all-in-one resource for quantitative, qualitative, and spatial analyses in Excel® using current real-world healthcare datasets. Health Services Research and Analytics Using Excel® is a practical resource for graduate and advanced undergraduate students in programs studying healthcare administration, public health, and social work as well as public health workers and healthcare managers entering or working in the field. This book provides one integrated, application-oriented resource for common quantitative, qualitative, and spatial analyses using only Excel. With an easy-to-follow presentation of qualitative and quantitative data, students can foster a balanced decision-making approach to financial data, patient statistical data and utilization information, population health data, and quality metrics while cultivating analytical skills that are necessary in a data-driven healthcare world. Whereas Excel is typically considered limited to quantitative application, this book expands into other Excel applications based on spatial analysis and data visualization represented through 3D Maps as well as text analysis using the free add-in in Excel. Chapters cover the important methods and statistical analysis tools that a practitioner will face when navigating and analyzing data in the public domain or from internal data collection at their health services organization. Topics covered include importing and working with data in Excel; identifying, categorizing, and presenting data; setting bounds and hypothesis testing; testing the mean; checking for patterns; data visualization and spatial analysis; interpreting variance; text analysis; and much more. A concise overview of research design also provides helpful background on how to gather and measure useful data prior to analyzing in Excel. Because Excel is the most common data analysis software used in the workplace setting, all case examples, exercises, and tutorials are provided with the latest updates to the Excel software from Office365 ProPlus® and newer versions, including all important “Add-ins” such as 3D Maps, MeaningCloud, and Power Pivots, among others. With numerous practice problems and over 100 step-by-step videos, Health Services Research and Analytics Using Excel® is an extremely practical tool for students and health service professionals who must know how to work with data, how to analyze it, and how to use it to improve outcomes unique to healthcare settings. Key Features: Provides a competency-based analytical approach to health services research using Excel Includes applications of spatial analysis and data visualization tools based on 3D Maps in Excel Lists select sources of useful national healthcare data with descriptions and website information Chapters contain case examples and practice problems unique to health services All figures and videos are applicable to Office365 ProPlus Excel and newer versions Contains over 100 step-by-step videos of Excel applications covered in the chapters and provides concise video tutorials demonstrating solutions to all end-of-chapter practice problems Robust Instructor ancillary package that includes Instructor’s Manual, PowerPoints, and Test Bank

Essential Quantitative Methods
Essential Quantitative Methods

Author: Les Oakshott

Publisher: Bloomsbury Publishing

Published: 2020-01-25

Total Pages: 458

ISBN-13: 1352005700

DOWNLOAD EBOOK

This well-loved textbook covers all of the key quantitative methods needed to solve everyday business problems. Presented in a highly accessible and concise manner, Les Oakshott's clear and friendly writing style guides students from basic statistics through to advanced topics, such as hypothesis testing and time series, as well as operational research techniques such as linear programming and inventory management. Step-by-step instructions and accompanying activities will help students to practice and gain confidence in carrying out techniques. The book's coverage is fully grounded within the real world of business. Real-life case studies open every chapter and numerous examples throughout demonstrate why quantitative techniques are needed for a business to be successful. An ideal textbook for undergraduate students of business, management and finance, it is also suitable for MBA students and postgraduates. Accompanying online resources for this title can be found at bloomsburyonlineresources.com/essential-quantitative-methods-7e. These resources are designed to support teaching and learning when using this textbook and are available at no extra cost.