Manuals/calci/CHIINV

From ZCubes Wiki
Revision as of 03:46, 3 December 2013 by Jayaram (talk | contribs)
Jump to navigation Jump to search
CHIINV(prob,df)


  • Where 'prob' is the probability value associated with the chisquared distribution and 'df' is the number of degrees of freedom

Description

  • This function gives the inverse value of one_tailed probability of the chi-squared distribution.
  • It is called inverted-chi-square distributionand it is a continuous probability distribution of a positive-valued random variable.
  • In CHIINV(prob,df) where prob is the probability value associated with the chisquared distribution and df is the degrees of freedom.
  • Degrees of freedom=(r-1)(c-1).
  • The X^2 static used to compare the observed value in each table to the value which would be the expected under the assumption.
  • If X has the chi-squared distribution with \nu degrees of freedom, then according to the first definition, 1/X has the inverse-chi-squared distribution with \nu degrees of freedom;If CHIDIST(x,df)=prob, then CHIINV(prob,df)=x.
  • CHIINV 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.
  • This function will give the error result when
  1. Any one of the arguments are nonnumeric
  2. df value is not an integer
  3. The df <1or df>10^10
  4. Also prob<0 or prob>1.

Examples

  1. CHIINV(0.0001234098,2)=18
  2. CHIINV(0.2547876,5)=6.56699
  3. CHIINV(0.157299207050,1)=2
  4. CHIINV(0.6785412,-1)=NAN

See Also

References

Bessel Function