Data template

Descriptive Statistics Summary

Mean, median, quartiles, spread and z-scores for a column of numbers, with outliers flagged.

$19one payment, yours to keep

✓Instant download
✓Every later version free
✓Commercial use
✓No signup, no watermark

144: live formulas, each one recalculated and checked
7: columns: #, Value, Deviation from mean, Squared deviation, Z-score, Percentile rank, Flag
19: figures worked out for you

A student, researcher or analyst · Universities, research teams and analysts — usually looking for this when a dataset needs summarising properly, not eyeballing.

Need more than one? All 9 Data templates for $39 — $119 bought separately. All 66 for $99.

Works in Excel 2013 and later, Microsoft 365, Google Sheets and LibreOffice Calc. Set up to print on one page wide. Version 1, updated 25 September 2026.

There are free templates. Why this one?

There are, and some are fine. The difference is what has been checked. This file was built from scratch, then every formula in it was recalculated by a separate checker that compares each result against an independently worked-out answer — 144 of them here. A template that looks right and totals wrong is worse than no template at all, and that is the usual failing of one downloaded from a search result.

It also opens with sample rows already filled in, so you can see every formula working before you touch it, and it is set up to print without fighting the page setup. No email wall, no signup, no watermark, and you can use it commercially.

About this Descriptive Statistics Summary template

Before analysing a set of numbers, you need to know what they look like. This Excel descriptive statistics template takes a column of values and works out the count, mean, median, range, quartiles, interquartile range, standard deviation, variance and a 95% confidence interval for the mean.

Every value gets its deviation from the mean, a z-score and a percentile rank, and anything more than two standard deviations from the mean is flagged as an outlier.

Good for

→Summarising survey, sales or performance data
→Checking a dataset for outliers before analysis
→Learning descriptive statistics with every formula visible

What it works out for you

Centre and spread

→Count
→Sum
→Mean
→Median
→Minimum
→Maximum
→Range
→Lower quartile (Q1)
→Upper quartile (Q3)
→Interquartile range
→Standard deviation (sample)
→Variance (sample)
→Coefficient of variation
→Standard error of the mean
→95% confidence — low
→95% confidence — high
→Values beyond 2 standard deviations
→Tukey lower fence
→Tukey upper fence

What is inside the Descriptive Statistics Summary template

The table has 7 columns. Calculated columns fill themselves in; the rest are yours to type over.

→#
→Value
→Deviation from mean
→Squared deviation
→Z-score
→Percentile rank
→Flag

How to use the Descriptive Statistics Summary in Excel

Paste your numbers into the Value column, over the samples. Everything else — deviations, z-scores, outlier flags and the whole summary — recalculates.

The file opens with sample rows so you can see every formula working before you change anything. Type your own figures over them. When you need more rows, insert them inside the existing block rather than underneath it, so the totals keep covering every row.

Functions and formulas it uses

Every one of these exists in Excel, Google Sheets and LibreOffice, so the file behaves the same wherever you open it.

ABSAVERAGECOUNTCOUNTIFIFIFERRORMAXMEDIANMINQUARTILESQRTSTDEVSUMVAR

Questions about the Descriptive Statistics Summary

Is the standard deviation for a sample or a population?

A sample. It uses STDEV, which divides by n − 1 — the right choice when your data is a sample of a larger group.

How are outliers flagged?

Values with a z-score beyond ±2 are flagged as outliers and those beyond ±1.5 as unusual. The Tukey fences, based on the interquartile range, are shown as well.