Descriptive Statistics Calculator One paste, a full summary — mean, median, mode, spread and quartiles

Paste your data and get every common summary statistic at once, the same set Excel's Analysis ToolPak produces. Separate values with commas, spaces or new lines.

The sample/population choice affects variance and standard deviation only.

Do this in Excel, Google Sheets or Power BI

In Excel, the quickest route to this whole table is Data → Data Analysis → Descriptive Statistics (enable the Analysis ToolPak add-in first). Or use the individual functions:

StatisticFormula
Mean / Median=AVERAGE(rng) · =MEDIAN(rng)
Std dev / Variance=STDEV.S(rng) · =VAR.S(rng)
Quartiles=QUARTILE.INC(rng, 1) · =QUARTILE.INC(rng, 3)
Min / Max / Count=MIN(rng) · =MAX(rng) · =COUNT(rng)

In Power BI these become DAX measures that drive live dashboards. Building that end to end is exactly what my Excel and Power BI courses teach.

Learn Excel & Power BI with my courses →

What descriptive statistics tell you

Descriptive statistics summarise a data set in a handful of numbers instead of a long list. They fall into three groups: measures of centre (mean, median, mode) that show where the data sits, measures of spread (standard deviation, variance, range, IQR) that show how scattered it is, and measures of position (minimum, quartiles, maximum) that show the shape of the distribution.

Reading the summary

Frequently asked questions

Which quartile method does this use?

The inclusive, linear-interpolation method that matches Excel's QUARTILE.INC and PERCENTILE.INC.

Should I pick sample or population?

Use sample (the default) when your data is a subset of a larger group; population when it covers the entire group. It only changes variance and standard deviation.

Can I copy the whole table?

Yes — the "Copy all" button copies every statistic as label-and-value pairs, ready to paste into a document or spreadsheet.