Quantitative Methods for Decision Making Using Excel

Quantitative Methods for Decision Making Using Excel
Author: Glyn Davis
Publisher: Oxford University Press, USA
Total Pages: 653
Release: 2012-11-22
Genre: Business & Economics
ISBN: 0199694060

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
Total Pages: 142
Release: 2019-07-03
Genre: Business & Economics
ISBN: 3030175545

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
Total Pages: 6
Release: 2009-04-20
Genre: Medical
ISBN: 0470449039

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
Total Pages: 523
Release: 2014-05-08
Genre: Business & Economics
ISBN: 1439871698

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 Methods

Quantitative Methods
Author: Paolo Brandimarte
Publisher: John Wiley & Sons
Total Pages: 812
Release: 2012-01-03
Genre: Mathematics
ISBN: 111802348X

An accessible introduction to the essential quantitative methods for making valuable business decisions Quantitative methods-research techniques used to analyze quantitative data-enable professionals to organize and understand numbers and, in turn, to make good decisions. Quantitative Methods: An Introduction for Business Management presents the application of quantitative mathematical modeling to decision making in a business management context and emphasizes not only the role of data in drawing conclusions, but also the pitfalls of undiscerning reliance of software packages that implement standard statistical procedures. With hands-on applications and explanations that are accessible to readers at various levels, the book successfully outlines the necessary tools to make smart and successful business decisions. Progressing from beginner to more advanced material at an easy-to-follow pace, the author utilizes motivating examples throughout to aid readers interested in decision making and also provides critical remarks, intuitive traps, and counterexamples when appropriate. The book begins with a discussion of motivations and foundations related to the topic, with introductory presentations of concepts from calculus to linear algebra. Next, the core ideas of quantitative methods are presented in chapters that explore introductory topics in probability, descriptive and inferential statistics, linear regression, and a discussion of time series that includes both classical topics and more challenging models. The author also discusses linear programming models and decision making under risk as well as less standard topics in the field such as game theory and Bayesian statistics. Finally, the book concludes with a focus on selected tools from multivariate statistics, including advanced regression models and data reduction methods such as principal component analysis, factor analysis, and cluster analysis. The book promotes the importance of an analytical approach, particularly when dealing with a complex system where multiple individuals are involved and have conflicting incentives. A related website features Microsoft Excel® workbooks and MATLAB® scripts to illustrate concepts as well as additional exercises with solutions. Quantitative Methods is an excellent book for courses on the topic at the graduate level. The book also serves as an authoritative reference and self-study guide for financial and business professionals, as well as readers looking to reinforce their analytical skills.

Operations Research Using Excel

Operations Research Using Excel
Author: Vikas Singla
Publisher: CRC Press
Total Pages: 336
Release: 2021-09-16
Genre: Technology & Engineering
ISBN: 1000453464

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

Quantitative Decision Making with Spreadsheet Applications

Quantitative Decision Making with Spreadsheet Applications
Author: Lawrence L. Lapin
Publisher: South Western Educational Publishing
Total Pages: 858
Release: 2002
Genre: Business & Economics
ISBN:

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.

Essential Quantitative Methods

Essential Quantitative Methods
Author: Les Oakshott
Publisher: Bloomsbury Publishing
Total Pages: 457
Release: 2020-01-25
Genre: Business & Economics
ISBN: 1350305464

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.

Quantitative Analysis for Decision Makers, 7th Edition (Formally known as Quantitative Methods for Decision Makers)

Quantitative Analysis for Decision Makers, 7th Edition (Formally known as Quantitative Methods for Decision Makers)
Author: Mik Wisniewski
Publisher: Pearson UK
Total Pages: 955
Release: 2019-05-12
Genre: Business & Economics
ISBN: 1292276649

Were you looking for the book with access to MyLab Math Global? This product is the book alone and does NOT come with access to MyLab Math Global. Students, if MyLab Math Global is a recommended/mandatory component of the course, please ask your instructor for the correct ISBN and course ID. MyLab Math Global should only be purchased when required by an instructor. Instructors, contact your Pearson representative for more information. There's no doubt that a manager's job is getting tougher. Do it better, do it faster, do it cheaper are the pressures every manager faces. And at the heart of every manager's job is decision-making: deciding what to do and how to do it. This well-respected text looks at how quantitative analysis techniques can be used effectively to support such decision making. As a manager, developing a good understanding of the quantitative analysis techniques at your disposal is crucial. Knowing how, and when, to use them and what their results really mean can be the difference between making a good or bad decision and, ultimately, between business success and failure. Appealing both to students on introductory-level courses and to MBA and postgraduate students, this internationally successful text provides an accessible introduction to a subject area that students often find difficult. Quantitative Analysis for Decision Makers (formerly known as Quantitative Methods for Decision Makers) helps students to understand the relevance of quantitative methods of analysis to management decision-making by relating techniques directly to real-life business decisions in public and private sector organisations and focuses on developing appropriate skills and understanding of how the techniques fit into the wider management process. Key features: The use of real data sets to show how analytical techniques are used in practice “QADM in Action” case studies illustrating how organisations benefit from the use of analytical techniques Articles from the Financial Times illustrating the use of such techniques in a variety of business settings Fully worked examples and exercises supported by Excel data sets Student Progress Check activities in each chapter with solutions A 300+ page Tutors Solutions Manual

Exploring the Benefits of Creativity in Education, Media, and the Arts

Exploring the Benefits of Creativity in Education, Media, and the Arts
Author: Silton, Nava R.
Publisher: IGI Global
Total Pages: 483
Release: 2016-06-27
Genre: Psychology
ISBN: 1522505059

The use of imagination can lead to greater outcomes in problem solving, innovation, and critical thinking. By providing access to creative outlets, productivity increases in schools, businesses, and other professional settings. Exploring the Benefits of Creativity in Education, Media, and the Arts is a pivotal reference source for the latest scholarly research on the stimulation and implementation of creative thinking in academic and professional environments. Highlighting the foundations of creativity from theoretical and neuroscientific perspectives, this book is ideally designed for academics, professionals, educators, and practitioners.