Manuals/calci/NORMINV

Revision as of 03:49, 1 January 2014 by Devika (talk | contribs)
NORMINV(prob,m,sd)


  • 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   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

  1. NORMINV(0.01884908749,17.4,3.2)=10.750011
  2. NORMINV(0.998742,5.4,2.3)=12.349244172
  3. NORMINV(1,7.2,2.3)=NULL

See Also

References