Skip to main content
SpringerLink
Log in

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

  • Technical and Tutorials
  • Published:
Behavior Analysis in Practice Aims and scope Submit manuscript

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9
Fig. 10
Fig. 11
Fig. 12
Fig. 13
Fig. 14
Fig. 15
Fig. 16
Fig. 17
Fig. 18
Fig. 19
Fig. 20
Fig. 21
Fig. 22
Fig. 23

Similar content being viewed by others

References

  • Baer, D. M., Wolf, M. M., & Risley, T. R. (1968). Some current dimensions of applied behavior analysis. Journal of Applied Behavior Analysis, 1(1), 91–97. https://doi.org/10.1901/jaba.1968.1-91.

  • Carr, J. E., & Burkholder, E. O. (1998). Creating single-subject design graphs with Microsoft Excel®. Journal of Applied Behavior Analysis, 31(2), 245–251. https://doi.org/10.1901/jaba.1998.31-245.

  • Chok, J. T. (2019). Creating functional analysis graphs using Microsoft Excel® for PCs. Behavior Analysis in Practice, 12(1), 265–292. https://doi.org/10.1007/s40617-018-0258-4.

  • Coon, J. C., & Rapp, J. T. (2018). Application of multiple baseline designs in behavior analytic research: Evidence for the influence of new guidelines. Behavioral Interventions, 33(2), 160–172. https://doi.org/10.1002/bin.1510.

  • Cooper, J. O., Heron, T. E., & Heward, W. L. (2020). Applied behavior analysis (3rd ed.). Pearson.

    Book  Google Scholar 

  • Deochand, N. (2017). Automating phase change lines and their labels using Microsoft Excel®. Behavior Analysis in Practice, 10(3), 279–284. https://doi.org/10.1007/s40617-016-0169-1.

  • 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(2), 478–493. https://doi.org/10.1002/jaba.198.

  • 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 with Microsoft Excel® 2007. Journal of Applied Behavior Analysis, 42(2), 277–293. https://doi.org/10.1901/jaba.2009.42-277.

  • Dubuque, E. M. (2015). Inserting phase change lines into Microsoft Excel® graphs. Behavior Analysis in Practice, 8(2), 207–211. https://doi.org/10.1007/s40617-015-0078-8.

  • Fuller, T. C., & Dubuque, E. M. (2019). Integrating phase change lines and labels into graphs in Microsoft Excel®. Behavior Analysis in Practice, 12(1), 293–299. https://doi.org/10.1007/s40617-018-0248-6.

  • Hammond, D., & Gast, D. L. (2010). Descriptive analysis of single subject research designs: 1983–2007. Education and Training in Autism and Developmental Disabilities, 45(2), 187–202 https://www.jstor.org/stable/23879806.

  • Kubina, R. M., Kostewicz, D. E., Brennan, K. M., & King, S. A. (2017). A critical review of line graphs in behavior analytic journals. Educational Psychology Review, 29(3), 583–598. https://doi.org/10.1007/s10648-015-9339-x.

  • Smith, J. D. (2012). Single-case experimental designs: A systematic review of published research and current standards. Psychological Methods, 17(4), 1–70. https://doi.org/10.1037/a0029312.

Download references

Acknowledgements

This study was completed in partial fulfillment of the requirements of a master of science degree in applied behavior analysis by Zoey B. Watts. The authors would like to thank Katharine Roberts for her assistance with this project.

Author information

Authors and Affiliations

  1. Autism Spectrum Therapies, Beaverton, OR, USA

    Zoey B. Watts

  2. Department of Psychology, Arizona State University, Tempe, AZ, USA

    Zoey B. Watts & Donald M. Stenhoff

Authors
  1. Zoey B. Watts
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Donald M. Stenhoff
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Donald M. Stenhoff.

Ethics declarations

The authors declare that no relevant conflicts of interest influenced the nature of the present discussion and review article.

Additional information

Publisher’s Note

Springer Nature remains neutral with regard to jurisdictional claims in published maps and institutional affiliations.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Watts, Z.B., Stenhoff, D.M. Creating Multiple-Baseline Graphs With Phase Change Lines in Microsoft Excel for Windows and macOS. Behav Analysis Practice 14, 996–1009 (2021). https://doi.org/10.1007/s40617-021-00552-0

Download citation

  • Accepted:

  • Published:

  • Issue Date:

  • DOI: https://doi.org/10.1007/s40617-021-00552-0

Keywords

Search

Navigation