Business Statistics Using Excel - A Complete Course in Data Analytics

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.

List of contents

1. Introduction 2. Introduction to Excel 3. Count, Frequency and Histogram 4. Average Functions 5. Median and Mode 6. Measures of Variation 7. Measures Of Skewness 8. Probability Distributions 9. Sampling Distribution of Mean and Variance 10. Testing Of Hypothesis 11. Chi-Square Test 12. Nonparametric Test 13. Correlation and Covariance 14. Forecasting 15. Analysis of Variance (Anova) 16. Charts 17. Linear Programming

About the author

R. Panneerselvam has more than 40 years of teaching and research experience and served as faculty at Anna University, India, for seven years and then served at Pondicherry University, for 34 years. He has been Head of Department of Management Studies three times and Dean of the School of Management, Pondicherry University. He specialises 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 13 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, Malaysia, and has received several accolades.

Summary

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.

Product details

• Authors: R. Panneerselvam, Panneerselvam R.
• Publisher: Taylor & Francis Ltd.
• Languages: English
• Product format: Paperback / Softback
• Released: 22.12.2023
• EAN: 9781032671710
• ISBN: 978-1-0-3267171-0
• No. of pages: 648
• Subjects: Social sciences, law, business > Media, communication > Communication science; Excel, BUSINESS & ECONOMICS / Decision-Making & Problem Solving, MATHEMATICS / Probability & Statistics / General, BUSINESS & ECONOMICS / Business Mathematics, Management decision making, Probability & statistics, Business mathematics & systems, Probability and statistics, COMPUTERS / Data Science / Data Visualization, Business mathematics and systems, COMPUTERS / Database Administration & Management, Data capture and analysis, Data Capture & Analysis, Spreadsheet software, COMPUTERS / Business & Productivity Software / Spreadsheets, Business Statistics;Data Analysis;Data Analytics