A Spreadsheet Approach to Business Quantitative Methods
A Spreadsheet Approach to Business Quantitative Methods

 

For more complete information see the Table of Contents

 

This book is intended for students who have completed an introductory course in statistics.

Part I  of the book provides some introductory material for those with a need to revise the fundamentals. Chapter 2 attempts to introduce key features of the Excel spreadsheet which are applied throughout the book. While several chapters rely on matrix algebra, most of the material may be covered with a rudimentary treatment of this topic. The chapters dealing with multivariate analysis rely extensively on matrix algebra, hence a more formal treatment is required for these areas.

Part II   of the book provides an opportunity to revisit some introductory concepts in statistics and develop a more rigorous foundation for a better appreciation of most of the material covered in later chapters. Fundamentals of probability, probability distributions and hypothesis testing provide an important basis for many of the later chapters, particularly regression and multivariate analysis.

Part III   introduces the regression analysis and time series models. The models discussed here provide an approach or methodology for modelling business data and each of the models are illustrated using apropriate examples. A spreadsheet approach to model building and estimation is used to combine theory and application.

Part IV   Principal Components and Factor Analysis are presented using MINITAB.

Part V   includes many of the traditional and modern approaches used in quantitative decision making.

Exercises at the end of each chapter are designed to complement the material and provide a richer appreciation for the techniques. Each chapter contains additional references, from both introductory and advanced texts where possible.

Please send us your comments Feedback


Quant methods... Home page