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.
PRODUCT & FEATURES
CAPTCHA Protection
RESOURCES
© 2023 Zapof