📊 Calculators

Statistics Calculator

Paste numbers from Excel, Google Sheets or any column — commas, spaces, newlines and tabs all accepted. Instantly calculates mean, median, mode, standard deviation (sample & population), variance, IQR, quartiles, outliers with z-scores, skewness, kurtosis and a frequency distribution table. CSV export included.

Paste directly from Excel / Sheets Sample & population stats side by side Z-scores + outlier detection Frequency distribution table

AdSense — 728×90 Leaderboard

Paste or type numbers — accepts commas, spaces, newlines (Excel/Sheets columns) and tabs. One dataset at a time.

Try:

AdSense — 728×90 Leaderboard

Working with fractions in your data?

The free Fraction Calculator adds, subtracts, multiplies and divides fractions and mixed numbers with step-by-step working. Compare up to 5 fractions and convert between fractions, decimals and percentages.

½ Fraction Calculator →

⭐ User Ratings

Rate this tool

4.8

Based on 28,441 ratings

25,028

1,991

853

284

285

Was this statistics calculator helpful?

Thank you for your rating!

Features

Paste from Excel, frequency tables, outlier detection — what most stat calculators skip

Most statistics calculators require comma-separated input and show a handful of results. This tool accepts columns pasted directly from spreadsheets, shows sample and population statistics side by side, produces a frequency distribution table automatically, and flags every outlier by both IQR and z-score methods.

📋

Paste from Excel / Sheets

The smart parser accepts numbers separated by commas, spaces, newlines (one per line from a spreadsheet column), tabs, semicolons — or any mix. Select a column in Excel and paste it directly. No reformatting needed. The key differentiator absent from all major free tools.

🔍

Outlier detection (IQR + z-score)

Outliers detected by two methods simultaneously. IQR method: values outside Q1−1.5×IQR or Q3+1.5×IQR are flagged. Z-score method: values with |z| > 3 are flagged as extreme outliers. Every data point shows its z-score in the table. Outliers highlighted red in the sorted list.

🧮

Sample vs population side by side

Standard deviation, variance and standard error shown for both sample (n−1 Bessel’s correction) and population (n) simultaneously. Skewness uses the sample formula. Kurtosis shows excess kurtosis (subtracts 3 for comparison to normal distribution). Coefficient of variation shown.

📈

Frequency distribution table

Every unique value listed with its frequency count, relative frequency (as %) and cumulative frequency. A bar chart column shows relative size visually. Automatically produced from any dataset — no extra setup. Absent from most free statistics calculators.

⬇

CSV export

All statistics exported to a CSV file with one click. The file includes all 20+ metrics plus the z-score table and frequency distribution. Open in Excel or Google Sheets for further analysis or reporting. UTF-8 encoded with BOM for Excel compatibility.

📊

Five-number summary + IQR

Min, Q1, Median, Q3 and Max displayed prominently as a five-number summary — the basis of a box-and-whisker plot. IQR shown as Q3−Q1. All quartile calculations use the standard method (median of upper/lower halves excluding the overall median).

How to use

How to calculate descriptive statistics

Enter or paste your data

Type numbers separated by commas, or paste a column directly from Excel or Google Sheets — the parser handles newlines, tabs, commas and spaces automatically. The counter at the right of the input shows how many valid numbers were detected. Use the example buttons to load test datasets immediately.

Click Calculate

All statistics compute instantly in your browser — no data is sent to any server. The top grid shows the eight key metrics at a glance: mean, median, mode, range, count, sum, IQR and outlier count. Scroll down for the five-number summary, sample/population comparison, z-score table, sorted list, and frequency distribution.

Check the outlier and z-score table

Every data point appears in the z-score table. The IQR outlier column flags values outside Q1−1.5×IQR or Q3+1.5×IQR. The |Z| column flags extreme values with |z| > 3. Outliers appear red in the sorted dataset below the table. The info line above the table states the outlier fence values.

Export or copy results

Use “Copy all stats” to copy a plain-text summary of all statistics to your clipboard. Use “Export CSV” to download a spreadsheet-ready CSV file containing all statistics, the z-score table, and the frequency distribution table. The file opens in Excel and Google Sheets without reformatting.

📊 Comparison

LazyTools vs other statistics calculators

Most free statistics calculators compute mean, median, mode and standard deviation. The ability to paste Excel columns, get a frequency distribution table and see IQR + z-score outlier detection in one tool are the key differentiators.

