Your data
Paste a table straight from Excel or Google Sheets, or drop a CSV file. Nothing is uploaded anywhere — the whole calculation runs inside this browser tab.
CSV, TSV or plain text. Files saved in windows-1251 are detected and re-read automatically, so Cyrillic headers do not turn into garbage.
Parsing options
Columns
Result
Save and share
The drawing library is downloaded only when you press the button, and only on this page.
This page has no server side at all. The table you paste is parsed by JavaScript inside your own browser, the chart is drawn on a canvas element on your machine, and the export file is assembled locally. Nothing is uploaded, stored or written to any log. You can disconnect from the network after the page has loaded and everything will still work — which is the simplest way to verify the claim yourself.
Facts and limits of this method
| Mean | Sum divided by count. Moves with every value, including extreme ones. |
|---|---|
| Median | Middle of the sorted series; the average of the two middle values when the count is even. |
| Mode | The most frequent value. Reported as a list — a dataset can have several. |
| No mode | When every value occurs once, the tool says so instead of inventing one. |
| Skew indicator | Derived from the sign of mean − median, and confirmed by the G1 skewness coefficient. |
| Minimum rows | 2 |
When it misleads you
- The mean is the only one of the three that every value can move. In the sample data one salary of 128 pulls the mean well above every actual salary in the list except that one — which is exactly why "average pay" statistics are so often misleading.
- The median ignores magnitude entirely. It cannot tell the difference between a series ending in 48 and one ending in 4800, which makes it robust and also blind.
- The mode is meaningless on continuous measurements. Times, weights and prices rarely repeat exactly, so either there is no mode or the one you get is an artefact of rounding.
- All three describe a single peak. If your data has two clusters — say, part-time and full-time staff — none of the three lands on a real group, and the honest move is to split the data before summarising it.
How it is calculated
The mean is the sum of all valid values divided by their count. Empty and non-numeric cells are skipped rather than counted as zero, because a missing salary is not a salary of zero and treating it as one would drag the mean down.
The median is taken from the sorted series. With an odd count it is the middle element; with an even count it is the average of the two middle elements, which is the standard convention and the one your spreadsheet uses.
Modes are found by counting occurrences. If the highest count is one — every value unique — there is no mode at all, and the tool reports that rather than returning the first value it happened to see. If several values tie for the highest count, all of them are listed.
The comparison of mean and median is reported as a sentence because that is the part people actually use. Mean above median means a tail to the right, usually a few large values; mean below median means a tail to the left. When they coincide the distribution is symmetric.
Questions and answers
Which one should I report?
If the mean and the median are close, either works and the mean is more familiar. If they differ noticeably, report the median as the typical value and mention the mean separately — the gap between them is itself the finding.
Why is there no mode in my data?
Because no value repeats. That is normal for measurements like times and prices. The mode is designed for categories and for values that land on a small set of possibilities.
Can there be two modes?
Yes, and all of them are listed. Two modes usually means two groups are mixed together in one column, which is worth investigating before you compute anything else.
My mean is higher than almost every value in the list.
That is the signature of a right tail — one or a few large values. Check the outlier detection tool; a single extreme row is often a data-entry error rather than a real observation.
Is anything uploaded?
No. The whole calculation runs inside your browser and the page works with the network disconnected.