QUANTITATIVE METHODS FOR BUSINESS: USING MS EXCEL 2016

Looking for a way to bring Quantitative Methods in Business to life? Get marketable Quantitative Analytical skills in this course using Microsoft Excel 2016.


The text is aimed at business and accounting students who already possess previous knowledge of quantitative methods whereby the text serves as a reminder, students who desire to acquire a short and quick introduction into quantitative methods and students intending to use quantitative methods for their research projects will find profitable information in this material. Business and accounting students who possess no knowledge of quantitative methods will also find this material helpful.

This book has also been written withmanagers in mind who may need a quick refresher on how to complete Quantitative analysisWhat you will learn from this book:

•Concepts and theories of quantitative methods
•Step by step guideline on applying various quantitative techniques in business
•Step by step guideline on applying various quantitative techniques in business
•Practical application of the quantitative methods
•Use of Ms Excel 2016 for quantitative analysis

The book comprises of 18 chapters organised into two parts.The infographic summaryof the first part ends first section. The first part deals mainly with quantitative methods, whereby the main terms are concisely highlighted and an example supplied. In the second part, areas where quantitative techniques can be applied in accountingis discussed and a brief case study is rendered.

The first part contains application of concepts in Ms Excel 2016. The goal of the decision to use excel to show calculation and further analysis possibility of data,is to make students aware of the means to use Excel for quantitative analysis. The adaptation of Ms Excel 2016 is based on the assumption that students are already acquainted with Ms Excel 2016. Therefore, how to use Excel on its own is not included in this book. If the reader wishes to build and develop the practical knowledge of using Ms Excel 2016 in business, refer to our further books in the series on Ms Excel 2016:

Ms Excel 2016 Basic to Intermediate
Ms Excel 2016 Advanced to Expert
Ms Excel 2016 for Accountants Volumes (I, II, III)

We have included the use of Excel for quantitative analysis to limited chapters of the book since the concept behind it is to provide a basic knowledge of the use of Ms Excel 2016 for quantitative analysis and deliver a basic introduction.
The text is written in a concise-form. Students will find this approach time-saving in learning a particular concept. Each chapter has an accompanying multiple choice question to test the comprehension of the student and allow the student know the level that needs more in depth study.

We recognise that most readers may have studied quantitative techniques before, and we have therefore tried to write in a concise and accessible style. We tried then to delve into the concept immediately avoiding thereby a gradual introduction. Nevertheless, we aim to satisfy those who may not have studied quantitative methods before by minimising the use of technical jargon. Where technical terminology is unavoidable we try to provide clear explanations. Key concepts appear at the beginning of the chapters so that students can be aware of needs to be thoroughly understood.