Data analysis for strength and conditioning coaches: using Excel to analyze reliability, differences, and relationships

Statistical analysis is crucial to the role of strength and conditioning, and coaches should be able to identify whether their data are reliable and objectively determine differences and relationships. These analytical skills are central to our ability of uncovering trends and associations, making predictions and assessing the efficacy of training programs. This article reviews statistical tests available through Microsoft Excel, covering reliability (through the coefficient of variation), the smallest worthwhile change (i.e., the first meaningful difference in scores), effect sizes (i.e., the magnitude of change between performance scores), and relationships (i.e., correlations