Business Statistics Using Excel

This book gives readers hands-on understanding of Excel assisted statistical techniques to take effective business decisions. It showcases applications of the tools and techniques of statistics for analysing business data from the domain of business statistics.The volume provides an exhaustive introduction to the application of statistics in solving business problems and implement data analytics for effective decision making in all kinds of business situations around the world. With an emphasis for simplicity in presentation of concepts of statistical methods and associated Excel functions, the volume explores the implementation of Excel functions through well-defined sequence of steps. It covers an array of key topics which includes,- Discussions on real world problems, decision support systems, scope of business statistics, types, and steps of research;- Introduction to excel and its mathematical and preliminary statistical functions, usage of different types of average function, mean, median and mode functions, measures of variation, measures of skewness of Excel;- In depth discussions on probability distributions, sampling distributions, testing of hypothesis, chi-square test, non-parametric test of Excel;- Extensive coverage on correlation and covariance, forecasting, Analysis of Variance, charts of Excel, and- Analysis of concept of linear programming, problem formulations, and techniques of linear programming, followed by the application of Excel.Comprehensive in scope and simple in approach, this book will be key for students and researchers of business studies, business administration, economics, finance, commerce, data analytics/ science, computer science. This will also serve as useful guidebook for business executives and working professionals across the globe.

R. Panneerselvam has more than 40 years of teaching and research experience, served as a faculty of Anna University, India, for seven years and then served Pondicherry University, totalling. He has been Head of Department of Management studies for three times and Dean of the School of Management, Pondicherry University. Specializes in Operations, Quantitative Techniques, and Computer Systems. He holds B.E.(Mech.), M.E. and Ph. D degrees in Industrial Engineering from Anna University and has guided thirteen doctoral students in management. Dr Panneerselvam has published more than 100 research articles in leading national and international journals, along with 21 textbooks. He has carried out an overseas consultancy for CEMS, Malesia and has received several accolades.