← All calculators

Descriptive Statistics

Up to 6 groups × 20 values: n, mean, SD, SEM, median, range, 95% CI, and a bar chart of means ± SEM. The same math as the Excel workbook, live in your browser.

What this is for: Per-group summaries for up to 6 groups: n, mean, SD, SEM, median, range and 95% CI, with a means chart.

The formula: SEM = SD ÷ √n; 95% CI = mean ± t(0.975, n−1) × SEM

How to use:

  1. Rename the groups as needed — each group has its own name field and values box.
  2. Type or paste each group's values, space-separated, up to 20 values per group; blank entries are ignored.
  3. Read n, mean, SD, SEM, median, min, max and the 95% CI for every group in the table.
  4. Check the bar chart of means ± SEM; a group needs at least 2 values before it has an SD, SEM or CI.

Descriptive Statistics — up to 6 groups × 20 values

Type or paste values under each group name (rename the groups freely). Statistics and the bar chart (mean ± SEM) update automatically. Blank entries are ignored.

Control — n
Control — mean
Control — SD
Control — SEM
Control — median
Control — 95% CI low
Control — 95% CI high
Prefer to work offline or keep a copy? The download link is right below.
Download the Descriptive Statistics workbook (.xlsx)
Notes & limits (from the workbook): Statistics use Excel semantics exactly as the sheet: n = COUNT (blanks ignored), mean = AVERAGE, SD = STDEV (sample SD, n−1), SEM = SD/√n, median = MEDIAN, and the 95% CI is mean ± TINV(0.05, n−1) × SEM. Groups with fewer than 2 values have no SD, SEM or CI, as in the workbook.