Converts a random variable into a normalized variable, given its mean and standard deviation.
Syntax
n: The value to normalize. Eg., 14
μ: Arithmetic mean of the distribution. Eg., 5
Examples
Formula |
Result |
=STANDARDIZE(A2;B2;C2) |
4.5 |
=STANDARDIZE(A3;B3;C3) |
-0.142857143 |
=STANDARDIZE(A4;B4;C4) |
-4 |
Possible Errors
Errors |
Meaning |
#N/A! |
|
#NAME! |
|
#VALUE! |
|
#REF! |
|
#NUM! |
|
Similar Functions
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
Write to us: support@zohoforms.com