Difference between revisions of "Manuals/calci/CHIINV"
Jump to navigation
Jump to search
(Created page with "<div id="6SpaceContent" class="zcontent" align="left"> '''CHIINV'''(Probability, DegreeOfFreedom) where, '''Probability''' - probability associated with the chi-squ...") |
|||
| Line 1: | Line 1: | ||
| − | <div | + | <div style="font-size:30px">'''CHIINV(prob,df)'''</div><br/> |
| + | *Where 'prob' is theprobability 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 | ||
| + | #Any one of the arguments are nonnumeric | ||
| + | #df value is not an integer | ||
| + | #The df <1or df>10^10 | ||
| + | #Also prob<0 or prob>1. | ||
| − | + | ==Examples== | |
| − | + | #CHIINV(0.0001234098,2)=18 | |
| + | #CHIINV(0.2547876,5)=6.56699 | ||
| + | #CHIINV(0.157299207050,1)=2 | ||
| + | #CHIINV(0.6785412,-1)=NAN | ||
| + | ==See Also== | ||
| + | *[[Manuals/calci/CHIDIST | CHIDIST ]] | ||
| + | *[[Manuals/calci/CHITEST | CHITEST]] | ||
| − | + | ==References== | |
| − | + | [http://en.wikipedia.org/wiki/Bessel_function| Bessel Function] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Revision as of 03:42, 3 December 2013
CHIINV(prob,df)
- Where 'prob' is theprobability 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
- Any one of the arguments are nonnumeric
- df value is not an integer
- The df <1or df>10^10
- Also prob<0 or prob>1.
Examples
- CHIINV(0.0001234098,2)=18
- CHIINV(0.2547876,5)=6.56699
- CHIINV(0.157299207050,1)=2
- CHIINV(0.6785412,-1)=NAN