CDF-XL: computing cumulative distribution functions of reaction time data in Excel

Area of Science:

• Experimental Psychology
• Cognitive Psychology
• Psychometrics

Background:

• Traditional analysis of reaction time (RT) distributions in experimental psychology focuses on central tendencies, overlooking valuable information within the distribution's shape.
• Cumulative distribution frequency (CDF) plots offer a more comprehensive analysis of RT distributions, but their complex implementation in standard software limits their widespread use.
• A need exists for accessible tools that enable researchers, including students, to utilize advanced RT distribution analysis techniques.

Purpose of the Study:

• To introduce CDF-XL, a user-friendly, Excel-based program designed for constructing and analyzing cumulative distribution frequency (CDF) plots of reaction time data.
• To make advanced RT distribution analysis techniques, specifically CDF analysis, more accessible to a broader research community.
• To provide a practical tool for researchers to gain deeper insights from RT distributions beyond simple central tendency measures.

Main Methods:

• CDF-XL is an Excel workbook that accepts raw experimental data organized into Subject, Condition, and Reaction Time (RT) columns.
• The program requires no further data preprocessing or sorting, featuring a utility for data formatting.
• Upon a single click, CDF-XL generates two types of cumulative analyses: standard CDFs based on participant RT percentiles and an analysis using participant means of rank-ordered RT bins.

Main Results:

• CDF-XL produces results in three formats: participant-level data for further statistical analysis, grand means by condition, and complete CDF plots within Excel charts.
• The program facilitates the comparison of experimental conditions by providing detailed insights into the entire RT distribution, not just its central tendency.
• Both standard CDFs and the RT bin analysis offer complementary perspectives on RT distribution patterns.

Conclusions:

• CDF-XL significantly lowers the barrier to entry for utilizing cumulative distribution frequency analysis in reaction time research.
• The accessibility of CDF-XL empowers researchers and students to conduct more sophisticated analyses of RT data, leading to potentially richer scientific findings.
• This tool promotes a more thorough understanding of cognitive processes by leveraging the full information contained within reaction time distributions.