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

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

Performing a Simple Data Analysis using MS-Excel Function

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

Overview of Microsoft Excel as a Data Analysis Tool

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

Microsoft Excel: Plotting Mean, SD, and SE

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

Microsoft Excel: Finding Central Tendency, Skew, and Kurtosis

122
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...
122
Microsoft Excel: Pearson's Correlation01:18

Microsoft Excel: Pearson's Correlation

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

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

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 author

STROBE, CONSORT, PRISMA, MOOSE, STARD, SPIRIT, and other guidelines - Overview and application.

Saudi journal of anaesthesia·2024
Same journal

Transient Occlusion of the Central Retinal Artery in a Patient with Granulomatosis with Polyangiitis.

Acta medica (Hradec Kralove)·2026
Same journal

Growth Hormone-Mediated Diabetic Ketoacidosis: A Rare Presentation of Acromegaly.

Acta medica (Hradec Kralove)·2026
Same journal

Comparison between the Prognosis of Temporomandibular Disorders with and without Accompanying Otologic Symptoms after Non-Invasive Non-Pharmacological Treatment: Controlled Clinical Trial.

Acta medica (Hradec Kralove)·2026
Same journal

Managing Impacted Mandibular Third Molars: A Scoping Review of Surgical Extraction versus Orthodontic Traction and Nerve Injury Risk.

Acta medica (Hradec Kralove)·2026
Same journal

Current and Emerging Approaches to Osseointegration Assessment in Dental Implantology: Limitations, Clinical Utility, and Future Directions.

Acta medica (Hradec Kralove)·2026
Same journal

Structural and Functional Determinants of Oxygen Transport in Exercise: The Role of Total Hemoglobin Mass.

Acta medica (Hradec Kralove)·2026
See all related articles

Related Experiment Video

Updated: May 27, 2025

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

10.6K

Forecasting with Excel.

Victor Grech1

  • 1Mater Dei Hospital, Malta. victor.e.grech@gov.mt.

Acta Medica (Hradec Kralove)
|February 18, 2025
PubMed
Summary
This summary is machine-generated.

This study introduces a user-friendly Excel spreadsheet for time series forecasting using the FORECAST.ETS function. It empowers individuals, including medical professionals, to perform sophisticated data analysis and make informed predictions.

Keywords:
Excelexponential smoothingforecastinghealth Workforcehealth services needs and demandholt-winters testmodelsstatisticalstatistics & numerical datatrends

More Related Videos

Using Generative Art to Convey Past and Future Climate Transitions
06:10

Using Generative Art to Convey Past and Future Climate Transitions

Published on: March 31, 2023

854
Author Spotlight: Optimization of Airflow Velocities in Battery Cooling Systems for Enhanced Thermal Performance and Reduced Energy Consumption
10:36

Author Spotlight: Optimization of Airflow Velocities in Battery Cooling Systems for Enhanced Thermal Performance and Reduced Energy Consumption

Published on: November 3, 2023

1.4K

Related Experiment Videos

Last Updated: May 27, 2025

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

10.6K
Using Generative Art to Convey Past and Future Climate Transitions
06:10

Using Generative Art to Convey Past and Future Climate Transitions

Published on: March 31, 2023

854
Author Spotlight: Optimization of Airflow Velocities in Battery Cooling Systems for Enhanced Thermal Performance and Reduced Energy Consumption
10:36

Author Spotlight: Optimization of Airflow Velocities in Battery Cooling Systems for Enhanced Thermal Performance and Reduced Energy Consumption

Published on: November 3, 2023

1.4K

Area of Science:

  • Data Science
  • Statistical Modeling

Background:

  • Time series analysis is essential for future predictions.
  • Excel's FORECAST.ETS function offers sophisticated forecasting capabilities.
  • This tool makes advanced analysis accessible to non-statisticians, like medical practitioners.

Purpose of the Study:

  • To demonstrate how Excel facilitates a sophisticated forecasting technique.
  • To present a user-friendly spreadsheet for time series analysis.
  • To enable clinicians to perform data forecasting with ease.

Main Methods:

  • Utilized Excel's FORECAST.ETS function.
  • Developed a bespoke spreadsheet with error trapping and data input validation.
  • Employed macros to invoke FORECAST.ETS.CONFINT for confidence interval calculations.

Main Results:

  • A functional spreadsheet was created for time series forecasting.
  • The spreadsheet generates forecasts with 95% confidence intervals and line graphs.
  • Calculated confidence intervals from 95% to 99% using a macro.

Conclusions:

  • Forecasting is crucial across all fields, especially medicine.
  • The developed Excel tool simplifies sophisticated time series analysis for users without advanced statistical knowledge.
  • Encourages wider adoption of accessible forecasting methods in clinical practice.