Panneerselvam R. Business Statistics Using Excel. A Complete Course...2024

Textbook in PDF format

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
Introduction
Introduction to Excel
Average Functions
Median and Mode
Measures of Variation
Measures of Skewness
Probability Distributions
Sampling Distributions of Mean and Variance
Testing Hypotheses
Chi-Square Test
Nonparametric Tests
Correlation and Covariance
Forecasting
Analysis of Variance
Charts
Linear Programming
Annexures