STANDARDIZE Function in Excel: Syntax, Examples and Free Practice
STANDARDIZE is an Excel Statistical function. Returns a normalized (z-score) value.
STANDARDIZE syntax
Arguments
x: The value to evaluatemean: The average (mean) of the distributionstandard_dev: The standard deviation of the distribution
When to use STANDARDIZE
STANDARDIZE is used in data analysis work to summarize or test patterns across a data set.
Practice STANDARDIZE online, free
Open the live Excel-style spreadsheet and try STANDARDIZE yourself. No Excel install or sign-up needed to start.
Practice STANDARDIZE now →More Statistical functions
Frequently asked questions
What does the STANDARDIZE function do in Excel?
Returns a normalized (z-score) value.
What is the syntax of STANDARDIZE in Excel?
The syntax is =STANDARDIZE(x, mean, standard_dev). x: The value to evaluate; mean: The average (mean) of the distribution; standard_dev: The standard deviation of the distribution.
Where can I practice STANDARDIZE online for free?
Open the free live spreadsheet on Cellgrids and try STANDARDIZE yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Statistical functions · Excel case studies · Excel tutorials · Excel shortcuts