Descriptive Statistics User Guide

1. INTRODUCTION

The Descriptive Statistics module provides foundational data exploration and numerical summaries for scientific research across disciplines (biology, agriculture, medicine, engineering, chemistry, physics, and social sciences).

Before conducting advanced inferential testing (such as ANOVA, linear regression, or multivariate modeling), researchers must first inspect raw data features: central location, variability, spread, and symmetry. The Descriptive module aggregates continuous variables overall or breaks them down across multi-level categorical factors (e.g., Group, Condition, Site). It calculates publication-ready tables with 15+ summary statistics, built-in normality checks, and interactive diagnostic plots.

When to use this module:

Summarize central location (Mean, Median, Mode) and spread (Standard Deviation, Variance, Range, IQR) for quantitative variables.
Analyze variable distributions across experimental factors in Combined or Grouped modes.
Evaluate distribution symmetry and tail heaviness using Skewness and Kurtosis metrics.
Generate scientific summary tables and visual distribution plots (Histograms, Box Plots, Density curves, Q-Q plots, Violin plots) for research reports.

2. AVAILABLE OPTIONS & SETTINGS

The sidebar control panel and top header bar provide controls for analysis mode, factor mapping, variable selection, decimal rounding, and data transformations:

Control / Option	What it does	Why it is used	When to use / select
Analysis Mode	Toggles analysis structure between `Combined` (overall summary across all rows) and `Grouped` (breakdown by factor levels).	Determines whether summary statistics are aggregated overall or computed per factor group level.	Select Combined for overall dataset summaries; select Grouped to compare treatment/factor levels.
Factor A / B / C Mapping	Maps up to 3 categorical factor columns (e.g., `Group`, `Condition`, `Site`).	Defines categorical grouping variables for subgroup summaries.	Select categorical columns when analyzing data in Grouped mode.
Replication / Block Mapping	Maps replication or blocking columns (e.g., `Replicate`, `Block`).	Preserves layout and blocking structure across exported tables.	Select when dataset contains explicit trial block identifiers.
Grouping By Selector	Appears in Grouped mode to toggle active grouping factor filters (e.g., `Group`, `Condition`).	Filters displayed summary tables and plots to a specific factor level or displays all combined.	Located in top header controls when Grouped mode is active.
Decimal Rounding	Sets output numerical precision selector (0, 1, 2, 3, or 4 decimal places).	Formats calculated summary metrics, standard errors, and confidence intervals in output tables.	Located in the top header bar; adjust before exporting tables.
Transformation Toggle	Toggles automated transformation mode `On` or `Off` and configures variable-specific transformations.	Applies mathematical transformations (Log, Square Root, Arcsine, Box-Cox) prior to computing summary metrics.	Use when raw data is highly skewed and transformed summary metrics are needed.
Variables (Traits) Selection	Pill selectors choosing quantitative continuous columns to summarize.	Identifies target quantitative variables for descriptive statistical analysis.	Select one or more continuous numeric variables from your uploaded dataset.

3. INPUT DATA FORMAT

The module accepts structured tabular spreadsheets (Excel .xlsx, .xls, or CSV .csv) adhering to standard rules:

Header Row: Line 1 must contain unique header names for all categorical factor columns and quantitative measurement columns.
Data Types: Categorical factor columns (e.g., Group, Condition) must contain text labels; quantitative variable columns must contain numeric values.
Data Entry Rules: Missing or blank values are automatically omitted from group calculations without corrupting other group totals.

Sample Input Table (Continuous Measurements across Experimental Groups)

Below is a representative dataset containing generalized factor columns (Group, Condition) and quantitative measurement variables (Response_Value, Concentration):

Group	Condition	Replicate	Response_Value	Concentration
Group-01	Control	R1	45.20	12.40
Group-01	Control	R2	46.80	13.10
Group-01	Control	R3	44.90	12.80
Group-01	Treated	R1	58.40	25.60
Group-01	Treated	R2	61.20	28.10
Group-01	Treated	R3	59.10	26.40
Group-02	Control	R1	41.50	10.20
Group-02	Control	R2	43.10	11.00
Group-02	Control	R3	42.00	10.80

4. METHODS & STATISTICAL METRICS

The Descriptive module calculates a comprehensive set of summary statistics categorized into central tendency, dispersion, distribution shape, and estimation error:

