Calculates a normalized value that represents the number of standard deviations by which the value of a random variable is above or below the mean of the distribution. This measure is often known as a standard score or z-score.
STANDARDIZE(Number; Mean; StDev)
Returns a real number which is the standardized value of the specified random variable for the given distribution mean and standard deviation.
Number is a real number or a reference to the cell containing that number which is the random variable value to be standardized.
Mean is a real number or a reference to the cell containing that number which is the arithmetic mean of the distribution.
StDev is a real positive number or a reference to the cell containing that number which is the standard deviation of the distribution.
- If StDev is less than or equal to 0, then the function returns an error value.
- The formula for STANDARDIZE is:
where X is the Number, μ is the Mean and σ is the StDev.
- For more details on the z-score, visit Wikipedia.
|=STANDARDIZE(11;10;1)||The function calculates a normalized value for the random variable 11 with mean 10 and standard deviation 1.||1|
|=STANDARDIZE(11;10;-1)||The function returns an error value since the standard deviation is less than 0.||Err:502|
|=STANDARDIZE(11;10;0)||The function returns an error value since the standard deviation is 0.||#DIV/0!|
Related LibreOffice functions:
Equivalent Excel functions: