Related Experiment Video
Updated: Aug 12, 2025

Automated Detection and Analysis of Exocytosis
Published on: September 11, 2021
Rex: R-linked EXcel add-in for statistical analysis of medical and bioinformatics data
Bora Lee1,2, Jaehoon An2,3, Sungyoung Lee4,5
1Institute of Health and Environment, Seoul National University, Seoul, Republic of Korea.
Background:
Microsoft Excel has substantial functionalities for data management and analyses, and has been the most popular software in this field. However, in spite of Excel's user-friendly interface and functionality for data management, it provides very few functions for in-depth statistical analyses, which has limited its wider application for this purpose.
Objective:
Here, we introduce Rex, an Excel add-in software implementing the powerful analytical and graphical functions of R within Excel.
Methods:
Rex was implemented using three types of programming software: R, JavaScript, and Microsoft VB.Net.
Results:
Rex provides a graphical user interface (GUI) through Excel, and statistical analysis can be conducted by pointing and clicking the menu without programming R. Rex covers a wide range of analyses from basic statistics to advanced analysis, including structural equation modeling, complex sampling design, and machine learning models, making it possible for researchers not skilled in using a command-line interface to conduct in-depth statistical analyses. Most Rex modules are available in a free version for non-commercial use, and it can be used for educational and public purposes.
Conclusion:
In this article, we introduce the framework and features of Rex with illustrative examples of its implementation.
Related Concept Videos
Statistical Software for Data Analysis and Clinical Trials
Overview of Microsoft Excel as a Data Analysis Tool
Performing a Simple Data Analysis using MS-Excel Function
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...
Introduction to R
Microsoft Excel: Regression Analysis
To perform regression...
Statistical Analysis System (SAS)
Applications: SAS finds applications in numerous fields, including healthcare for clinical trial analysis, finance for risk assessment, marketing for customer data analysis, and...

