Changes

<div style="font-size:30px">'''STANDARDIZE(x,m,sd)'''</div><br/>

<div style="font-size:30px">'''STANDARDIZE (X,Mean,StandardDeviation)'''</div><br/>

*<math>x </math> is the value.

*<math>X </math> is the value.

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

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

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

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

**STANDARDIZE(),returns a normalized value.

==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)</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.  

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

*The equation for the normalized value is:

*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.  

<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 non-numeric.  

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

       2. sd<=0

       2. StandardDeviation<=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==

==References==

==References==