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.6K
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.6K
Correlation and Regression00:53

Correlation and Regression

3.5K
In statistics, correlation describes the degree of association between two variables. In the subfield of linear regression, correlation is mathematically expressed by the correlation coefficient, which describes the strength and direction of the relationship between two variables. The coefficient is symbolically represented by 'r' and ranges from -1 to +1. A positive value indicates a positive correlation where the two variables move in the same direction. A negative value suggests a...
3.5K
Microsoft Excel: Pearson's Correlation01:18

Microsoft Excel: Pearson's Correlation

2.2K
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...
2.2K
Regression Toward the Mean01:52

Regression Toward the Mean

7.2K
Regression toward the mean (“RTM”) is a phenomenon in which extremely high or low values—for example, and individual’s blood pressure at a particular moment—appear closer to a group’s average upon remeasuring. Although this statistical peculiarity is the result of random error and chance, it has been problematic across various medical, scientific, financial and psychological applications. In particular, RTM, if not taken into account, can interfere when...
7.2K
The Scientific Method03:50

The Scientific Method

68.6K
Chemistry is an empirical science. Scientists often pose questions to understand the chemistry in everyday life and seek answers to these questions. To achieve this, scientists follow a definitive series of steps that together make up the Scientific Method. This approach involves making observations, asking questions, building a hypothesis, conducting experiments, analyzing results, and forming a conclusion. 
68.6K
The Scientific Method01:32

The Scientific Method

270.3K
The scientific method is a detailed, empirical problem-solving process used by biologists and other scientists. This iterative approach involves formulating a question based on observation, developing a testable potential explanation for the observation (called a hypothesis), making and testing predictions based on the hypothesis, and using the findings to create new hypotheses and predictions.
Generally, predictions are tested using carefully-designed experiments. Based on the outcome of these...
270.3K

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 11, 2026

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

WASP (Write a Scientific Paper) using Excel - 13: Correlation and Regression.

Victor Grech1

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

Early Human Development
|April 23, 2018
PubMed
Summary
This summary is machine-generated.

Learn how to use correlation and regression analysis in Microsoft Excel for understanding relationships between variables. This guide covers performing tests, interpreting results, and applying functions dynamically.

Keywords:
BiostatisticsComputersSoftwareStatistics

More Related Videos

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
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 11, 2026

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

  • Statistics
  • Data Analysis

Background:

  • Correlation and regression are fundamental statistical methods.
  • Understanding the association between continuous variables is crucial in many fields.

Purpose of the Study:

  • To provide a guide on performing correlation and regression analysis using Microsoft Excel.
  • To explain the interpretation of these statistical tests.
  • To demonstrate dynamic application of these tests with Excel functions.

Main Methods:

  • Utilizing Microsoft Excel for statistical analysis.
  • Performing correlation and regression tests within Excel.
  • Applying built-in Excel functions for dynamic analysis.

Main Results:

  • Successful execution of correlation and regression tests in Excel.
  • Clear interpretation guidelines for test outputs.
  • Demonstration of dynamic analysis capabilities.

Conclusions:

  • Microsoft Excel is a viable tool for conducting correlation and regression analyses.
  • Users can effectively interpret statistical outputs for better data insights.
  • Dynamic application enhances the utility of these tests in Excel.