Difference between revisions of "Manuals/calci/CHIINV"

From ZCubes Wiki
Jump to navigation Jump to search
 
(5 intermediate revisions by the same user not shown)
Line 3: Line 3:
 
*<math>degrees freedom</math> is the number of Degrees of Freedom.
 
*<math>degrees freedom</math> is the number of Degrees of Freedom.
 
*<math>Accuracy</math> is the correct decimal places of the result.
 
*<math>Accuracy</math> is the correct decimal places of the result.
 +
**CHIINV(), returns the inverse of the one-tailed probability of the chi-squared distribution.
 +
  
 
==Description==
 
==Description==
Line 11: Line 13:
 
*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 <math>X</math> has the chi-squared distribution with n degrees of freedom, then according to the definition, <math>\frac{1}{X}</math> has the Inverse-chi-squared distribution with <math>n</math> degrees of freedom;
 
*If <math>X</math> has the chi-squared distribution with n degrees of freedom, then according to the definition, <math>\frac{1}{X}</math> has the Inverse-chi-squared distribution with <math>n</math> degrees of freedom;
−
*If <math>CHIDIST (Number,DegreeOfFreedom)=probability</math>, then <math>CHIINV (probability,degrees_freedom,Accuracy,DivisionDepthArray)= Number</math>.  
+
*If <math>CHIDIST (Number,DegreeOfFreedom)=probability</math>, then <math>CHIINV (probability,degrees freedom,Accuracy,DivisionDepthArray)= Number</math>.  
 
*CHIINV use the iterating method to find the value of <math>x</math>.suppose the iteration has not converged after 100 searches, then the function gives the error result.  
 
*CHIINV use the iterating method to find the value of <math>x</math>.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   
 
  1.Any one of the arguments are non-numeric
 
  1.Any one of the arguments are non-numeric
−
  2.<math> degrees freedom</math> value is not an integer
+
  2.degrees freedom value is not an integer
−
  3.<math> degrees freedom < 1 </math>or <math>degrees freedom>10^{10}</math>
+
  3.degrees freedom < 1 or degrees freedom><math>10^{10}</math>
−
  4.Also <math> probability < 0 </math> or <math>probability>1</math>.
+
  4.Also probability < 0 or probability>1.
  
 
==ZOS==
 
==ZOS==
Line 31: Line 33:
 
#CHIINV(0.2547876,5) = 6.5669999999999655
 
#CHIINV(0.2547876,5) = 6.5669999999999655
 
#CHIINV(0.157299207050,1) = 1.9991000000000005
 
#CHIINV(0.157299207050,1) = 1.9991000000000005
−
#CHIINV(0.6785412,-1) = NAN
+
#CHIINV(0.6785412,-1) = #N/A (DEGREESOFFREEDOM < 1)
  
 
==Related Videos==
 
==Related Videos==

Latest revision as of 03:22, 25 August 2020

CHIINV (probability,degrees_freedom,Accuracy,DivisionDepthArray)


  • Where is the value associated with the Chi-squared Distribution
  • is the number of Degrees of Freedom.
  • is the correct decimal places of the result.
    • CHIINV(), returns the inverse of the one-tailed probability of the chi-squared distribution.


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 has the chi-squared distribution with n degrees of freedom, then according to the definition, has the Inverse-chi-squared distribution with degrees of freedom;
  • If , then .
  • CHIINV 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.degrees freedom value is not an integer
3.degrees freedom < 1  or degrees freedom>
4.Also  probability < 0  or probability>1.

ZOS

  • The syntax is to calculate CHIINV in ZOS is .
    • Where is the value associated with the Chi-squared Distribution
    • is the number of Degrees of Freedom
  • For e.g.,CHIINV(0.0257,3)
Inverse Chi-Squared Distribution

Examples

  1. CHIINV(0.0001234098,2) = 18
  2. CHIINV(0.2547876,5) = 6.5669999999999655
  3. CHIINV(0.157299207050,1) = 1.9991000000000005
  4. CHIINV(0.6785412,-1) = #N/A (DEGREESOFFREEDOM < 1)

Related Videos

Chi-Square Test

See Also

References

Inverse-chi-squared Distribution


Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/CHIINV&oldid=215049"