Z-Score Normalizer
Standardize a numeric CSV column to zero mean and unit variance.
About this tool
Turn a numeric column into z-scores: each value becomes the number of standard deviations it sits from the column mean. A z-score of 0 is average, +2 is two SDs above. The mean and SD used are returned.
How to use
How it works
z = (x − mean) / sd, where sd is the sample standard deviation (n − 1). If the SD is zero, every output is 0. After scaling, the column has mean 0 and sample SD 1.
z = (x − mean) / sd
Worked example
Z-scores for y
- Input
- y: 2.1, 3.9, 6.2, 7.8, 10.1, 12.2, 30
- Output
- mean 10.3286, std 9.3363 -0.8814, -0.6886, -0.4422, -0.2708, -0.0245, 0.2004, 2.1070
- Walkthrough
- The value 30 is (30 − 10.3286) / 9.3363 = 2.107 SDs above the mean, the only value more than 1 SD away on the high side.
Limitations
- One numeric column per run.
- The SD is the sample version (n − 1), so values differ slightly from scikit-learn's StandardScaler.
- Z-scores say nothing about normality.
Questions
How do I calculate z-scores for a column?
What does a z-score of 2 mean?
Does it use population or sample SD?
How is this different from the standardizer?
Features
- Z-scores
- Mean and SD returned
- Runs in your browser
Related resources
Guides and videos from around the web—opens on YouTube or the publisher’s site.
Finding mean, median, and mode
Khan Academy
Descriptive stats for quick data summaries.
Watch on YouTubeWhat Is A RESTful API?
Traversy Media
APIs are how most data tools receive payloads.
Watch on YouTube
- Data Index
Math is Fun
Stats explainers when summarizing columns.
- Model for Tabular Data and Metadata on the Web
W3C
Tabular data model behind CSV-oriented workflows.