Difference between revisions of "Manuals/calci/STANDARDIZE"
Jump to navigation
Jump to search
| Line 33: | Line 33: | ||
==References== | ==References== | ||
*[http://en.wikipedia.org/wiki/Standard_score Standrd Score] | *[http://en.wikipedia.org/wiki/Standard_score Standrd Score] | ||
| + | |||
| + | |||
| + | [[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | [[ Z3 | Z3 home ]] | ||
Revision as of 05:33, 9 March 2017
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.
- 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 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:
, 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.
, 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
- =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