Manuals/calci/STANDARDIZE
Jump to navigation
Jump to search
STANDARDIZE(val, m, sd)
Where val is the value to normalize and m is the arithmetic mean and sd is the standard deviation of the distribution.
- When sd is equal to zero , the function displays infinity.
- The equation for calculating normalized value is:
It calculates a normalized value from a distribution characterized by mean and standard deviation
STANDARDIZE
Let’s see an example in (Column1 Row 1,Column1Row2, Column1 Row 3)
i.e.STANDARDIZE(val,m,sd)
=STANDARDIZE(C1R1,C1R2,C1R3)
=STANDARDIZE(50,40,2.5) is 4
Syntax
Examples
Description
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | 50 | 4 | ||
| Row2 | 40 | |||
| Row3 | 2.5 | |||
| Row4 | ||||
| Row5 | ||||
| Row6 | ||||
| Row7 | ||||
| Row8 | ||||
| Row9 |
