Difference between revisions of "Manuals/calci/CHIINV"
Jump to navigation
Jump to search
Line 9: | Line 9: | ||
*Degrees of freedom <math>df</math>=<math>(r-1)(c-1)</math>. | *Degrees of freedom <math>df</math>=<math>(r-1)(c-1)</math>. | ||
*The <math>\chi^2</math> static used to compare the observed value in each table to the value which would be the expected under the assumption. | *The <math>\chi^2</math> 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 | + | *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; |
− | *CHIINV | + | *If CHIDIST(x,df)=prob, then CHIINV(prob,df)= x. |
+ | *CHIINV use 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 | *This function will give the error result when | ||
− | + | Any one of the arguments are non-numeric | |
− | + | df value is not an integer | |
− | + | The df <1or df>10^10 | |
− | + | Also prob<0 or prob>1. | |
==Examples== | ==Examples== |
Revision as of 05:46, 3 December 2013
CHIINV(prob,df)
- Where is the probability value associated with the Chi-squared Distribution
- 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 Distribution and it is a Continuous Probability Distribution of a positive-valued random variable.
- Degrees of freedom =.
- The 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 use 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 non-numeric 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