
Business Statistics Using Excel
R. Panneerselvam(Author)
SAGE Publications India Pvt Ltd (Publisher)
1st Edition
Published on 15. May 2022
Book
Paperback/Softback
724 pages
978-93-5479-156-7 (ISBN)
Description
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
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
More details
Language
English
Place of publication
New Delhi
India
Target group
College/higher education
Dimensions
Height: 241 mm
Width: 184 mm
Weight
1272 gr
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 Classification
Person
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.
Content
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
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