Z-Score Calculator · Practical guide
Z Score Calculator from a Data Set
Paste your raw numbers and a target value — the mean and standard deviation are computed for you.
At a glance
No Mean or Standard Deviation? No Problem
When you only have raw data, use the Full Dataset tab: paste comma-separated values plus the target value you want to score. The tool computes the population mean and standard deviation for you, then returns the z-score, approximate percentile, and interpretation — including the exact formula with your numbers filled in.
Interactive tool
Z-Score Calculator
Enter your own values, then compare the result with the examples below.
Results
Worked Example
Suppose weekly sales figures are 12, 15, 18, 21, 24 (thousands) and you want to score the best week, 24:
- Mean: (12 + 15 + 18 + 21 + 24) / 5 = 18
- Variance: (36 + 9 + 0 + 9 + 36) / 5 = 18, so σ = √18 = 4.2426
- Z score: (24 − 18) / 4.2426 = 1.4142
- Result: percentile ≈ 92.1%, interpretation "Above average"
Population vs. Sample in Dataset Mode
Note that the Full Dataset tab uses the population formula — the variance divides by n, not n − 1. If your data is a sample and you need the sample standard deviation, compute it separately and use the Summary Stats tab instead. For quick comparisons within a single dataset, the population version is standard practice.
Tips for Clean Data Entry
- Separate values with commas; spaces are fine and blank entries are ignored.
- Enter at least two numbers — a standard deviation needs variation to exist.
- The target value does not need to be in the dataset; scoring an outside value is often the point.
The more values you include, the more stable the mean and standard deviation — and the more trustworthy the z-score.
Frequently Asked Questions
Can the target value be a number not in the data set?
Yes. Enter any value to score — for example, paste last year's monthly figures and score this month's number against them.
How many values do I need for a valid z score?
At least two, since the standard deviation of a single value is zero. In practice, a dozen or more values give a much more stable estimate.
What happens with non-numeric entries in the list?
They are filtered out automatically. Only valid numbers count toward the mean and standard deviation.
Does the dataset mode use sample or population standard deviation?
Population — the variance divides by n. If you need the sample version (dividing by n − 1), compute it separately and enter it in the Summary Stats tab.