Creating Functional Analysis Graphs Using Microsoft Excel® 2016 for PCs
- 279 Downloads
Practitioners in the field of applied behavior analysis rely on graphing software to display the data they collect during assessments. However, the graphing process can be cumbersome and procedures change as new versions of software programs are released. The current tutorial provides step-by-step instructions for graphing functional analysis data using Microsoft Excel 2016 for PCs. Instructions for creating functional analysis data depicted in reversal, latency, mulitielment, and trial-based functional analysis are provided.
KeywordsGraphing Functional analysis Excel
Compliance with Ethical Standards
Conflict of Interest
This author declares that he has no conflict of interest.
This article does not contain any studies with human or animal participants performed by the author.
- Carr, J. E., & Burkholder, E. O. (1998). Creating single-subject design graphs with Microsoft Excel™. Journal of Applied Behavior Analysis, 31, 245–251.Google Scholar
- Deochand, N. (2017). Automating phase change lines and their labels using Microsoft Excel®. Behavior Analysis in Practice, 10, 279–284.Google Scholar
- Deochand, N., Costello, M. S., & Fuqua, R. W. (2015). Phase-change lines, scale breaks, and trend lines using Excel 2013. Journal of Applied Behavior Analysis, 48, 478–493.Google Scholar
- Dixon, M. R., Jackson, J. W., Small, S. L., Horner-King, M. J., Mui Ker Lik, N., Garcia, Y., & Rosales, R. (2009). Creating single-subject design graphs in Microsoft Excel™ 2007. Journal of Applied Behavior Analysis, 42, 277–293.Google Scholar
- Dubuque, E. M. (2015). Inserting phase change lines into Microsoft Excel® graphs. Behavior Analysis in Practice, 8, 207–211.Google Scholar
- Vanselow, N. R., & Bourret, J. C. (2012). Online interactive tutorials for creating graphs with Excel 2007 or 2010. Behavior Analysis in Practice, 5(1), 40–46.Google Scholar