TextArray
100% local

Sum and number statistics

Add up a list of numbers and get the mean, median, min, max and standard deviation.

Input
Output

Sum and number statistics

Paste a column of numbers and get the whole picture at once: how many values there are, their sum, mean, median, minimum, maximum and standard deviation. It is the quickest way to total an invoice column, check a figure exported from a spreadsheet, average a set of response times, summarise survey scores or sanity-check order values without opening a spreadsheet app.

Numbers can arrive in almost any shape. The separator is detected automatically, so a list broken by line breaks, commas, semicolons, tabs or spaces all work — and so do lists that mix them. Both notations are understood as well: 3.14 and 3,14 mean the same thing, and the tool reads the whole input before deciding which character is the decimal one, so a single list is never interpreted two ways. Results are printed back in the notation you used. One caveat: automatic mode treats a space as a separator, so if your numbers use spaces for thousands grouping, such as 1 234,56, pick the "One per line" separator instead.

Switch on "Extract numbers from text" to pull figures out of ordinary prose — a paragraph, a log line, a pasted report — instead of treating each value as its own entry. Non-numeric values are skipped and counted by default; turn that off and the tool names the first value it cannot read. You can also choose the number of decimal places and whether the standard deviation is the population one, dividing by n, or the sample one, dividing by n−1.

Everything is calculated in your browser and nothing is uploaded, so financial figures, salaries or unpublished metrics stay on your device. The tally under the results updates live as you type.

FAQ

Does it handle both 3.14 and 3,14?
Yes. The tool reads the whole input before deciding which character is the decimal separator, so one list is never interpreted two ways, and results are printed in the same notation you used. You can also force the point or the comma in the options.
What is the difference between population and sample deviation?
The population deviation divides by n and describes exactly the numbers you pasted. The sample deviation divides by n−1 and estimates the spread of the larger group those values came from. A single value has no sample deviation, so the result shows a dash.
Can it pull numbers out of a sentence?
Turn on "Extract numbers from text" and the tool scans prose for figures instead of splitting it into values. A hyphen inside a word or a range, such as COVID-19 or 3-5, is not read as a minus sign.
What happens to values that aren't numbers?
They are skipped and their count appears in the tally. Turn off "Skip non-numeric values" and the tool stops at the first value it cannot read and names it, so you can fix the input.
Are my numbers uploaded anywhere?
No. Every statistic is calculated in your browser and the numbers never leave your device.