Difference between revisions of "Manuals/calci/STANDARDIZE"

Revision as of 14:38, 12 June 2018

STANDARDIZE (X,Mean,StandardDeviation)

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.
In $STANDARDIZE(X,Mean,StandardDeviation)$ , $X$ is the value to be normalized , $Mean$ is the arithmetic mean of the distribution, and $StandardDeviation$ is the standard deviation of the distribution.
The equation for the normalized value is:

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

     1. Any one of the argument is non-numeric. 
     2. sd<=0

=STANDARDIZE(25,20,10.2) = 0.490196078431
=STANDARDIZE(52.5,42,3.25) = 3.230769230769
=STANDARDIZE(30,35,4.21) = -1.187648456057
=STANDARDIZE(2,0,5.3) = 0.377358490566
=STANDARDIZE(-2,1,6.17) = -0.48622366288

@@ Line 1: / Line 1: @@
-<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.
 ==Description==
 *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.
-*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:
 <math> Z= \frac{x-\mu}{\sigma}</math>, where <math> \mu </math> is the arithmetic mean and <math>\sigma </math> is the standard deviation.