Creating Multiple-Baseline Graphs With Phase Change Lines in Microsoft Excel for Windows and macOS
Zoey B Watts1,2, Donald M Stenhoff2
1Autism Spectrum Therapies, Beaverton, OR USA.
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.
More Related Videos
Related Concept Videos
Graphical and Analytic Representation of Sinusoids
The first step is measuring the peak-to-peak value, which is twice the amplitude of the sinusoid. This provides information about the maximum voltage swing of the waveform.
Secondly, the period and angular frequency are determined. The period is the time taken for one complete cycle of the waveform, while...
Microsoft Excel: Plotting Mean, SD, and SE
First, calculate the mean, SD, and SE of your data. The mean is obtained using the formula `=AVERAGE(range)`, while SD can be calculated with `=STDEV.P(range)` for a population or `=STDEV.S(range)` for a sample. SE is calculated as `=SD/SQRT(n)`, where `n` is the sample size.
To plot these values, use a bar...
Microsoft Excel: Regression Analysis
To perform regression...
Overview of Microsoft Excel as a Data Analysis Tool
Time-Series Graph
Performing a Simple Data Analysis using MS-Excel Function
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...


