Z-Score Normalizer

Standardize a numeric CSV column to zero mean and unit variance.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

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

1
Step 1
Paste the CSV or drop a file.
2
Step 2
Enter the column name.
3
Step 3
Press Process and copy the CSV with z-scores.

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?
Enter the column and press Process. Each value becomes (x − mean) / SD.
What does a z-score of 2 mean?
The value is two standard deviations above the mean.
Does it use population or sample SD?
Sample SD (n − 1).
How is this different from the standardizer?
They run the same calculation; the names match different search terms.

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 YouTube
  • What Is A RESTful API?

    Traversy Media

    APIs are how most data tools receive payloads.

    Watch on YouTube