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.4K
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.4K
Standard Deviation01:10

Standard Deviation

28.1K
The most commonly used measure of variation is the standard deviation. It is a numerical value measuring how far data values are from their mean. The standard deviation value is small when the data are concentrated close to the mean, exhibiting slight variation or spread. The standard deviation value is never negative, it is either positive or zero. The standard deviation is larger when the data values are more spread out from the mean, which means the data values are exhibiting more variation.
28.1K
Variation: Normal Distribution, Range, and Standard Deviation02:32

Variation: Normal Distribution, Range, and Standard Deviation

28.7K
In the field of psychology, there are several ways to organize measurements of a trait, feature, or characteristic (i.e., variables). Qualitative data, such as ethnicity, can be tabulated into a frequency count to provide information about the proportion, as well as the variety of groups in a sample or population. On the other hand, researchers can perform a wider set of calculations on quantitative data. The mean, mode, and median, for instance, are central tendency measures to identify a...
28.7K
Calculating Standard Deviation01:08

Calculating Standard Deviation

13.3K
The standard deviation is the most common measure of variation. It is a value that tells us how far a data value is from the mean value in a dataset. Further, the standard deviation is always a positive value or zero.
The standard deviation value is small when all the data is concentrated close to the mean. Here the data exhibits low variation. The standard deviation value is larger when the data values are more spread out from the mean. Here, the data displays high...
13.3K
Standard Deviation of Calculated Results01:14

Standard Deviation of Calculated Results

8.7K
Standard deviation measures the spread of data around the mean value. Many large data sets follow a Gaussian distribution, also known as a normal distribution. This distribution is bell-shaped curved, with the most frequently observed value (mean or central value) in the middle. The farther away from the central value, the greater the deviation from the central value, and the lower the frequency.
A broad Gaussian distribution curve has a wider standard deviation, representing a data set with...
8.7K
Estimating Population Standard Deviation01:26

Estimating Population Standard Deviation

3.4K
When the population standard deviation is unknown and the sample size is large, the sample standard deviation s is commonly used as a point estimate of σ. However, it can sometimes under or overestimate the population standard deviation. To overcome this drawback, confidence intervals are determined to estimate population parameters and eliminate any calculation bias accurately. However, this only applies to random samples from normally distributed populations. Knowing the sample mean and...
3.4K

You might also read

Related Articles

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

Sort by
Same author

Rectal shedding of SARS-CoV-2 in patients with negative COVID-19 nasopharyngeal RT-PCR test.

The International journal of risk & safety in medicine·2025
Same author

Sex Ratio at Birth in Northern Ireland During the COVID-19 Pandemic: A Comparison With Published Data From the Republic of Ireland, England and Wales.

American journal of human biology : the official journal of the Human Biology Council·2025
Same author

Forecasting with Excel.

Acta medica (Hradec Kralove)·2025
Same author

The Impact of the COVID-19 Pandemic on the Sex Ratio at Birth in Ireland.

American journal of human biology : the official journal of the Human Biology Council·2024
Same author

Two World Wars and Belgium: Missing Births and Birth Sex Ratio Changes.

Acta medica (Hradec Kralove)·2024
Same author

Sporting tournaments and changed birth rates 9 months later: a systematic review.

PeerJ·2024
Same journal

Corrigendum to "2D:4D ratio, affective lability, and impulsivity in men with cannabinoid and methamphetamine use disorders: A comparative analysis with healthy controls" [Early Hum. Dev. Volume 221:106587(2026)].

Early human development·2026
Same journal

Risk factors associated with the development of metabolic bone disease in infants admitted to the pediatric intensive care unit.

Early human development·2026
Same journal

Association of cardiac perfusion index with cerebral regional oxygen saturation and fractional tissue oxygen extraction in preterm infants.

Early human development·2026
Same journal

Long-term motor outcomes after parent-administered early physiotherapy in children born very preterm.

Early human development·2026
Same journal

Second-to-fourth digit ratio in polycythemia vera: An exploratory anthropometric comparison with secondary polycythemia and healthy controls.

Early human development·2026
Same journal

Infants who crawl while skin-to-skin in the first hour after birth are more likely to effectively breastfeed postpartum.

Early human development·2026
See all related articles

Related Experiment Video

Updated: Feb 14, 2026

Evaluation of the Productivity of Social Wasp Colonies Vespinae and an Introduction to the Traditional Japanese Vespula Wasp Hunting Technique
07:17

Evaluation of the Productivity of Social Wasp Colonies Vespinae and an Introduction to the Traditional Japanese Vespula Wasp Hunting Technique

Published on: September 11, 2019

8.8K

WASP (Write a Scientific Paper) using Excel -5: Quartiles and standard deviation.

Victor Grech1

  • 1Academic Department of Paediatrics, Mater Dei Hospital, Malta.

Early Human Development
|February 28, 2018
PubMed
Summary
This summary is machine-generated.

This guide explains how to calculate descriptive statistics like standard deviation and quartiles in Microsoft Excel. Learn essential data analysis techniques for your research.

Keywords:
BiostatisticsComputers, statisticsSoftware

More Related Videos

Author Spotlight: Optimizing the Rearing Procedure of Germ-Free Wasps
05:39

Author Spotlight: Optimizing the Rearing Procedure of Germ-Free Wasps

Published on: July 21, 2023

2.9K
An Introduction to Parasitic Wasps of Drosophila and the Antiparasite Immune Response
13:04

An Introduction to Parasitic Wasps of Drosophila and the Antiparasite Immune Response

Published on: May 7, 2012

19.2K

Related Experiment Videos

Last Updated: Feb 14, 2026

Evaluation of the Productivity of Social Wasp Colonies Vespinae and an Introduction to the Traditional Japanese Vespula Wasp Hunting Technique
07:17

Evaluation of the Productivity of Social Wasp Colonies Vespinae and an Introduction to the Traditional Japanese Vespula Wasp Hunting Technique

Published on: September 11, 2019

8.8K
Author Spotlight: Optimizing the Rearing Procedure of Germ-Free Wasps
05:39

Author Spotlight: Optimizing the Rearing Procedure of Germ-Free Wasps

Published on: July 21, 2023

2.9K
An Introduction to Parasitic Wasps of Drosophila and the Antiparasite Immune Response
13:04

An Introduction to Parasitic Wasps of Drosophila and the Antiparasite Immune Response

Published on: May 7, 2012

19.2K

Area of Science:

  • Data Analysis
  • Statistical Methods
  • Quantitative Research

Background:

  • Descriptive statistics are crucial for summarizing data post-collection.
  • Standard deviation and quartiles are fundamental statistical descriptors.
  • Researchers often need efficient tools for basic statistical analysis.

Purpose of the Study:

  • To provide practical guidance on calculating descriptive statistics in Microsoft Excel.
  • To elucidate the relationship between standard deviation and quartiles.
  • To enhance researchers' ability to perform preliminary data analysis.

Main Methods:

  • Utilizing Microsoft Excel functions for statistical calculations.
  • Demonstrating step-by-step procedures for standard deviation and quartile computation.
  • Explaining the conceptual link between measures of dispersion and position.

Main Results:

  • Clear instructions for generating standard deviation and quartile values in Excel.
  • An explanation of how standard deviation and quartiles describe data distribution.
  • Practical tips for accurate and efficient statistical reporting.

Conclusions:

  • Microsoft Excel offers accessible tools for essential descriptive statistics.
  • Understanding standard deviation and quartiles aids in robust data interpretation.
  • Proficiency in these Excel functions supports preliminary statistical analysis in research.