Jove
Visualize
Contact Us
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Related Concept Videos

Performing a Simple Data Analysis using MS-Excel Function01:17

Performing a Simple Data Analysis using MS-Excel Function

940
Microsoft Excel offers a suite of functions and tools ideal for statistical analysis, making it accessible to students and researchers. This article outlines fundamental Excel functions pivotal for data analysis.
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...
940
Microsoft Excel: Regression Analysis01:18

Microsoft Excel: Regression Analysis

1.5K
Regression analysis in Microsoft Excel is a powerful statistical method for examining the relationship between a dependent variable and one or more independent variables. It's used extensively in fields such as economics, biology, and business to predict outcomes, understand relationships, and make data-driven decisions. The most common type is linear regression, which attempts to fit a straight line through the data points to model the relationship between variables.
To perform regression...
1.5K
Graphing the Wave Function01:13

Graphing the Wave Function

3.0K
Consider the wave equation for a sinusoidal wave moving in the positive x-direction. The wave equation is a function of both position and time. From the wave equation, two different graphs can be plotted.
3.0K
Overview of Microsoft Excel as a Data Analysis Tool01:13

Overview of Microsoft Excel as a Data Analysis Tool

1.5K
Microsoft Excel is a cornerstone tool for data analysis and statistical operations, offering a wide array of functionalities to manage, analyze, and visualize data efficiently. Recognized for its versatility, Excel facilitates the performance of basic to complex statistical operations, serving as an indispensable asset for analysts, researchers, and students alike. Excel's significance in data analysis emanates from its spreadsheet environment, where data can be organized in rows and...
1.5K
Microsoft Excel: Plotting Mean, SD, and SE01:18

Microsoft Excel: Plotting Mean, SD, and SE

1.2K
In Microsoft Excel, plotting the mean along with standard deviation (SD) and standard error (SE) helps visualize data variability and reliability. To plot these values, follow these steps:
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...
1.2K
Microsoft Excel: Student's t-Test01:25

Microsoft Excel: Student's t-Test

1.6K
Student's t-test in Microsoft Excel is a statistical method used to compare the means of two groups to determine if they are significantly different from each other. It's commonly used to evaluate hypotheses, such as testing whether a treatment has an effect compared to a control group. Excel provides built-in functions to perform t-tests, making it accessible for users needing to conduct basic statistical analysis.
To conduct a t-test in Excel, use the T.TEST function or the "Data...
1.6K

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by
Same journal

Peeling Back the Curtain: A Primer on the General Peer-Review and Publication Process in Behavior Analysis.

Behavior analysis in practice·2026
Same journal

Incorporating Qualitative Data when Training Behavior Analysts.

Behavior analysis in practice·2026
Same journal

Measurement of Emotions Tacting for Empathic Responding (METER): An Example of a Process for Creating an Inclusive Assessment of Emotion Recognition using Validated and Diverse Facial Expression Stimuli.

Behavior analysis in practice·2026
Same journal

Correction: Introduction to "Embracing Qualitative Research in Behavior Analysis: Lessons of Qualitative Research in/and Practice"-Part 2, Personal, Professional, and Pedagogical Perspectives.

Behavior analysis in practice·2026
Same journal

Conditioned Motivating Operations: Examples and Practical Considerations.

Behavior analysis in practice·2026
Same journal

Addressing Pervasive Myths About Qualitative Research to Promote Methodological Diversity in Applied Behavior Analysis.

Behavior analysis in practice·2026

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
14:17

The Portable Chemical Sterilizer PCS, D-FENS, and D-FEND ALL: Novel Chlorine Dioxide Decontamination Technologies for the Military

Published on: June 29, 2014

15.1K

Creating Functional Analysis Graphs Using Microsoft Excel® 2016 for PCs.

James T Chok1

  • 1Melmark Pennsylvania, 2600 Wayland Road, Berwyn, PA 19312 USA.

Behavior Analysis in Practice
|March 29, 2019
PubMed
Summary

Applied behavior analysis practitioners can simplify data graphing using Microsoft Excel. This tutorial details graphing functional analysis data, including reversal, latency, multieliment, and trial-based designs, to streamline assessment processes.

Keywords:
ExcelFunctional analysisGraphing

More Related Videos

In Vitro Analysis of E3 Ubiquitin Ligase Function
06:06

In Vitro Analysis of E3 Ubiquitin Ligase Function

Published on: May 14, 2021

6.0K
How to Create and Use Binocular Rivalry
14:34

How to Create and Use Binocular Rivalry

Published on: November 10, 2010

76.7K

Related Experiment Videos

Last Updated: Jan 27, 2026

The Portable Chemical Sterilizer PCS, D-FENS, and D-FEND ALL: Novel Chlorine Dioxide Decontamination Technologies for the Military
14:17

The Portable Chemical Sterilizer PCS, D-FENS, and D-FEND ALL: Novel Chlorine Dioxide Decontamination Technologies for the Military

Published on: June 29, 2014

15.1K
In Vitro Analysis of E3 Ubiquitin Ligase Function
06:06

In Vitro Analysis of E3 Ubiquitin Ligase Function

Published on: May 14, 2021

6.0K
How to Create and Use Binocular Rivalry
14:34

How to Create and Use Binocular Rivalry

Published on: November 10, 2010

76.7K

Area of Science:

  • Applied Behavior Analysis
  • Data Visualization
  • Behavioral Research Methods

Background:

  • Applied behavior analysis (ABA) practitioners utilize graphing software for data visualization during assessments.
  • Graphing procedures can be complex and subject to change with software updates, posing challenges for consistent data representation.
  • Accurate and efficient data graphing is crucial for effective behavioral intervention and analysis.

Purpose of the Study:

  • To provide a step-by-step tutorial for graphing functional analysis data using Microsoft Excel 2016 for PCs.
  • To offer clear instructions for visualizing various functional analysis data types, enhancing usability for ABA practitioners.
  • To address the need for a standardized and accessible method for data graphing in applied behavior analysis.

Main Methods:

  • Detailed instructions for creating graphs of functional analysis data in Microsoft Excel 2016.
  • Specific guidance on graphing reversal, latency, multieliment, and trial-based functional analysis data.
  • Focus on a user-friendly, PC-based approach to data visualization for applied behavior analysis.

Main Results:

  • Successful demonstration of creating functional analysis graphs using Microsoft Excel 2016.
  • Comprehensive instructions cover multiple functional analysis graph types.
  • The tutorial facilitates efficient and accurate data representation for ABA practitioners.

Conclusions:

  • Microsoft Excel 2016 offers a viable and accessible tool for graphing functional analysis data in applied behavior analysis.
  • This tutorial simplifies the graphing process, making data visualization more manageable for practitioners.
  • Standardized graphing procedures enhance the reliability and interpretability of behavioral assessment data.