Related Experiment Video
Updated: Jan 27, 2026

The Portable Chemical Sterilizer PCS, D-FENS, and D-FEND ALL: Novel Chlorine Dioxide Decontamination Technologies for the Military
Published on: June 29, 2014
Creating Functional Analysis Graphs Using Microsoft Excel® 2016 for PCs
1Melmark Pennsylvania, 2600 Wayland Road, Berwyn, PA 19312 USA.
Abstract:
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.
Related Concept Videos
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...
Microsoft Excel: Regression Analysis
To perform regression...
Graphing the Wave Function
Overview of Microsoft Excel as a Data Analysis Tool
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: Student's t-Test
To conduct a t-test in Excel, use the T.TEST function or the "Data...

