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

Turner, Anthony N. ORCID: https://orcid.org/0000-0002-5121-432X, Brazier, Jon, Bishop, Chris ORCID: https://orcid.org/0000-0002-1505-1287, Chavda, Shyam ORCID: https://orcid.org/0000-0001-7745-122X, Cree, Jon ORCID: https://orcid.org/0000-0002-7738-0203 and Read, Paul (2015) Data analysis for strength and conditioning coaches: using Excel to analyze reliability, differences, and relationships. Strength & Conditioning Journal, 37 (1) . pp. 76-83. ISSN 1524-1602 [Article] (doi:10.1519/SSC.0000000000000113)

Abstract

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)

Actions (login required)

View Item

Statistics

DownloadsShow export options

Export as CSVXMLJSON

Activity Overview

6 month trend

1Download

6 month trend

1,149Hits

Additional statistics are available via IRStats2.