Difference between revisions of "Manuals/calci/NORMINV"
Jump to navigation
Jump to search
| Line 9: | Line 9: | ||
*In <math>NORMINV(prob,m,sd)</math>, where <math>prob</math> is the corresponding probability of the normal distribution, <math>m</math> is the arithmetic mean of the normal distribution and <math>sd</math> is the standard deviation of the normal distribution. | *In <math>NORMINV(prob,m,sd)</math>, where <math>prob</math> is the corresponding probability of the normal distribution, <math>m</math> is the arithmetic mean of the normal distribution and <math>sd</math> is the standard deviation of the normal distribution. | ||
*This function will return the result as error when | *This function will return the result as error when | ||
| − | 1. any one of the argument is | + | 1.any one of the argument is non-numeric |
| − | 2.Suppose prob<0 or prob>1 | + | 2.Suppose <math>prob<0</math> or <math>prob>1</math> |
| − | 3.sd<=0. | + | 3.<math>sd<=0</math>. |
| − | *If m=0 and sd=1,NORMINV uses the standard normal distribution. | + | *If <math>m=0</math> and <math>sd=1</math>, NORMINV uses the standard normal distribution. |
==Examples== | ==Examples== | ||
Revision as of 23:39, 6 January 2014
NORMINV(prob,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 prob} is the probability corresponding to the normal distribution, is the 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 sd} is the standard deviation.
is the 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 sd}
is the standard deviation.Description
- This function gives the inverse of the normal cumulative distribution for the particular mean and standard deviation.
- If 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 NORMDIST(x,m,sd,TRUE)=prob} , then 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 NORMINV(prob,m,sd)=x} .
- 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 NORMINV} using the iterating method to find the value of x.
- Suppose the iteration has not converged after 100 searches, then the function gives the error result.
- 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 NORMINV(prob,m,sd)} , 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 prob} is the corresponding probability of the normal distribution, 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 normal 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 normal distribution.
- This function will return the result as error when
1.any one of the argument is non-numeric
2.Suppose 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 prob<0}
or 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 prob>1}
3.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<=0}
.
- If 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=0} 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=1} , NORMINV uses the standard normal distribution.
Examples
- NORMINV(0.01884908749,17.4,3.2)=10.750011
- NORMINV(0.998742,5.4,2.3)=12.349244172
- NORMINV(1,7.2,2.3)=NULL