Update cookies preferences

Business Statistics Using Excel [Paperback / softback]

  • Format: Paperback / softback, 724 pages, height x width: 241x184 mm, weight: 1270 g
  • Pub. Date: 15-May-2022
  • Publisher: SAGE Publications India Pvt Ltd
  • ISBN-10: 9354791565
  • ISBN-13: 9789354791567
Other books in subject:
  • Paperback / softback
  • Price: 43,30 €
  • This book is not in stock. Book will arrive in about 2-4 weeks. Please allow another 2 weeks for shipping outside Estonia.
  • Quantity:
  • Add to basket
  • Delivery time 4-6 weeks
  • Add to Wishlist
Business Statistics Using ExcelLarger Image
  • Format: Paperback / softback, 724 pages, height x width: 241x184 mm, weight: 1270 g
  • Pub. Date: 15-May-2022
  • Publisher: SAGE Publications India Pvt Ltd
  • ISBN-10: 9354791565
  • ISBN-13: 9789354791567
Other books in subject:
Permanent link: https://www.kriso.ee/db/9789354791567.html
Keywords:
"A comprehensive and engaging textbook that presents the fundamentals of statistical analysis using Excel and its application in business. Business Statistics Using Excel is an invaluable companion to a business student beginning to use Excel for statistical analysis as well as a reader more experienced with the program. The author provides step-by-step instruction on how to use Excel, beginning from the very basics leading up to solving complicated statistical problems. Filled with screenshots illustrating every step as well as multiple solved examples, this book provides detailed explanations on how to use the different statistical functions that Excel offers and their applications in the world of business. It shows the reader how Excel is an invaluable tool in a manager's toolbox and how it can be used effectively and efficiently. Key Features: Shows how to solve problems step-by-step using screenshots and explanations. Gives detailed explanations of statistical concepts and their function in Excel. Contains multiple solved examples for each type of problem that facilitate easy understanding of the core concepts. Extensive review exercises are included to ensure maximum retention"--

A comprehensive and engaging textbook that presents the fundamentals of statistical analysis using Excel and its application in business.

For 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. 

It 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.  

Key Features:

• Contains more than 100 solved examples to explain key statistical problems

• Exhaustive coverage of current syllabi of business statistics of major institutes and universities
 
• Includes supplementary resources on advance topics such as statistics using R

• Extensive review exercises at the end of each chapter to ensure maximum retention

