Formulas and Functions
Modifying this control will update this page automatically

STANDARDIZE

The STANDARDIZE function returns a normalised value from a distribution characterised by a given mean and standard deviation. All arguments are number values.

STANDARDIZE(num, average, stdev)

num: The value to be evaluated.

average: The known average (arithmetic mean) rate at which events occur.

stdev: The standard deviation of the population. stdev must be greater than 0.

Example

=STANDARDIZE(6, 15, 2.1) returns approximately -4.28571428571429.

See alsoNORMDISTNORMINVNORMSDISTNORMSINVZTEST
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Helpful?
Character limit: 250
Maximum character limit is 250.
Thanks for your feedback.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.