This text provides a comprehensive introduction to quantitative methods for business students. The text employs Excel 5.0 as a tool to assist the student to understand and use quantitative methods to solve business problems. Designed to be read in front of the computer screen, this book introduces the student to topics in Quantitative Methods. Each chapter contains an illustrated set of exercises and solutions summarising the topics covered, and the book is accompanied by a disk containing further exercises andexamples referred to in the text. The book therefore presents the reader with a far more lively, active and hands-on approach to learning than that of a standard textbook. The text commences with an introduction to the functions, commands and routines contained in the Excel 5.0 spreadsheet. These are explained in the context of everyday business problems. Thereafter, these Excel techniques are applied to the topics that constitute undergraduate Quantitative Methodsmodules - algebraic modelling, financial mathematics, organisational methods, descriptive statistics, inferential statistics and regression. Throughout the discussion the distinction between quantitative theory and Excel techniques is marked in the text. Computer instructions are highlighted throughout. This provides a fast-track route for those readers who are familiar with quantitative methods but not with how to apply them onExcel. The book is tailored towards a readership of 1st or 2nd year students of Quantitative Methods (or maths and statistics) on Business, Management and Accountancy courses. It would also be appropriate for use on MBA, management or accountancy diploma courses.

You don’t need to be a mathematician to be able to use statistics effectively…Lots of business students worry that quantitative methods is all about mathematics and statistics, capable of being utilized by a chosen few. Quantitative Methods for Business Research Using Microsoft Excel is here to show you that all students can use quantitative methods successfully as part of research.This book and its online resources approach quantitative methods with the assumption that applying the powerful statistical tools available in Excel doesn’t require any special competence in mathematics or statistics. It’s all about knowing which tools to use and how to use them, not what makes them work (the mathematicians did that behind the scenes and we all thank them).This book aims to promote two things: the conviction that quants is well within your capabilities; and an enduring interest in the subject that will carry you on beyond the ambition and scope of this work.

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

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.

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.

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.

Takes the challenging and makes it understandable. The book contains useful advice on the application of statistics to a variety of contexts and shows how statistics can be used by managers in their work.′ - Dr Terri Byers, Assistant Professor, University Of New Brunswick, Canada A book about introductory quantitative analysis, the authors show both how and why quantitative analysis is useful in the context of business and management studies, encouraging readers to not only memorise the content but to apply learning to typical problems. Fully up-to-date with comprehensive coverage of IBM SPSS and Microsoft Excel software, the tailored examples illustrate how the programmes can be used, and include step-by-step figures and tables throughout. A range of ‘real world’ and fictional examples, including "The Ballad of Eddie the Easily Distracted" and "Esha′s Story" help bring the study of statistics alive. A number of in-text boxouts can be found throughout the book aimed at readers at varying levels of study and understanding Back to Basics for those struggling to understand, explain concepts in the most basic way possible - often relating to interesting or humorous examples Above and Beyond for those racing ahead and who want to be introduced to more interesting or advanced concepts that are a little bit outside of what they may need to know Think it over get students to stop, engage and reflect upon the different connections between topics A range of online resources including a set of data files and templates for the reader following in-text examples, downloadable worksheets and instructor materials, answers to in-text exercises and video content compliment the book. An ideal resource for undergraduates taking introductory statistics for business, or for anyone daunted by the prospect of tackling quantitative analysis for the first time.

As we enter the 21st century, most students are familiar with microcomputers. They are adept in visually-oriented playing and learning, as evidenced by prevalent video games, music videos, and DVD movies. This book appeals to the modern day undergraduate and graduate students by using microcomputers, through innovative uses of spreadsheets and built-in spreadsheets equations and formulae. This microcomputer skill-intensive book covers major topics in both economic analysis and business analysis. Students will learn how to build complex spreadsheet layouts and perform high-level calculations and analysis intuitively in a non-threatening environment. To encourage students' active learning and critical thinking, they will be given hands-on practice by creating tables and graphs presented in the text and homework, and by changing the parameters to find the effects of the change instantly. At the same time, by acquainting themselves with the popular spreadsheet program, they will acquire more advanced job skills directly.

Full of practical advice and real-world examples, this step-by-step guide offers you an accessible introduction to doing quantitative social research using Microsoft Excel.

This book covers a comprehensive range of topics in quantitative methods for business students. The opening chapters introduce basic statistical concepts which are used in later chapters in business and management applications. It also includes applications, examples and exercises in SPSS, Lotus and Excel.