Feature	⭐ LazyTools	CalculatorSoup	StatTrek	calculator.net
Mean, median, mode, range	✔	✔	✔	✔
Sample AND population stats	✔ Side by side	✔	✔	✔
Paste from Excel / newline input	✔	⚠ Comma only	⚠ Comma only	⚠ Space/comma
Frequency distribution table	✔ With bar chart	✔	✘	✘
Outlier detection (IQR method)	✔	✔	✘	✔
Z-score per data point	✔	✘	✘	✘
Skewness & kurtosis	✔	✔	✔	✘
CSV export of all results	✔	✘	✘	✘
No ads / no signup	✔	⚠ Ads	⚠ Ads	⚠ Ads

Comparison based on publicly available features as of April 2026.

Quick reference

Descriptive statistics formulas

Measure	Formula	When to use
Mean	Σx / n	Symmetric data without outliers. Sensitive to extreme values.
Median	Middle value of sorted data	Skewed data or data with outliers. Robust to extremes.
Mode	Most frequent value	Categorical data; also meaningful for peaked distributions.
Range	Max − Min	Simple spread measure. Sensitive to outliers.
Sample std dev (s)	√[Σ(x−x̄)² / (n−1)]	Data is a sample from a larger population (Bessel’s correction).
Population std dev (σ)	√[Σ(x−μ)² / n]	Data represents the entire population.
IQR	Q3 − Q1	Robust spread measure. Used for outlier detection.
IQR outlier fence	Q1−1.5×IQR to Q3+1.5×IQR	Tukey’s rule: values outside fences are potential outliers.
Z-score	(x − mean) / std dev	Measures how many standard deviations x is from the mean. \|z\| > 3 = extreme outlier.
Skewness	[n/((n−1)(n−2))] Σ((x−x̄)/s)³	Distribution shape: 0 = symmetric, + = right tail, − = left tail.
Kurtosis (excess)	Sample kurtosis − 3	Tail heaviness. 0 = normal. + = heavy tails (more outliers).

Complete guide

Descriptive Statistics — A Complete Guide to Mean, Median, Mode, Standard Deviation and Outliers

Descriptive statistics summarise a dataset by capturing its central tendency, spread, shape and any anomalies. Unlike inferential statistics — which draw conclusions about populations from samples — descriptive statistics simply describe the data at hand. They are the starting point for any data analysis: before fitting a model, testing a hypothesis or making a business decision, you need to understand what your data looks like.

Mean median mode standard deviation calculator free

Mean is the arithmetic average: sum all values and divide by count. It is the most widely used measure of central tendency but is sensitive to outliers — a single extreme value can pull the mean far from the “typical” value. Median is the middle value when data is sorted, and is robust to outliers. For salary data with a few high earners, the median is usually a better “typical” salary than the mean. Mode is the most frequent value — useful for categorical data and peaked distributions. A dataset can have no mode (all values unique), one mode, or multiple modes. Standard deviation measures average distance from the mean. A small SD means values cluster tightly; a large SD means values are spread out.

Descriptive statistics calculator for any dataset

The full set of descriptive statistics for a dataset typically includes: count (n), sum, minimum, maximum, range, mean, median, mode, first quartile (Q1), third quartile (Q3), interquartile range (IQR), sample standard deviation, population standard deviation, sample variance, population variance, standard error of the mean (SEM), coefficient of variation (CV), skewness and kurtosis. This tool computes all of these simultaneously. The five-number summary (min, Q1, median, Q3, max) gives a complete picture of a dataset’s distribution and is the basis of a box-and-whisker plot.

Statistics calculator paste numbers from Excel

A common frustration with online statistics calculators is that they require comma-separated input, which means copying a column from Excel and reformatting it. This tool accepts any numeric separator — commas, spaces, newlines and tabs — so you can select an entire column in Excel or Google Sheets, copy it (Ctrl+C), paste it into the input (Ctrl+V), and click Calculate without any reformatting. Negative numbers, decimals, and numbers with thousands separators are all handled automatically.

Sample variance calculator online

The distinction between sample and population standard deviation is one of the most commonly confused aspects of statistics. Population standard deviation (σ) divides by n and is used when your dataset is the entire population. Sample standard deviation (s) divides by n−1 (Bessel’s correction) and is used when your data is a sample from a larger population — which is the case in almost all practical statistics. Dividing by n−1 makes the sample standard deviation an unbiased estimator of the population standard deviation. This tool shows both simultaneously so you can use whichever is appropriate for your context.

