Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Statistical > STANDARDIZE
 

STANDARDIZE(x, mean, standard_dev)

 
 Returns a normalized value from a distribution characterised by a mean and a standard deviation.

 xThe value you want to normalize.
 meanThe arithmetic mean of the distribution.
 standard_devThe standard deviation of the distribution.

 REMARKS
 
  		• If "standard_dev" = 0, then #NUM! is returned.
     
  		• If any of the arguments are not numeric, then #VALUE! is returned.

     EXAMPLES
     
     A
    1=STANDARDIZE(42,40,1.5) = 1.333
    2=STANDARDIZE(42,50,1.5) = -5.333
    3=STANDARDIZE(42,42,1.5) = 0
    4=STANDARDIZE(42,40,2) = 1
    5=STANDARDIZE("some text",40,2) = #VALUE!
    		 
     Functions - S | Index - S | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top