A comprehensive and engaging textbook that presents the fundamentals of statistical analysis using Excel and its application in business.
List of Figures xv
List of Tables xxxvii
Preface xliii
About the Author xlv
Chapter 1 Introduction 1(18)
1.1 Real-world Problems
1(1)
1.2 Decision Support System
2(2)
1.3 Business Statistics
4(1)
1.4 Types of Research
4(5)
1.5 Steps of Research
9(4)
1.6 Statistical Techniques
13 (6)
Chapter 2 Introduction to Excel 19(51)
2.1 Introduction
19(1)
2.2 Excel
20 (50)
Chapter 3 COUNT, FREQUENCY and Histogram Functions 70(31)
3.1 Introduction
70(1)
3.2 COUNT Functions
71(15)
3.3 FREQUENCY Function
86(5)
3.4 Histogram
91 (10)
Chapter 4 AVERAGE Functions 101(41)
4.1 Introduction
101(1)
4.2 AVERAGE Function
101(7)
4.3 AVEDEV Function
108(8)
4.4 AVERAGEA Function
116(5)
4.5 AVERAGEIF Function
121(5)
4.6 AVERAGEIFS Function
126 (16)
Chapter 5 Median and Mode 142(32)
5.1 Introduction
142(1)
5.2 Median
143(6)
5.3 Mode
149(11)
5.4 Percentile
160(4)
5.5 Quartile
164 (10)
Chapter 6 Measures of Variation 174(43)
6.1 Introduction
174(1)
6.2 Range Using Excel Sheet
175(1)
6.3 Quartile Deviation
176(6)
6.4 Average Deviation Using an Excel Sheet
182(5)
6.5 Standard Deviation
187(16)
6.6 Variance of Ungrouped Data
203(4)
6.7 Coefficient of Variation Using an Excel Sheet
207 (10)
Chapter 7 Measures of Skewness 217(26)
7.1 Introduction
217(1)
7.2 Karl Pearson's Coefficient of Skewness Using Excel Sheet
218(8)
7.3 Bowley's Coefficient of Skewness Using Excel Sheet
226(3)
7.4 Kurtosis
229 (14)
Chapter 8 Probability Distributions 243(39)
8.1 Introduction
243(1)
8.2 Binomial Distribution Using the BINOM.DIST Function
244(6)
8.3 Poisson Distribution Using the POISSON.DIST Function
250(2)
8.4 Exponential Distribution Using the EXPON.DIST Function
252(3)
8.5 Normal Distribution Using NORM.DIST, NORM.INV, NORM.S.DIST and NORM.S.INV Functions
255(9)
8.6 Uniform Distribution Using an Excel Sheet
264(2)
8.7 t-distribution (Sampling Distribution of Mean When Normal Population Variance Is Unknown) Using T.DIST, T.DIST.2T, T.DIST.RT, T.INV and T.INV.2T Functions
266(3)
8.8 Confidence Interval When Sample Size Is Large
269(3)
8.9 Confidence Interval When Sample Size Is Small
272 (10)
Chapter 9 Sampling Distributions of Mean and Variance 282(33)
9.1 Introduction
282(1)
9.2 Sampling Distributions of Mean
283(15)
9.3 Sampling Distributions of Variance
298 (17)
Chapter 10 Testing of Hypothesis 315(45)
10.1 Introduction
315(1)
10.2 Tests Concerning Single Mean When Mean and Variance of the Populations Are Known and the Size of the Population Is Finite Using the NORM.S.DIST Function
316(7)
10.3 Tests Concerning Differences between Two Means When the Variances of the Populations Are Known and the Sample Sizes Are Large Using the Z-test: Two Sample for Means, T.DIST, T.DIST.RT and T.DIST.2T Functions
323(5)
10.4 Tests Concerning Single Mean When the Variance of the Population Is Unknown and the Sample Size Is Small Using T.DIST, T.DIST.RT and T.DIST.2T Functions
328(6)
10.5 Tests Concerning Differences between Two Means When the Variances of the Population Are Unknown and the Sample Size Is Small Using t-test: Two Sample, Assuming Equal Variance
334(9)
10.6 Tests Concerning Differences between Two Means When the Variances of the Population Are Unknown and the Sample Size Is Small Using t-test: Two Sample, Assuming Unequal Variance
343(2)
10.7 Paired t-test Using t-test: Paired Two Sample for Means Function
345 (15)
Chapter 11 Chi-square Test 360(20)
11.1 Introduction
360(1)
11.2 Chi-square Test for Checking Independence of Categorized Data Using Excel Sheet and CHISQ.DIST.RT Function
361(3)
11.3 Goodness of Fit Test Using Excel Sheet and CHISQ.DIST.RT Function
364 (16)
Chapter 12 Nonparametric Tests 380(68)
12.1 Introduction
381(1)
12.2 One-Sample Sign Tests
381(11)
12.3 Kolmogorov-Smirnov Test Using Excel Sheet
392(4)
12.4 Run Test for Randomness
396(3)
12.5 Two-Sample Tests
399(18)
12.6 Median Test Using Excel Sheet, COUNTIF, COMBIN and CHISQ.DIST.RT Functions
417(5)
12.7 Mann-Whitney U Test Using Excel Sheet and NORM.S.DIST Function
422(4)
12.8 K-Sample Tests
426 (22)
Chapter 13 Correlation and Covariance 448(35)
13.1 Introduction
448(1)
13.2 Correlation
448(1)
13.3 Correlation Coefficient of Ungrouped Data Using Excel Sheet and the CORREL Function
449(10)
13.4 Correlation Coefficient of Grouped Data Using Excel Sheet
459(3)
13.5 Rank Correlation Using Excel Sheet and the T.DIST.RT Function
462(4)
13.6 Autocorrelation Using Excel Sheet
466(4)
13.7 Covariance Using the COVARIANCE.P/COVARIANCE.S Function
470 (13)
Chapter 14 Forecasting 483(36)
14.1 Introduction
483(1)
14.2 Methods of Forecasting
484(1)
14.3 Linear Regression
484(1)
14.4 Linear Regression Using the Excel Regression Function
485(5)
14.5 Moving Average Method Using the Moving Average Function in Excel
490(3)
14.6 Exponential Smoothing Method of Forecasting Using Excel Sheet as Well as Exponential Smoothing Function
493(3)
14.7 Multiple Linear Regression Using the Excel Regression Function
496(6)
14.8 Time Series Analysis Using an Excel Sheet and the Regression Function
502 (17)
Chapter 15 Analysis of Variance (ANOVA) 519(45)
15.1 Introduction
519(5)
15.2 ANOVA with Single Factor (Completely Randomized Design) Using ANOVA: Single-Factor Function
524(9)
15.3 Randomized Complete Block Design Using ANOVA: Two Factor without Replication Function
533(7)
15.4 Latin Square Design Using Excel Sheet
540(6)
15.5 Complete Factorial Experiment with Two Factors Using ANOVA: Two Factor with Replication Function
546(7)
15.6 Yates' Algorithm for 2n Factorial Experiment Using Excel Sheet and F.DIST.RT Function
553 (11)
Chapter 16 Charts 564(25)
16.1 Introduction
564(1)
16.2 Pie Chart
565(4)
16.3 Bar (Column) Chart
569(3)
16.4 Multi-bar (Column) Chart
572(3)
16.5 Stacked Bar Chart
575(3)
16.6 Line Chart
578(3)
16.7 Multiple Line Chart
581 (8)
Chapter 17 Linear Programming 589
17.1 Introduction
589(1)
17.2 Assumptions of Linear Programming
590(1)
17.3 Components of Linear Programming Model
590(2)
17.4 Examples of Mathematical Models
592(11)
17.5 Graphical Method for Linear Programming
603(7)
17.6 Simplex Method
610(6)
17.7 Big M Method for Linear Programming
616(3)
17.8 Dual Simplex Method
619(3)
17.9 Sensitivity Analysis
622(8)
17.10 Solving Linear Programming Problem Using Excel
630
Glossary G-1
Annexures A-1
Index I-
R. Panneerselvam was a Faculty, Department of Management Studies, School of Management, Pondicherry University. He holds BE (Mechanical Engineering), ME (Industrial Engineering) and PhD (Industrial Engineering) degrees from Anna University. He served as a faculty in the Department of Industrial Engineering at Anna University for about seven years and then joined Pondicherry University in 1987, totalling about 40 years of teaching and research. He served as the head of the Department of Management Studies for three spells and dean of the School of Management, Pondicherry University. He specializes in operations, quantitative techniques and systems. Under his research supervision, more than 13 students have been awarded a doctoral degree in management. He has published more than 100 research articles in leading national and international journals. His h-index is 17 and i10-index is 24. Dr Panneerselvam has published 15 textbooks with two leading publishers. He carried out an overseas consultancy for CEMS, Malaysia. He received several awards, including the Best Selling Author Award from PHI Learning, the Achiever Award 2016 from Anna University for its alumnus and the Best Teacher Award from Pondicherry University.