Changes

*<math> m </math> is the mean.

*<math> m </math> is the mean.

*<math> sd </math> is the standard deviation.

*<math> sd </math> is the standard deviation.

==Description==

==Description==

*This function gives the  normalized value of any distribution.

*This function gives the  normalized value of any distribution.

*Standardize is the normalized value for a distribution characterized by a given mean and standard deviation.  

*Standardize is the normalized value for a distribution characterized by a given mean and standard deviation.  

*In <math> STANDARDIZE(x,m,sd), x </math> is the value to be normalized , <math> m </math> is the arithmetic mean of the distribution, and <math> sd </math> is the standard deviation of the distribution.  

*In <math> STANDARDIZE(x,m,sd)</math>, <math>x </math> is the value to be normalized , <math> m </math> is the arithmetic mean of the distribution, and <math> sd </math> is the standard deviation of the distribution.  

*The equation for the normalized value is:<math> Z= \frac{x-\mu}{\sigma}</math>, where <math> \mu </math> is the arithmetic mean and <math>\sigma </math> is the standard deviation.  

*The equation for the normalized value is:

<math> Z= \frac{x-\mu}{\sigma}</math>, where <math> \mu </math> is the arithmetic mean and <math>\sigma </math> is the standard deviation.  

*This function will give the result as error when  

*This function will give the result as error when  

       1. Any one of the argument is nonnumeric.  

       1. Any one of the argument is non-numeric.  

       2. sd<=0

       2. sd<=0

==Examples==

==Examples==

#=STANDARDIZE(2,0,5.3) = 0.377358490566

#=STANDARDIZE(2,0,5.3) = 0.377358490566

#=STANDARDIZE(-2,1,6.17) = -0.48622366288

#=STANDARDIZE(-2,1,6.17) = -0.48622366288

==See Also==

==See Also==

*[[Manuals/calci/NORMSDIST  | NORMSDIST ]]

*[[Manuals/calci/NORMSDIST  | NORMSDIST ]]

*[[Manuals/calci/NORMSINV  | NORMSINV ]]

*[[Manuals/calci/NORMSINV  | NORMSINV ]]

==References==

==References==