CSV Quick Stats: Descriptive Statistics & Summary in Browser

How to calculate summary statistics for tabular CSV datasets

Descriptive statistics summarize the shape, center, and spread of numerical data columns in a spreadsheet or database export. When analyzing customer transaction logs, pricing tables, or experimental results, computing central tendency and dispersion metrics helps identify data entry errors, skewness, and severe outliers before running advanced models.

This tool parses CSV tables directly in your browser's local memory. None of your raw files, row values, or column names are ever transmitted across the network or stored on our servers.

Statistical metrics evaluated

For every numerical column in your uploaded or pasted CSV dataset, the tool calculates:

1. Count & Non-Null Values: Total records and missing value detection.
2. Mean (Arithmetic Average): The sum of all numerical entries divided by the sample size: $$\bar{x} = \frac{1}{n} \sum_{i=1}^{n} x_i$$
3. Median (50th Percentile): The middle value of a sorted list, robust against extreme outliers.
4. Mode: The most frequently occurring value in the column.
5. Standard Deviation ($s$): The measure of how dispersed values are around the mean: $$s = \sqrt{\frac{1}{n - 1} \sum_{i=1}^{n} (x_i - \bar{x})^2}$$
6. Interquartile Range (IQR): The distance between the 25th percentile ($Q_1$) and 75th percentile ($Q_3$): $$\text{IQR} = Q_3 - Q_1$$

Worked example: Price column with an extreme outlier

Consider the default dataset provided in the tool:

• Values: [12, 15, 15, 18, 20, 22, 95] (Sample size $n = 7$)

Step-by-step arithmetic:

1. Sum of Values: $12 + 15 + 15 + 18 + 20 + 22 + 95 = \mathbf{197}$
2. Arithmetic Mean: $\bar{x} = \frac{197}{7} \approx \mathbf{28.14}$
3. Median (4th Sorted Element): $\mathbf{18.00}$
4. Mode: $\mathbf{15.00}$ (appears 2 times)
5. Sample Standard Deviation ($s$): $\mathbf{29.74}$
6. First Quartile ($Q_1$): $15.00$
7. Third Quartile ($Q_3$): $22.00$
8. Interquartile Range (IQR): $22.00 - 15.00 = \mathbf{7.00}$

Outlier Detection via Tukey's Fences:

• Upper Outlier Boundary: $Q_3 + (1.5 \times \text{IQR}) = 22.00 + (1.5 \times 7.00) = 22.00 + 10.50 = \mathbf{32.50}$
• Result: Because $95.00 > 32.50$, the value 95 is mathematically classified as an extreme outlier.

Notice that the mean ($28.14) is higher than 6 out of the 7 products in the catalog. Reporting the mean would mislead management about average product pricing, whereas the median ($18.00) accurately represents typical inventory costs.

When to report Median vs. Mean

Frequently asked questions

What delimiter formats does this parser support?

The parser automatically detects comma-separated values (CSV), tab-separated values (TSV), and semicolon-separated files common in European spreadsheet exports.

Is there a file size limit?

Because processing occurs inside your web browser's memory, CSV files up to 20 megabytes (tens of thousands of rows) process in under one second without page lag.

What is the difference between sample and population standard deviation?

Sample standard deviation divides by $n - 1$ (Bessel's correction) to prevent underestimating variance when working with a subset of data. Population standard deviation divides by $N$ and is reserved for complete censuses where every data point is known.