Excel STANDARDIZE Function
Use:- Computes standard score (z score) for a given x score, mean and standard deviation
- Syntax:
- STANDARDIZE( x , mean , stdev
)
- Examples:
- Cell C6 formula: STANDARDIZE( B6 , C2 , C3 )
Cell C7 formula: STANDARDIZE( B7 , C2 , C3 ) 
- Note:
- STANDARDIZE is equivalent to (x-mean)/stdev
- Related Function:
- NORMSDIST