Difference between revisions of "Manuals/calci/NORMINV"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''NORMINV'''('''p''','''m''','''sd''') '''Where p''' is a probability corresponding to the normal distribution ...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''NORMINV(prob,m,sd)'''</div><br/> |
| + | *<math>prob</math> is the probability corresponding to the normal distribution,<math>m</math> is the mean , and <math>sd</math> is the standard deviation. | ||
| − | + | ==Description== | |
| + | *This function gives the inverse of the normal cumulative distribution for the particular mean and standard deviation. | ||
| + | *If <math>NORMDIST(x,m,sd,TRUE)=prob</math>, then <math>NORMINV(prob,m,sd)=x</math>. | ||
| + | *<math>NORMINV</math> 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 <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 | ||
| + | 1. any one of the argument is nonnumeric | ||
| + | 2.Suppose prob<0 or prob>1 | ||
| + | 3.sd<=0. | ||
| + | *If m=0 and 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 | ||
| − | + | ==See Also== | |
| − | + | *[[Manuals/calci/NORMDIST | NORMDIST ]] | |
| − | + | *[[Manuals/calci/NORMSDIST | NORMSDIST ]] | |
| + | *[[Manuals/calci/NORMSINV | NORMSINV ]] | ||
| − | + | ==References== | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 04:49, 1 January 2014
NORMINV(prob,m,sd)
- is the probability corresponding to the normal distribution, is the mean , and is the standard deviation.
is the probability corresponding to the normal distribution,
is the mean , and 
is the standard deviation.Description
- This function gives the inverse of the normal cumulative distribution for the particular mean and standard deviation.
- If , then .
- 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 , where is the corresponding probability of the normal distribution, 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
, then 
.
using the iterating method to find the value of x.
, where 1. any one of the argument is nonnumeric 2.Suppose prob<0 or prob>1 3.sd<=0.
- If m=0 and 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