Description
Book SynopsisThis 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
Table 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
