Spread Formula Reference
Formula Functions / Functions R to S / STANDARDIZE
In This Topic
    STANDARDIZE
    In This Topic

    This function returns a normalized value from a distribution characterized by mean and standard deviation.

    Syntax

    STANDARDIZE(x,mean,stdev)

    Arguments

    This function has these arguments:

    Argument Description
    x Value to normalize
    mean Arithmetic mean of the distribution
    stdev Standard deviation of the distribution Must be greater than zero.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    STANDARDIZE(15.6,A4,B2)

    STANDARDIZE(88,48,1.6) gives the result 25

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    NORMDIST | NORMSDIST | Statistical Functions