Statistical Category	Summary Metric	Plain Language Definition & Purpose
Central Tendency	Mean (Arithmetic Average)	Sum of all values divided by total sample size. Represents the central balance point.
	Median (50th Percentile)	Middle value when data is sorted in order. Robust against extreme outliers and skewed data.
	Mode	Most frequently occurring value in the observation series.
Dispersion & Spread	Standard Deviation (SD)	Average distance of data points from the sample mean. Measures data spread in original units.
	Variance	Square of the standard deviation. Measures overall variation across observations.
	Standard Error (SE)	Standard deviation divided by the square root of sample size. Measures precision of the sample mean estimate.
	Range	Difference between maximum and minimum observed values (Max minus Min).
	Interquartile Range (IQR)	Difference between 75th percentile (Q3) and 25th percentile (Q1). Measures spread of the middle 50% of data.
	Coefficient of Variation (CV %)	Standard deviation divided by mean, expressed as a percentage. Measures relative variability independent of scale.
Distribution Shape	Skewness	Measures distribution asymmetry. Value of zero indicates symmetry; positive indicates right-skew; negative indicates left-skew.
Distribution Shape	Kurtosis (Excess Kurtosis)	Measures tail heaviness and peak sharpness compared to a normal distribution (excess kurtosis of zero indicates normal bell shape).
Confidence & Sample Size	95% Confidence Interval (CI)	Upper and lower range bounds within which the true population mean lies with 95% certainty.
Confidence & Sample Size	Sample Count (n) & Missing Count	Total count of non-null observations and number of missing values per variable.

5. RESULTS

Upon clicking RUN ANALYSIS, the module displays a multi-tab workspace featuring main summary tables, interactive visualization plots, automated text interpretations, and report summary views.

Sample Result 1: Descriptive Statistics Summary Table (Grouped Mode)

The main summary table reports full descriptive metrics computed per factor level and variable:

Variable	Group	Count (n)	Mean	Median	Std Dev	Std Error	Min	Max	CV (%)	Skewness	Kurtosis
Response_Value	Group-01	6	54.267	53.600	6.850	2.796	44.900	61.200	12.62%	0.124	-1.210
Response_Value	Group-02	3	42.200	42.000	0.819	0.473	41.500	43.100	1.94%	0.312	-1.500
Concentration	Group-01	6	19.733	19.350	7.280	2.972	12.400	28.100	36.89%	0.415	-1.420
Concentration	Group-02	3	10.667	10.800	0.416	0.240	10.200	11.000	3.90%	-0.812	-1.500

Sample Result 2: Visualization Suite

The Plots tab generates interactive figures for each analyzed variable:

Histograms: Frequency distributions overlaid with smooth kernel density curves.
Box Plots: Comparative box-and-whisker diagrams displaying median, IQR, and potential outliers across factor groups.
Violin Plots: Density distribution width combined with box plot quartiles.
Bar Charts: Group means with error bars representing Standard Error (SE) or Standard Deviation (SD).

6. QUICK WORKFLOW

Upload Dataset: Upload your .xlsx or .csv spreadsheet using the sidebar upload control.
Select Analysis Mode: Choose Combined for overall summaries or Grouped for factor breakdown in the top bar.
Map Factor Columns: Map categorical factor columns (Factor A/B/C) and replication/block columns if using Grouped mode.
Select Variables: Click the pill selectors in the sidebar to choose quantitative continuous variables for analysis.
Set Decimals & Options: Adjust decimal rounding and toggle transformation options if needed.
Execute Analysis: Click RUN ANALYSIS to compute descriptive metrics and plot figures.
Export Summary: Download report tables as Excel (.xlsx) or DOCX, or save plot figures for scientific presentations.

7. IMPORTANT NOTES

Handling Skewed Distributions

When Skewness significantly departs from zero (e.g., skewness greater than +1 or less than -1), report the Median and Interquartile Range (IQR) alongside the Mean and Standard Deviation, as the median is less sensitive to extreme values.

Cite DATES in Research Papers

If you use the DATES Descriptive Statistics module for data exploration or summary calculations in published scientific work, please cite it as follows:

@software{dates_app_2026, author = {DATES Development Team}, title = {DATES: Data Analysis and Trial Evaluation System}, year = {2026}, url = {https://dates-app.org}, note = {Basic Statistics & Descriptive Modules} }