Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / STANDARDIZE
In This Topic
    STANDARDIZE
    In This Topic

    Summary

    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

    See Also