Numeric list
Sum, mean, median and spread for a pasted column of numbers, sorted as numbers rather than as text.
Result
- How many
- Sum
- Mean
- Median
- Smallest
- Largest
- Range
- Standard deviation (sample)
- Standard deviation (population)
Good to know
- This is the one list page that reads its input as quantities rather than as text. Sorted as text, 10 comes before 9 and 100 before 20; sorted here, they do not.
- The three number formats are spelled out with an example rather than named, because 1,234 is a different number in each of them. Nothing is guessed from the text: pick the one your data is written in.
- Sums carry a running correction as they add, so a column of prices comes out as the price it is rather than as 0.30000000000000004. The list itself is given back the way you pasted it, not reprinted in some other number format.
- Currency symbols and percent signs are ignored, so a column copied straight out of a spreadsheet works as it is. Anything else that is not a number is listed rather than quietly dropped. Everything happens in your browser — nothing you paste is sent to the server.
31 views