- 648 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
About this book
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
- Discussions on real-world problems, decision support systems, scope of business statistics, types, and steps of research;
- 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;
- In-depth discussions on probability distributions, sampling distributions, testing of hypothesis, chi-square test, non-parametric tests of Excel;
- Extensive coverage on correlation and covariance, forecasting, analysis of variance, charts in Excel; and
- Analysis of the concept of linear programming, problem formulations, and techniques of linear programming, followed by the application in Excel.
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.
Frequently asked questions
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Information
Table of contents
- Cover
- Half Title
- Title
- Copyright
- Dedication
- Contents
- List of Figures
- List of Tables
- Glossary
- 1 Introduction
- 2 Introduction to Excel
- 3 Count, Frequency, and Histogram Functions
- 4 Average Functions
- 5 Median and Mode
- 6 Measures of Variation
- 7 Measures of Skewness
- 8 Probability Distributions
- 9 Sampling Distributions of Mean and Variance
- 10 Testing Hypotheses
- 11 Chi-Square Test
- 12 Nonparametric Tests
- 13 Correlation and Covariance
- 14 Forecasting
- 15 Analysis of Variance
- 16 Charts
- 17 Linear Programming
- Annexures
- Index