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

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

Performing a Simple Data Analysis using MS-Excel Function

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

Microsoft Excel: Regression Analysis

761
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...
761
Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis01:24

Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis

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

Microsoft Excel: Median, Quartile range, and Box Plots

1.3K
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...
1.3K
Microsoft Excel: Plotting Mean, SD, and SE01:18

Microsoft Excel: Plotting Mean, SD, and SE

339
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...
339

You might also read

Related Articles

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

Sort by
Same author

Optimizing reporting and outreach for surveillance and risk-reducing surgeries for cancer genetic predisposition: Findings of a workshop organized by the International Cascade Consortium.

Public health genomics·2026
Same author

Nurses and midwives require greater genomic confidence to support prenatal genetic counselling referral.

Evidence-based nursing·2026
Same author

Job satisfaction among nephrology nurses: An Italian multicenter cross-sectional study.

Applied nursing research : ANR·2026
Same author

Learning about the genetic risk in my family: Preferences of Italian nurses.

Journal of community genetics·2026
Same author

Cascade testing as the missing link in cancer prevention among Lynch syndrome families.

Familial cancer·2026
Same author

Accuracy and Precision of Third-Generation Tympanic Thermometers With Varying Calibration Intervals: A Multicenter Cross-Sectional Study.

Nursing research and practice·2026
Same journal

Using photo elicitation in focused ethnography with adolescents: methodological lessons from an urban greenspace study.

Nurse researcher·2026
Same journal

Adapting interpretative phenomenological analysis: a multilayered perspectival design for health research.

Nurse researcher·2026
Same journal

An art-based mixed-methods study exploring children's environmental preferences in home-based nursing research.

Nurse researcher·2026
Same journal

Using fuzzy-set qualitative comparative analysis in clinical nursing research.

Nurse researcher·2026
Same journal

Integrating the experience sampling method and intersectionality to capture lived realities in nursing research.

Nurse researcher·2026
Same journal

Fraudulent qualitative study participants: experiences of two nurse researchers.

Nurse researcher·2026
See all related articles

Related Experiment Video

Updated: Aug 8, 2025

Meta-Analysis of the Effectiveness and Safety of Shugan Jieyu Capsules for the Treatment of Insomnia
04:34

Meta-Analysis of the Effectiveness and Safety of Shugan Jieyu Capsules for the Treatment of Insomnia

Published on: February 17, 2023

1.2K

How to structure Microsoft Excel documents for systematic reviews.

Lea Godino1

  • 1IRCCS Azienda Ospedaliero-Universitaria di Bologna, Bologna, Italy.

Nurse Researcher
|March 1, 2023
PubMed
Summary
This summary is machine-generated.

This study presents a free and efficient method using Microsoft Excel for conducting systematic reviews. It offers a transparent and complete alternative to costly software for researchers.

Keywords:
auditdata analysisdata collectionliterature searchmethodologyresearchsystematic review

More Related Videos

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

6.4K
Cellular Redox Profiling Using High-content Microscopy
11:37

Cellular Redox Profiling Using High-content Microscopy

Published on: May 14, 2017

11.0K

Related Experiment Videos

Last Updated: Aug 8, 2025

Meta-Analysis of the Effectiveness and Safety of Shugan Jieyu Capsules for the Treatment of Insomnia
04:34

Meta-Analysis of the Effectiveness and Safety of Shugan Jieyu Capsules for the Treatment of Insomnia

Published on: February 17, 2023

1.2K
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

6.4K
Cellular Redox Profiling Using High-content Microscopy
11:37

Cellular Redox Profiling Using High-content Microscopy

Published on: May 14, 2017

11.0K

Area of Science:

  • Bibliometrics
  • Information Science
  • Research Methodology

Background:

  • Systematic reviews are research-intensive, requiring extensive literature searches, data extraction, and quality assessment.
  • While digital tools exist, many involve significant costs, posing a barrier for some researchers.
  • Microsoft Excel is a widely accessible, cost-free software solution.

Purpose of the Study:

  • To demonstrate a method for generating transparent and complete systematic review reports using Microsoft Excel.
  • To provide researchers with a practical, no-cost approach to systematic review management.

Main Methods:

  • The described method involves six key steps for managing systematic reviews in Excel.
  • These steps include reference downloading, data organization, duplicate removal, and multi-stage screening (title/abstract, full-text).
  • Final inclusion listing is a crucial part of the process.

Main Results:

  • The Excel-based approach is efficient, cost-effective, and produces high-quality systematic review reports.
  • This method serves as a viable alternative to specialized, often expensive, systematic review software.
  • Generated documents can be directly utilized for scientific text production.

Conclusions:

  • Microsoft Excel provides a powerful, accessible tool for systematic review processes.
  • The described six-step method ensures transparency and completeness in systematic review reporting.
  • This approach democratizes systematic review conduct, making it feasible for a broader range of researchers.