In This Topic

STANDARDIZE

In This Topic

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

STANDARDIZE(*x*,*mean*,*stdev*)

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. |

Accepts numeric data for all arguments. Returns numeric data.

STANDARDIZE(15.6,A4,B2)

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

This function is available in product version 1.0 or later.

NORMDIST | NORMSDIST | Statistical Functions