Manuals/calci/BETAINV

From ZCubes Wiki
Revision as of 23:49, 5 December 2013 by Devika (talk | contribs)
Jump to navigation Jump to search
BETAINV(prob,alpha,beta,a,b)


  • is the probability value associated with the beta distribution.
  • & are the values of the shape parameter.
  • & the lower and upper limit to the interval of .

Description

  • This function gives the inverse value of Cumulative Beta Probability Distribution.
  • It is called Inverted Beta Function or Beta Prime.
  • In , is the probability value associated with Beta Distribution, and are the values of two positive shape parameters and and are the lower and upper limit.
  • Normally the limit values are optional, i.e. when we are giving the values of & then the result value is from and .
  • When we are omitting the values and , by default it will consider and , so the result value is from and .
  • If , then .
  • use the iterating method to find the value of .suppose the iteration has not converged after 100 searches, then the function gives the error result.
  • This function will give the error result when
1.Any one of the arguments are non-numeric
2. or 
3. or 
4.we are not mentioning the limit values  for &, 
  by default it will consider the Standard Cumulative Beta Distribution,  and b = 1

Examples

  1. BETAINV(0.2060381025,5,9,2,6) = 3
  2. BETAINV(0.359492343,8,10) = 1.75
  3. BETAINV(0.685470581,5,8,2,6) = 3.75
  4. BETAINV(0.75267,1,7,7,9) = 7.25
  5. BETAINV(0.5689,-2,4,3,5) = NAN, because .

See Also

References

Beta Distribution