相关实验视频

Updated: Sep 20, 2025

Automated Measurement of Pulmonary Emphysema and Small Airway Remodeling in Cigarette Smoke-exposed Mice
10:37

Automated Measurement of Pulmonary Emphysema and Small Airway Remodeling in Cigarette Smoke-exposed Mice

Published on: January 16, 2015

13.4K

在追溯图表审查研究中对微软Excel宏的准确性的比较分析

Justin Bauzon1, Gustavo Romero-Velez1, Ludovico Sehnem1

  • 1Department of Endocrine Surgery, Cleveland Clinic Foundation, Cleveland, Ohio.

The Journal of surgical research
|May 24, 2025
PubMed
概括

微软Excel宏显著加速电子健康记录数据抽象用于研究. 虽然手动检查的错误略有减少,但宏是270倍更快,高度准确,对于大数据集来说是有效的.

关键词:
图表审查 图表审查数据抽象数据抽象数据清理数据清理数据挖掘是一种数据挖掘.电子健康记录电子健康记录观察性研究是一种观察性研究.回顾性图表审查回顾性图表审查

更多相关视频

A Method of Trigonometric Modelling of Seasonal Variation Demonstrated with Multiple Sclerosis Relapse Data10:46

A Method of Trigonometric Modelling of Seasonal Variation Demonstrated with Multiple Sclerosis Relapse Data

Published on: December 9, 2015

10.8K
Using Continuous Data Tracking Technology to Study Exercise Adherence in Pulmonary Rehabilitation09:42

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

Published on: November 8, 2013

13.7K

相关概念视频

Overview of Microsoft Excel as a Data Analysis Tool01:13

Overview of Microsoft Excel as a Data Analysis Tool

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

Microsoft Excel: Student's t-Test

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

Microsoft Excel: Regression Analysis

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

Microsoft Excel: Plotting Mean, SD, and SE

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

Performing a Simple Data Analysis using MS-Excel Function

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

Microsoft Excel: Pearson's Correlation

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