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: Median, Quartile range, and Box Plots01:29

Microsoft Excel: Median, Quartile range, and Box Plots

3.9K
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...
3.9K
Overview of Microsoft Excel as a Data Analysis Tool01:13

Overview of Microsoft Excel as a Data Analysis Tool

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

Microsoft Excel: Regression Analysis

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

Performing a Simple Data Analysis using MS-Excel Function

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

Microsoft Excel: Student's t-Test

1.9K
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.9K
Purpose of Health Records II01:19

Purpose of Health Records II

1.5K
Health records serve various essential purposes in the healthcare system. Here are some key purposes:
1.5K

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

Related Experiment Video

Updated: Mar 15, 2026

Using Continuous Data Tracking Technology to Study Exercise Adherence in Pulmonary Rehabilitation
09:42

Using Continuous Data Tracking Technology to Study Exercise Adherence in Pulmonary Rehabilitation

Published on: November 8, 2013

14.1K

Recording an Excel(®) Macro to Specify Date Ranges for Clinical Data.

Neil Deochand1, Mack S Costello2, R Wayne Fuqua1

  • 1Department of Psychology, Western Michigan University, 3700 Wood Hall, Kalamazoo, MI 49008 USA.

Behavior Analysis in Practice
|September 14, 2016
PubMed
Summary

Behavior analysts can now automate progress note generation for Medicaid and insurance-funded clients. This task analysis streamlines graphical data display, saving valuable indirect service time.

Keywords:
Clinical dataExcel®GraphingMacroProgress notesSingle-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
Inverse Probability of Treatment Weighting Propensity Score using the Military Health System Data Repository and National Death Index
06:55

Inverse Probability of Treatment Weighting Propensity Score using the Military Health System Data Repository and National Death Index

Published on: January 8, 2020

15.4K

Related Experiment Videos

Last Updated: Mar 15, 2026

Using Continuous Data Tracking Technology to Study Exercise Adherence in Pulmonary Rehabilitation
09:42

Using Continuous Data Tracking Technology to Study Exercise Adherence in Pulmonary Rehabilitation

Published on: November 8, 2013

14.1K
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
Inverse Probability of Treatment Weighting Propensity Score using the Military Health System Data Repository and National Death Index
06:55

Inverse Probability of Treatment Weighting Propensity Score using the Military Health System Data Repository and National Death Index

Published on: January 8, 2020

15.4K

Area of Science:

  • Behavioral analysis and applied behavior analysis (ABA)
  • Healthcare administration and billing
  • Data visualization and reporting

Background:

  • Behavior analysts serve clients funded by Medicaid, insurance, or private pay.
  • Medicaid and insurance require detailed progress notes, including graphical data displays.
  • Creating these reports in tools like Microsoft Excel is time-consuming.

Purpose of the Study:

  • To outline a task analysis for automating progress note generation.
  • To reduce the time spent on indirect service hours for behavior analysts.
  • To improve the efficiency of reporting behavioral outcomes.

Main Methods:

  • Development of a task analysis to automate the creation of progress notes.
  • Focus on graphical displays of behavioral data for monthly, quarterly, and annual reports.
  • Utilizing accessible tools such as Microsoft Excel for implementation.

Main Results:

  • The proposed task analysis aims to significantly reduce the time required for report generation.
  • Automation of graphical data presentation is key to efficiency gains.
  • Expected reduction in indirect service hours dedicated to administrative tasks.

Conclusions:

  • Automating progress note generation can free up behavior analysts' time for direct client services.
  • Task analysis offers a practical solution for improving efficiency in ABA service delivery.
  • Streamlined reporting benefits both providers and clients by ensuring timely and accurate data representation.