Quantitative Business Methods Using Excel

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 and examples referred to in the text. The book therefore presents the reader with a hands-on approach to learning. 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 Methods modules - algebraic modelling, financial mathematics, organizational 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 on Excel. 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.Table of Content1. Introduction to Excel; 2. Principles of elementary modelling; 3. Business modelling using more advanced functions; 4. Equation solving and optimisation using the Excel Solver; 5. Financial mathematics; 6. Discounting techniques; 7. Matrix algebra; 8. Introductory Statistical Analysis; 9. Further descriptive statistical methods; 10. Simple Linear Regression; 11. Inferential statistics; 12. Multiple RegressionReview Quote"Very clear explanation of mathematical and statistical principles", Teye A Marra, University of Groningen "wide coverage, good step by step instructions", Colin Jex, Lancaster University