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

Microsoft Excel: Regression Analysis01:18

Microsoft Excel: Regression Analysis

1.8K
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.8K
Microsoft Excel: Median, Quartile range, and Box Plots01:29

Microsoft Excel: Median, Quartile range, and Box Plots

4.2K
In Microsoft Excel, calculating the median, interquartile range, and creating box plots can help understand the distribution of your data.
Median and Quartile Range: The median is calculated using the formula `=MEDIAN(range)', which provides the middle value of your data set. Quartiles divide your data into four equal parts. To find the first and third quartiles, use ‘=QUARTILE(range, 1)' and ‘=QUARTILE(range, 3)', respectively. The interquartile range (IQR), which...
4.2K
Microsoft Excel: Plotting Mean, SD, and SE01:18

Microsoft Excel: Plotting Mean, SD, and SE

1.6K
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.6K
Increasing Function01:18

Increasing Function

478
An increasing function exhibits a rise in output values as input values increase. This behavior is depicted graphically as a curve or line that slopes upward from left to right. Such a function satisfies the condition that if x1 < x2, then f(x1) < f(x2), indicating that the function values grow with increasing inputs. This concept is fundamental in understanding growth trends across various domains, such as population dynamics, financial investments, or resource consumption.The...
478
Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis01:24

Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis

865
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...
865
Types of Limits II01:24

Types of Limits II

268
When observing how a curve behaves near a specific point along the horizontal axis, there are cases where the curve’s height increases or decreases without limit as the position draws closer to that point. The curve does not settle at any particular value; instead, the values grow more extreme—upward or downward—the nearer they get. No defined value exists exactly at that location, yet the surrounding behavior becomes more dramatic, indicating a sharp change in direction.The...
268

You might also read

Related Articles

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

Sort by
Same author

The Development of a Behavior Plan Quality Assurance Instrument in a Publicly Funded System of Care.

Behavior analysis in practice·2025
Same author

Henry S. Pennypacker's Contributions to Breast Cancer Detection: Developing a Behavioral Technology to Improve Breast Self-Exam Skills.

Perspectives on behavior science·2025
Same author

Assessing Growth of BACB Certificants (1999-2019).

Perspectives on behavior science·2024
Same author

Building a Social Justice Framework for Cultural and Linguistic Diversity in ABA.

Behavior analysis in practice·2022
Same author

Quantification of behavioral data with effect sizes and statistical significance tests.

Journal of applied behavior analysis·2022
Same author

Reconsideration of the type I error rate for psychological science in the era of replication.

Psychological methods·2022
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: Apr 14, 2026

Author Spotlight: Unveiling Plankton Response to Climate Change Through Time-Series Data and Artistic Expression
08:15

Author Spotlight: Unveiling Plankton Response to Climate Change Through Time-Series Data and Artistic Expression

Published on: July 28, 2023

2.0K

Phase-change lines, scale breaks, and trend lines using Excel 2013.

Neil Deochand1, Mack S Costello1, R Wayne Fuqua1

  • 1Western Michigan University.

Journal of Applied Behavior Analysis
|April 29, 2015
PubMed
Summary
This summary is machine-generated.

This study updates graphing techniques in Microsoft Excel 2013 for behavior analysts, offering accessible methods for creating behavior graphs. Graduate students found the updated task analyses helpful for improving graphing skills.

Keywords:
Excel 2013graphphase changeraising zero above abscissascale breaksingle-subject design

More Related Videos

A Method of Trigonometric Modelling of Seasonal Variation Demonstrated with Multiple Sclerosis Relapse Data
10:46

A Method of Trigonometric Modelling of Seasonal Variation Demonstrated with Multiple Sclerosis Relapse Data

Published on: December 9, 2015

11.2K
Polar Histogram Visualization of Acute Stress Disorder Scale Scores for Comprehensive Clinical Assessment
08:25

Polar Histogram Visualization of Acute Stress Disorder Scale Scores for Comprehensive Clinical Assessment

Published on: December 6, 2024

1.4K

Related Experiment Videos

Last Updated: Apr 14, 2026

Author Spotlight: Unveiling Plankton Response to Climate Change Through Time-Series Data and Artistic Expression
08:15

Author Spotlight: Unveiling Plankton Response to Climate Change Through Time-Series Data and Artistic Expression

Published on: July 28, 2023

2.0K
A Method of Trigonometric Modelling of Seasonal Variation Demonstrated with Multiple Sclerosis Relapse Data
10:46

A Method of Trigonometric Modelling of Seasonal Variation Demonstrated with Multiple Sclerosis Relapse Data

Published on: December 9, 2015

11.2K
Polar Histogram Visualization of Acute Stress Disorder Scale Scores for Comprehensive Clinical Assessment
08:25

Polar Histogram Visualization of Acute Stress Disorder Scale Scores for Comprehensive Clinical Assessment

Published on: December 6, 2024

1.4K

Area of Science:

  • Behavior Analysis
  • Data Visualization
  • Educational Technology

Background:

  • Graphing is essential for behavior analysts, but specialized software can be costly and inaccessible.
  • Previous task analyses for graphing in Excel 2007 exist but require updating for newer versions.
  • Accessible tools like Microsoft Excel are underutilized for creating behavior graphs.

Purpose of the Study:

  • To provide an updated task analysis for creating behavior graphs using Microsoft Excel 2013.
  • To introduce alternative and underutilized methods within Excel 2013 for graphing.
  • To evaluate the utility and user reception of the updated graphing task analyses.

Main Methods:

  • Developed updated task analyses for graphing in Microsoft Excel 2013.
  • Piloted the task analyses with 12 psychology graduate students.
  • Collected performance data and qualitative feedback from student participants.

Main Results:

  • The updated task analyses were presented to psychology graduate students.
  • Experimenters evaluated student performance and gathered feedback on the task analyses.
  • Participants rated the updated task analyses favorably, indicating their utility.

Conclusions:

  • The updated Excel 2013 task analyses are effective for teaching graphing skills to behavior analysts.
  • Accessible software like Excel can be leveraged for robust data visualization in behavior analysis.
  • Further dissemination of these methods can improve graphing practices in the field.