Documentation/How Tos/Calc: STANDARDIZE function

From Apache OpenOffice Wiki
Jump to: navigation, search


STANDARDIZE

Converts a value in a normal distribution to its equivalent in a standard normal distribution.

Syntax:

STANDARDIZE(n; μ; σ)

n is a number in a normal distribution with known mean μ and known standard deviation σ.
STANDARDIZE converts n to a corresponding value in a standard normal distribution, which has mean 0 and standard deviation 1.
STANDARDIZE calculates and returns (n - μ)/ σ.

Example:

STANDARDIZE(14; 10; 4)

returns 1. The original value 14 lies 1 standard deviation above the original mean 10; the new value lies 1 standard deviation above the new mean 0.



See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_STANDARDIZE_function&oldid=243475"
Views
Personal tools
Navigation
Print/export
Tools