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

Overview of Microsoft Excel as a Data Analysis Tool01:13

Overview of Microsoft Excel as a Data Analysis Tool

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 columns,...
Performing a Simple Data Analysis using MS-Excel Function01:17

Performing a Simple Data Analysis using MS-Excel Function

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...
Microsoft Excel: Regression Analysis01:18

Microsoft Excel: Regression Analysis

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...
Microsoft Excel: Student's t-Test01:25

Microsoft Excel: Student's t-Test

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 Analysis...
Microsoft Excel: Pearson's Correlation01:18

Microsoft Excel: Pearson's Correlation

Microsoft Excel is a powerful tool for statistical analysis, including calculating Pearson's correlation coefficient, which measures the strength and direction of a linear relationship between two continuous variables. Pearson's correlation coefficient, often denoted as "r," ranges from -1 to 1. A value close to 1 indicates a strong positive correlation, meaning as one variable increases, the other does too. A value close to -1 indicates a strong negative correlation, implying that as one...
Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis01:24

Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis

Central tendency refers to the central point or typical value of a dataset. It summarizes the data set with a single value that represents the center of its distribution. The three main measures of central tendency are:
Mean: The arithmetic average of all data points. It is calculated by adding all the values together and dividing by the number of values. The mean is sensitive to extreme values (outliers).
Median: The middle value when the data points are arranged in ascending or descending...

You might also read

Related Articles

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

Sort by
Same author

Twenty-five years of simulated demand: A bibliometric and systematic review of hypothetical drug purchase tasks.

Journal of the experimental analysis of behavior·2026
Same author

Risk identification strategies for health pandemics and epidemics on college campuses: A comprehensive analysis of heat maps and behavioral observations.

PloS one·2026
Same author

The Effect of Price on the Behavioural Economic Substitutability of Non-Alcoholic and Alcoholic Beverages.

Drug and alcohol review·2026
Same author

Preclinical abuse potential testing using behavioral economics and drug self-administration demand-curve analysis: A strategy to improve resolution of drug stratification for regulatory control.

Pharmacological reviews·2026
Same author

An Analysis of Variables Contributing to Board Certified Behavior Analyst<sup>®</sup> Turnover.

Behavior analysis in practice·2026
Same author

Evaluating contributions of progressive ratio analysis to economic metrics of demand.

Journal of the experimental analysis of behavior·2025
Same journal

Latency and persistence of renewal in an intensive outpatient clinic.

Journal of applied behavior analysis·2026
Same journal

The effect of varied versus constant high-probability instructional sequences on cooperation.

Journal of applied behavior analysis·2026
Same journal

Relations between heart rate and precursors: A replication and extension of prior research.

Journal of applied behavior analysis·2026
Same journal

Integrating five linear trend techniques into performance-criteria-based effect size measurements: Impressions and recommendations.

Journal of applied behavior analysis·2026
Same journal

Functional analysis and treatment of higher level restricted repetitive behavior displayed by individuals with autism.

Journal of applied behavior analysis·2026
Same journal

Contingency drives children's vocal behavior.

Journal of applied behavior analysis·2026
See all related articles

Related Experiment Video

Updated: Jun 12, 2026

Using Cholesky Decomposition to Explore Individual Differences in Longitudinal Relations between Reading Skills
06:52

Using Cholesky Decomposition to Explore Individual Differences in Longitudinal Relations between Reading Skills

Published on: September 17, 2019

Using Microsoft Office Excel 2007 to conduct generalized matching analyses.

Derek D Reed1

  • 1Melmark New England, Andover, Massachusetts 01810, USA. dreed@melmarkne.org

Journal of Applied Behavior Analysis
|June 2, 2010
PubMed
Summary
This summary is machine-generated.

This study provides a simple task analysis for using Microsoft Excel to apply the generalized matching equation. It aims to help behavior analysts evaluate reinforcement and behavior relationships in applied settings.

Keywords:
Microsoft Excelchoicegeneralized matching equationmatching lawtechnology

More Related Videos

The Terroir Concept Interpreted through Grape Berry Metabolomics and Transcriptomics
13:02

The Terroir Concept Interpreted through Grape Berry Metabolomics and Transcriptomics

Published on: October 5, 2016

Selecting Multiple Biomarker Subsets with Similarly Effective Binary Classification Performances
07:35

Selecting Multiple Biomarker Subsets with Similarly Effective Binary Classification Performances

Published on: October 11, 2018

Related Experiment Videos

Last Updated: Jun 12, 2026

Using Cholesky Decomposition to Explore Individual Differences in Longitudinal Relations between Reading Skills
06:52

Using Cholesky Decomposition to Explore Individual Differences in Longitudinal Relations between Reading Skills

Published on: September 17, 2019

The Terroir Concept Interpreted through Grape Berry Metabolomics and Transcriptomics
13:02

The Terroir Concept Interpreted through Grape Berry Metabolomics and Transcriptomics

Published on: October 5, 2016

Selecting Multiple Biomarker Subsets with Similarly Effective Binary Classification Performances
07:35

Selecting Multiple Biomarker Subsets with Similarly Effective Binary Classification Performances

Published on: October 11, 2018

Area of Science:

  • Behavioral science
  • Quantitative psychology

Background:

  • The generalized matching equation is a key tool for analyzing behavior-reinforcement relationships.
  • A lack of accessible task analysis hinders its application in clinical and applied settings.

Purpose of the Study:

  • To present a step-by-step task analysis for using Microsoft Excel to analyze and plot the generalized matching equation.
  • To facilitate the use of quantitative analyses for researchers with limited experience.

Main Methods:

  • Development of a task analysis for Microsoft Excel.
  • Inclusion of a data-based case example.
  • Step-by-step instructions for analysis and plotting.

Main Results:

  • A clear, accessible method for applying the generalized matching equation using Excel.
  • Demonstration of quantitative analysis with a practical example.

Conclusions:

  • The provided task analysis promotes the use of the generalized matching equation in applied behavior analysis.
  • Researchers can more readily evaluate behavior-reinforcement relationships using this Excel-based method.