Excel Function : STANDARDIZE

Download now!

Excel Function : STANDARDIZE

Category

Statistical

Description

Returns a normalized value

Microsoft Excel Reference Page

https://support.office.com/en-us/article/STANDARDIZE-function-81d66554-2d54-40ec-ba83-6437108ee775

Syntax and Description of the STANDARDIZE Excel Function

The syntax for the STANDARDIZE function in Microsoft Excel is: =STANDARDIZE(x, mean, standard_dev) Where x is the value to standardize, mean is the mean of the data set, and standard_dev is the standard deviation of the data set.

About STANDARDIZE Excel Function

STANDARDIZE(x, mean, standard_dev) This function returns a normalized value (z-score) based on the mean and standard deviation provided. This is useful for standardizing data for further analysis.