Creating Functional Analysis Graphs Using Microsoft Excel® 2016 for PCs

A concise review of recent advancements in the graphical training of behavior analysts

This Concise Review is an appraisal of contemporary research on teaching single-case experimental design (SCED) graphical creation published between 2017-2021. Recent work on SCED graphical creation is summarized and areas for future research are highlighted.

Creating Multiple-Baseline Graphs With Phase Change Lines in Microsoft Excel for Windows and macOS

Although Excel 2016 may be the most common graphing software, it is often confusing to use effectively. In the field of applied behavior analysis, graphs are crucial for analyzing data and sharing results. Multiple-baseline design graphs are one of the most popular graphs used by behavior analysts, but they often fall short of meeting established quality standards. This tutorial extends prior tutorials to provide detailed instructions on how to create a multiple-baseline design graph that not only meets quality standards but also includes phase change lines built into the graph and an acceptable x/y-axis ratio. This tutorial is applicable for both Windows and macOS platforms.

Remote teaching of publication-quality, single-case graphs in Microsoft Excel

Microsoft Excel is ubiquitous, cost-effective, and can be used to create publication-quality single-case design graphs. We systematically replicated the GraphPad Prism video tutorial by Mitteer et al. (2018) to teach 24 master's students to create multiple-baseline graphs using Excel 2016. Students' mean accuracy on the multiple-baseline graph was 25% in pretraining, 86% with the video tutorial, and 96% with the review checklist. Next, students used the same video tutorial to create multielement and reversal graphs. Students' mean accuracy on the multielement graph was 93% with video tutorial and 94% with review checklist, and accuracy on the reversal graph was 82% with video tutorial and 94% with review checklist. Students reported moderate to high satisfaction with both training components. The results support scientist-practitioners using the video tutorial and review checklists to create three common graphs using Excel 2016, Excel 2019, and Excel Office 365.