Z-score calculator free

A z-score measures how many standard deviations a value is above or below the mean: z = (x − mean) / sample SD. A z-score of 0 means the value equals the mean. A z-score of +2 means the value is 2 standard deviations above the mean. Values with |z| > 3 are extreme outliers — in a normally distributed dataset, fewer than 0.3% of values fall more than 3 standard deviations from the mean. This tool calculates the z-score for every data point and flags those with |z| > 3.

Interquartile range calculator online

The interquartile range (IQR) is the range of the middle 50% of a dataset: IQR = Q3 − Q1. It is a robust measure of spread — unlike the standard deviation, it is not distorted by outliers. Q1 (the first quartile, 25th percentile) is the median of the lower half of the sorted data. Q3 (the third quartile, 75th percentile) is the median of the upper half. Tukey’s outlier detection rule: values below Q1−1.5×IQR or above Q3+1.5×IQR are considered potential outliers. Values beyond Q1−3×IQR or Q3+3×IQR are extreme outliers.

Frequently asked questions

What is the difference between sample and population standard deviation?

Sample SD (s) divides the sum of squared deviations by n−1 (Bessel’s correction). Population SD (σ) divides by n. Use sample SD when your data is a subset of a larger group — which is the case in almost all real-world statistics. Use population SD only when you have data for every member of the group (e.g. the exact heights of all 30 students in a class, not a sample).

How do you detect outliers?

Two main methods. IQR method (Tukey’s fences): calculate Q1 and Q3. Any value below Q1−1.5×IQR or above Q3+1.5×IQR is a potential outlier. Z-score method: calculate the z-score for each value. Values with |z| > 3 are extreme outliers (occurs in fewer than 0.3% of normally distributed data). The IQR method is more robust for skewed data; the z-score method assumes approximate normality.

When should I use the median instead of the mean?

Use the median when data is skewed or contains outliers. Classic example: salaries. A dataset of salaries {23k, 25k, 27k, 24k, 350k} has a mean of ~90k — not representative of the four typical employees. The median is 25k — much closer to the typical value. House prices, income distributions and any dataset with a long tail are best described by the median. If mean and median are close, the data is roughly symmetric.

What does skewness mean?

Skewness measures the asymmetry of a distribution. A skewness of 0 means perfect symmetry. Positive skewness means the right tail is longer (few very high values pulling the mean right of the median — typical for income, house prices). Negative skewness means the left tail is longer (few very low values). Roughly: |skewness| < 0.5 = approximately symmetric, 0.5–1 = moderate skew, > 1 = high skew.

What is kurtosis?

Kurtosis measures the “tailedness” of a distribution — how extreme the outliers are. This tool shows excess kurtosis (kurtosis minus 3), so a normal distribution = 0. Positive excess kurtosis (leptokurtic) means heavier tails and more extreme outliers than normal. Negative excess kurtosis (platykurtic) means lighter tails. High positive kurtosis is a warning sign that your data has significant outliers.

What is a z-score?

A z-score (or standard score) measures how many standard deviations a value is from the mean: z = (x − mean) / s. A z-score of +2 means the value is 2 standard deviations above the mean. A z-score of −1.5 means 1.5 standard deviations below. Z-scores allow comparing values from datasets with different scales. In a normal distribution, 68% of values have |z| ≤ 1, 95% have |z| ≤ 2, and 99.7% have |z| ≤ 3.

What is the coefficient of variation (CV)?

The coefficient of variation (CV) = (standard deviation / mean) × 100%. It expresses variability as a percentage of the mean, making it useful for comparing spread across datasets with different units or scales. A CV of 10% means the standard deviation is 10% of the mean — relatively low variation. A CV of 80% means very high variation relative to the mean. CV is only meaningful when the mean is positive.

What is the standard error of the mean (SEM)?

The SEM = sample SD / √n. It measures the precision of your sample mean as an estimate of the true population mean — how much the mean would vary if you took many samples of the same size. A smaller SEM means a more precise estimate. The 95% confidence interval for the mean is approximately mean ± 2×SEM. SEM decreases as sample size increases, which is why larger samples give more reliable estimates.

Related tools