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

Area of Science:

• Applied Behavior Analysis
• Data Visualization

Background:

• Excel 2016 graphing is widely used but often difficult for effective data analysis.
• High-quality graphs are essential in applied behavior analysis for data interpretation and dissemination.
• Multiple-baseline design graphs are common but frequently do not meet quality standards.

Purpose of the Study:

• To provide detailed instructions for creating high-quality multiple-baseline design graphs using Excel.
• To ensure graphs meet established quality standards for applied behavior analysis.
• To incorporate phase change lines and acceptable x/y-axis ratios into graph creation.

Main Methods:

• Step-by-step tutorial for Excel graph creation.
• Focus on incorporating phase change lines.
• Guidance on achieving acceptable x/y-axis ratios.

Main Results:

• Demonstration of creating a multiple-baseline design graph that adheres to quality standards.
• Successful integration of phase change lines within the graph.
• Achieving an acceptable x/y-axis ratio for clarity and accuracy.

Conclusions:

• This tutorial enhances the ability of behavior analysts to create publication-ready graphs.
• Effective graphing in Excel improves data analysis and communication in applied behavior analysis.
• The tutorial is applicable to both Windows and macOS users.