A comprehensive and engaging textbook that presents the fundamentals of statistical analysis using Excel and its application in business.
For beginners, both statistics and Excel can be intimidating topics to grasp. This textbook promises to be an easy solution that offers an introduction to the use of Excel in business statistics. The author provides step-by-step instructions on how to use Excel, beginning from the very basics and leading up to solving complicated statistical problems. Filled with screenshots illustrating each step, this book provides detailed explanations on how to use the different statistical functions that Excel offers and their application in the world of business.
It shows readers how Excel is an invaluable tool in a manager's toolbox and how it can be used for effective and efficient decision-making. Business Statistics Using Excel would be a valuable companion for both students and practising managers who want to improve their skills in data analytics.
Key Features:
* Contains more than 100 solved examples to explain key statistical problems
* Exhaustive coverage of current syllabi of business statistics of major institutes and universities
* Includes supplementary resources on advance topics such as statistics using R
* Extensive review exercises at the end of each chapter to ensure maximum retention
Sprache
Verlagsort
Zielgruppe
Für höhere Schule und Studium
Maße
Höhe: 241 mm
Breite: 184 mm
Gewicht
ISBN-13
978-93-5479-156-7 (9789354791567)
Copyright in bibliographic data and cover images is held by Nielsen Book Services Limited or by the publishers or by their respective licensors: all rights reserved.
Schweitzer Klassifikation
R. Panneerselvam was a Faculty, Department of Management Studies, School of Management, Pondicherry University. He holds BE (Mechanical Engineering), ME (Industrial Engineering) and PhD (Industrial Engineering) degrees from Anna University. He served as a faculty in the Department of Industrial Engineering at Anna University for about seven years and then joined Pondicherry University in 1987, totalling about 40 years of teaching and research. He served as the head of the Department of Management Studies for three spells and dean of the School of Management, Pondicherry University. He specializes in operations, quantitative techniques and systems. Under his research supervision, more than 13 students have been awarded a doctoral degree in management. He has published more than 100 research articles in leading national and international journals. His h-index is 17 and i10-index is 24. Dr Panneerselvam has published 15 textbooks with two leading publishers. He carried out an overseas consultancy for CEMS, Malaysia. He received several awards, including the Best Selling Author Award from PHI Learning, the Achiever Award 2016 from Anna University for its alumnus and the Best Teacher Award from Pondicherry University.
Glossary
Preface
Introduction
Introduction to Excel
Count, Frequency and Histogram
Average Functions
Median and Mode
Measures of Variation
Measures of Skewness
Probability Distributions
Sampling Distribution of Mean and Variance
Testing of Hypothesis
Chi-square Test
Nonparametric Test
Correlation and Covariance
Forecasting
Analysis of Variance (ANOVA)
Charts
Linear Programming
Index
