FREE WEB TOOL
Calculate count, sum, mean, median, min, max, and standard deviation for a numeric CSV column.
Use this when a numeric CSV column needs more than a quick average. The tool shows count, sum, mean, median, minimum, maximum, and population standard deviation together so you can see both center and spread.
This is a subtle but important distinction. In JavaScript, an empty string can become numeric zero if converted too early. That would change the meaning of an average. The tool removes blank values first, then converts remaining values to numbers.
If your CSV has 100 data rows but the metric says 92 values, eight rows were blank or could not be parsed as finite numbers. Looking at count before mean helps you catch missing or badly formatted data. A value such as 1,000 is not directly parsed as a number here.
For 10, 11, 12, 200, the mean is pulled upward while the median stays near the middle of the ordinary values. A large gap between mean and median is a useful prompt to inspect outliers or a skewed distribution.
The displayed standard deviation divides by n, treating the selected values as the full population. It is not the sample standard deviation that divides by n-1. Match that definition when comparing the result with a spreadsheet or statistics package.
After filtering a sales export, inspect the sales column’s count, median, and spread—not just its average. The combination often reveals missing values or a few extreme rows that a single mean would hide.