A column of amounts can look tidy and still contain an empty cell or a text label. Statistics only make sense once you know which values were counted. This tool keeps that choice visible instead of quietly treating everything as zero.
Use CSV Numeric Column Statistics with a CSV header and the exact name of the numeric column. Blank values are excluded and reported. A nonblank value that is not numeric produces an error.
Three amounts you can check yourself
Create an amount column containing 1200, 1500 and 1800. The sum is 4500, the mean is 1500 and the median is 1500. The smallest amount is 1200 and the largest is 1800.
| Measure | Result |
|---|---|
| Numeric records | 3 |
| Population standard deviation | 244.949, approximately |
| Sample standard deviation | 300 |
Population deviation describes those three recorded values as the whole set. Sample deviation uses a different denominator when the records are being treated as a sample. Select the version that fits your analysis rather than whichever number looks smaller.
An empty cell is not a free item
If a fourth record has no amount, the numeric count stays three. Enter 0 when a genuine zero belongs in the analysis. An unknown amount and a zero payment describe different situations.
The tool does not guess thousands separators. A formatted amount such as 1,200 is not interchangeable with 1200, especially when commas also separate CSV columns. Clean the source representation deliberately.
These figures summarise a column. They do not account for currency changes, refunds, duplicated invoices or different accounting periods. Review those issues before using an average as a business conclusion.
Keep the column name and deviation choice with the exported report. That gives another reader enough context to reproduce the calculation instead of seeing an unexplained average.