Phase-change Lines, Scale Breaks, and Trend Lines Using Excel 2013
Overview
Affiliations
The development of graphing skills for behavior analysts is an ongoing process. Specialized graphing software is often expensive, is not widely disseminated, and may require specific training. Dixon et al. (2009) provided an updated task analysis for graph making in the widely used platform Excel 2007. Vanselow and Bourret (2012) provided online tutorials that outline some alternate methods also using Office 2007. This article serves as an update to those task analyses and includes some alternative and underutilized methods in Excel 2013. To examine the utility of our recommendations, 12 psychology graduate students were presented with the task analyses, and the experimenters evaluated their performance and noted feedback. The task analyses were rated favorably.
Creating Multiple-Baseline Graphs With Phase Change Lines in Microsoft Excel for Windows and macOS.
Watts Z, Stenhoff D Behav Anal Pract. 2021; 14(4):996-1009.
PMID: 34868813 PMC: 8586303. DOI: 10.1007/s40617-021-00552-0.
Toward the Development of a Functional Analysis Risk Assessment Decision Tool.
Deochand N, Eldridge R, Peterson S Behav Anal Pract. 2020; 13(4):978-990.
PMID: 33269209 PMC: 7666254. DOI: 10.1007/s40617-020-00433-y.
Creating Functional Analysis Graphs Using Microsoft Excel® 2016 for PCs.
Chok J Behav Anal Pract. 2019; 12(1):265-292.
PMID: 30918793 PMC: 6411563. DOI: 10.1007/s40617-018-0258-4.
Using Microsoft Excel® to Build a Customized Partial-Interval Data Collection System.
Morris C, Deochand N, Peterson S Behav Anal Pract. 2018; 11(4):504-516.
PMID: 30538926 PMC: 6269379. DOI: 10.1007/s40617-018-0259-3.
Mitteer D, Greer B, Fisher W, Cohrs V J Appl Behav Anal. 2018; 51(4):998-1010.
PMID: 29971776 PMC: 6188791. DOI: 10.1002/jaba.483.