Manuals/calci/STANDARDIZE

STANDARDIZE(x,m,sd)

• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } is the value.
• $m$ is the mean.
• Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd } 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 Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle STANDARDIZE(x,m,sd)} , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle x } is the value to be normalized , Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle m } is the arithmetic mean of the distribution, and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle sd } is the standard deviation of the distribution.
• The equation for the normalized value is:

Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle Z= \frac{x-\mu}{\sigma}} , where Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \mu } is the arithmetic mean and Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle \sigma } is the standard deviation.

• This function will give the result as error when

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

Examples

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

Related Videos

STANDARDIZE

See Also

• NORMDIST
• NORMINV
• NORMSDIST
• NORMSINV

References

• Standrd Score