Statistics for Exercise Science and Health With Microsoft Office Excel - Excel

"This book presents readers with basic concepts of statistics in order to solve a variety of problems in exercise science and health. This book not only serves as a textbook for students, but its also provides a solid foundation for their future researchwork"--

List of contents

Preface xxi
 
1 Scope of Statistics in Exercise Science and Health 1
 
1.1 Introduction, 1
 
1.2 Understanding Statistics, 2
 
1.3 What Statistics Does?, 3
 
1.4 Statistical Processes, 4
 
1.5 Need for Statistics, 5
 
1.6 Statistics in Exercise Science and Health, 8
 
1.7 Computing with Excel, 9
 
2 Understanding the Nature of Data 19
 
2.1 Introduction, 19
 
2.2 Important Terminologies, 20
 
2.3 Measurement of Data, 22
 
2.4 Parametric and Nonparametric Statistics, 24
 
2.5 Frequency Distribution, 25
 
2.6 Summation Notation, 28
 
2.7 Measures of Central Tendency, 34
 
2.8 Comparison of the Mean, Median, and Mode, 46
 
2.9 Measures of Variability, 53
 
2.10 Standard Error, 72
 
2.11 Coefficient of Variation, 72
 
2.12 Absolute and Relative Variability, 74
 
2.13 Box-And-Whisker Plot, 79
 
2.14 Skewness, 81
 
2.15 Percentiles, 82
 
2.16 Computing with Excel, 86
 
3 Working with Graphs 101
 
3.1 Introduction, 101
 
3.2 Guidelines for Constructing a Graph, 102
 
3.3 Bar Diagram, 104
 
3.4 Histogram, 105
 
3.5 Frequency Polygon, 107
 
3.6 Frequency Curve, 107
 
3.7 Cumulative Frequency Curve, 108
 
3.8 Ogive, 110
 
3.9 Pie Diagram, 111
 
3.10 Stem and Leaf Plot, 113
 
3.11 Computing with Excel, 117
 
4 Probability and its Application 130
 
4.1 Introduction, 130
 
4.2 Application of Probability, 131
 
4.3 Set Theory, 132
 
4.4 Terminologies Used in Probability, 136
 
4.5 Basic Definitions of Probability, 142
 
4.6 Some Results on Probability, 145
 
4.7 Computing Probability, 145
 
4.8 Types of Probability, 151
 
4.9 Theorems of Probability, 152
 
4.10 Computing with Excel, 162
 
5 Statistical Distributions and their Application 176
 
5.1 Introduction, 176
 
5.2 Terminologies used in Statistical Distribution, 177
 
5.3 Discrete Distribution, 182
 
5.4 Binomial Distribution, 183
 
5.5 Poisson Distribution, 189
 
5.6 Continuous Distribution, 194
 
5.7 Normal Distribution, 195
 
5.8 Standard Score, 198
 
5.9 Normal Approximation to the Binomial Distribution, 199
 
5.10 Testing Normality of the Data, 200
 
5.11 The Central Limit Theorem, 204
 
5.12 Solving Problems Based on Normal Distribution, 204
 
5.13 Uses of Normal Distribution, 216
 
5.14 Computing with Excel, 217
 
6 Sampling and Sampling Distribution 234
 
6.1 Introduction, 234
 
6.2 Population and Sample, 235
 
6.3 Parameter and Statistics, 235
 
6.4 Sampling Frame, 236
 
6.5 Sampling, 236
 
6.6 Census, 238
 
6.7 Probability and Nonprobability Sampling, 238
 
6.8 Probability Sampling, 239
 
6.9 Nonprobability Sampling, 246
 
6.10 When to Use Probability Sampling, 249
 
6.11 When to Use Nonprobability Sampling, 250
 
6.12 Characteristics of a Good Sample, 250
 
6.13 Sources of Data, 251
 
6.14 Methods of Data Collection, 252
 
6.15 Biases in Data Collection, 254
 
6.16 Sampling Error, 255
 
6.17 Nonsampling Errors, 255
 
6.18 Sampling Distribution, 255
 
6.19 Criteria in Deciding Sample Size, 262
 
6.20 Computing with Excel, 266
 
7 Statistical Inference for Decision-Making in Exercise Science and Health 277
 
7.1 Introduction, 277
 
7.2 T

About the author

J. P. Verma, PhD, is Professor of Statistics and Director of the Center for Advanced Studies at Lakshmibai National Institute of Physical Education in Gwalior, India. Professor Verma is an active researcher in sports modeling and data analysis and has conducted many workshops on research methodology, research designs, multivariate analysis, statistical modeling, and data analysis for students of management, physical education, social science, and economics.

Summary

This book introduces the use of statistics to solve a variety of problems in exercise science and health and provides readers with a solid foundation for future research and data analysis.

Statistics for Exercise Science and Health with Microsoft Office Excel:
* Aids readers in analyzing their own data using the presented statistical techniques combined with Excel
* Features comprehensive coverage of hypothesis testing and regression models to facilitate modeling in sports science
* Utilizes Excel to enhance reader competency in data analysis and experimental designs
* Includes coverage of both binomial and poison distributions with applications in exercise science and health
* Provides solved examples and plentiful practice exercises throughout in addition to case studies to illustrate the discussed analytical techniques
* Contains all needed definitions and formulas to aid readers in understanding different statistical concepts and developing the needed skills to solve research problems

Product details

• Authors: Verma, Dr. J. P. Verma, Dr. J.p. Verma, J P Verma, J. P. Verma, Jp Verma
• Publisher: Wiley, John and Sons Ltd
• Languages: English
• Product format: Hardback
• Released: 08.08.2014
• EAN: 9781118855218
• ISBN: 978-1-118-85521-8
• No. of pages: 752
• Subject: Natural sciences, medicine, IT, technology > Medicine