Business Statistics Using Excel: A Complete Course in Data Analytics

PANNEERSELVAM, R.

Reference

Routledge India

This book gives readers a 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 implementing data analytics for effective decision making in all kinds of business situations around the world. With an emphasis on simplicity in presentation of concepts of statistical methods and associated Excel functions, the volume explores the implementation of Excel functions through well-defined sequences of steps. It covers an array of key topics which include<ul> <li>Discussions on real-world problems, decision support systems, scope of business statistics, types, and steps of research;</li> <li>Introduction to Excel and its mathematical and preliminary statistical functions; usage of different types of average functions; mean, median, and mode functions; measures of variation; measures of skewness of Excel;</li> <li>In-depth discussions on probability distributions, sampling distributions, testing of hypothesis, chi-square test, non-parametric tests of Excel;</li> <li>Extensive coverage on correlation and covariance, forecasting, analysis of variance, charts in Excel; and</li> <li>Analysis of the concept of linear programming, problem formulations, and techniques of linear programming, followed by the application in Excel.</li> </ul>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, and computer science. This will also serve as useful guidebook for business executives and working professionals across the globe.

Business Statistics Using Excel

Operations Research, 2/E

Computers & Technology

Computer Science

Phi Learning Private Limited

Provides the students of management and engineering with the techniques in production and operations management, in order to maximize productivity and profitability in business.

Production and Operations Management

Business & Money

Management & Leadership

Prentice-Hall of India Pvt.Ltd

This comprehensive text designed for MBA, MCom, MA (Economics), MA (Sociology) and PhD (Management, Commerce, Economics, and Engineering) courses continues to give complete account of concepts and statistical tools of research methodology in its Second Edition. The textbook also serves as a reference for consultants to carryout projects/consultancies in industries or service organizations.  DISTINGUISHING FEATURES OF THE BOOK* Written in an easy to read style *  Each technique is illustrated with sufficient number of numerical examples * Gives complete account of statistics and aspects of research methodology * Chapter 8 gives complete account of testing of hypotheses * Design and analysis of experiments, advanced multivariate analysis, multidimensional scaling and conjoint analysis, algorithmic research, models for industries and public systems, simulation are unique to this text.  * Graded chapter-end questions NEW TO THIS EDITION  Introduction of a chapter on SPSS (Chapter 17), is new to this edition which gives readers an idea to obtain statistics for different techniques presented in this text. The different screenshots for different modules of SPSS applied to suitable example problems on sample session for data creation, reports, descriptive statistics, tables, compare means, general linear model, correlation, simple regression, nonparametric tests, classify, data reduction and graphs help readers to understand the features of SPSS.

RESEARCH METHODOLOGY

Economics

Phi Learning'

A comprehensive and engaging textbook that presents the fundamentals of statistical analysis using Excel and its application in business.\nFor 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.\nIt 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.\nKey Features:\n• Contains more than 100 solved examples to explain key statistical problems\n• Exhaustive coverage of current syllabi of business statistics of major institutes and universities\n• Includes supplementary resources on advance topics such as statistics using R\n• Extensive review exercises at the end of each chapter to ensure maximum retention

Science & Math

Mathematics

SAGE Publications Pvt. Ltd

The exponential growth of companies in different industries necessitates a sound database and associated computer language for efficient and effective handling of information requirements to take decisions. In this direction, there are several database languages. The emergence of Python programming language fulfills such requirement to manage data stored in databases more effectively. 
Based on the feedback received from the learned academic colleagues and students, and also the dynamic changes in the field, I thought it is proper to come out with a book on ‘Python programming for Databases: MySQL, MongoDB, Object Oriented Programming (OOP) and tkinter’ 
This text would be handy in meeting the requirements of business organizations, because Python Programming has three in one feature, viz. high-level language feature, database feature and graphic feature. 
This text begins with introduction, which includes need for database, types of decisions and information system, conventional file processing system and database system. The Chapter 2 on database concepts and models presents data and information, metadata, terminologies of file, schema vs subschema, associations between the fields of file, associations between files, one-to-one association between files, data models and entity-relationship model. 
It is followed by a chapter on database design, which includes, Top-Down Approach, Bottom-Up Approach and a case study as per bottom-up approach, which uses normalization. 
The Chapter 4 on Python MySQL presents Creation of Database, Creation of Table in Python MySQL, Inserting Records in Table ‘Student’ in Python MySQl, Select Command in MysQL Python, Select …. From ….. Where In MySQL, Adding Field in a Table, Adding Data to New Fields of Table Using Update Command, Select ….. From Order By Query, Delete From ……. Where …… Command, Drop Table Name of Table Command, Limit, and Limit with Offset Commands, Case study for Limit .. and Limit with Offset Commands, and Join Command. It is followed by a chapter on PYTHON MongoDb, which presents Types of NoSQL Database, Installation, Creation of Database and Collection, Adding First Documet/ Record and Print, Inserting a Set of Documents and Printing Their IDS, Printing Content of Employees Collection, Query to Fetch Fields of Documents Satisfying a Condition, Sorting, Sort Documents of Collection Based on Key and Printing Select Fields, Delete Document(S) of Collection , Drop Collection, Update and Limit() Command. 
The Chapter 6 presents Python Object Oriented Programming (OOP), which includes python classes and objects, constructors in python, python destructor, python inheritance, encapsulation, class / static variable and class method and static method. The last chapterb 7 presents tkinter, which includes Tkinter Programming and Tkinter Widgets. 
This text is written in easy-to-read style. Each and every chapter contains numerous example programs and in select chapters fitting case studies are presented.

Databases and Python Programming: MySQL, MongoDB, OOP and Tkinter

Education & Teaching

Schools & Teaching

10838|ISBN|2022|A

Advanced Database Management Systems Including Python Matplotlib for Data Mining

13398|ISBN|2022|A

See the best price to sell, buy, or rent books by PANNEERSELVAM, R.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by PANNEERSELVAM, R.